Post reply

Error When Doing "Copy Database" On Remote SQL 2000 DB Using SQL 2005 Management Studio

  • August 22, 2007 at 9:54 am

    #197364

    Hello!

    I have been pulling my hair out trying to copy a remote database.

    Here is the scenario:

    - Connected via Cisco VPN to remote SQL Server 2000

    - Using SQL 2005 Server Management Studio locally

    - Have NO problem connecting to remote SQL 2000 sever (ie. I use "Connect - Database Engine" to connect to remote server; Databases show in Object Explorer, I can view tables, data, etc. with no problem)

    - Select "Tasks - Copy Database", enter source and destination info (destination is my local 2005 server), destination location, etc.

    - When I run it, each step is successful except "Execute SQL Server Agent Job"

    - I check the event log and get a timeout error (see below)

    I would REALLY appreciate any help with this. Thanks!

    EVENT ERROR :

    Event Name: OnError

    Message: Failed to connect to server TRIGG.

    StackTrace: at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()

    at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp)

    InnerException-->Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

    at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)

    at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)

    at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)

    at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable)

    at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)

    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

    at System.Data.SqlClient.SqlConnection.Open()

    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity)

    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()

    Operator: NT AUTHORITY\SYSTEM

    Source Name: TRIGG_HPPAV_Transfer Objects Task

    Source ID: {A54E217B-9C0A-4DA9-983D-7377816B2A5B}

    Execution ID: {A035152B-F012-48D2-9A17-BA4496D64C06}

    Start Time: 8/22/2007 11:45:28 AM

    End Time: 8/22/2007 11:45:28 AM

    Data Code: 0

  • August 23, 2007 at 5:53 am

    #728861

    Does the user that you are connecting to the Server as have the ability to run a SQL Server Agent job?

    Have a good day,

    Norene Malaney

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply