April 13, 2007 at 5:33 am
I wonder if anyone can help.
I have set up 2 identical servers, side by side. Connected internally.
Primary: MSSQL0
Secondary: MSSQL1
Using the Copy Database Wizard i am trying to copy a db from primary to the secondary (using both windows or sql authentication). just gives me an error saying "The job failed check the event log on the destination server for details."
Here is the output from the viewer:
Event Name: OnError
Message: Failed to connect to server MSSQL0.
StackTrace: at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp)
InnerException-->Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
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: MSSQL0_MSSQL1_Transfer Objects Task
Source ID: {1F4BFADD-65D5-446F-A74A-6FA4C2F38DF0}
Execution ID: {DF579362-F50B-4D33-B1B5-456251359D5E}
Start Time: 05/04/2007 11:36:42
End Time: 05/04/2007 11:36:42
Seems like its some sort of permissions issue but not sure what can be changed in the wizard?
April 13, 2007 at 6:24 am
Hi,
This is a very usefull link where all SQL 2005 connectivity related issue has been discussed.
"More Green More Oxygen !! Plant a tree today"
April 15, 2007 at 5:42 am
For reference. I just used the sa login rather than the Windows user and it worked.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply