error with Copy Database Wizard

[shoalcreek]

I am copying databases from SQL 2000 to SQL 2005. I have tried using the Copy Database Wizard many times. It fails on the "Execute SQL job agent." I have tried it over 20 times. Event Viewer keeps giving a 12550 error.

Here is what appeared in event viewer. It's pretty long:

Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 2/27/2008
Time: 4:15:55 PM
User: NT AUTHORITY\SYSTEM
Computer: SQL2005-TEST
Description:
Event Name: OnError
Message: Failed to connect to server clustersql.
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 'CORP\SQL2005-TEST$'.
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.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
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: clustersql_SQL2005-TEST_Transfer Objects Task
Source ID: {2924D7E4-E981-4674-AE96-6B5ED0DC3890}
Execution ID: {F6372EB5-14D4-43BC-A3BD-82B94AA63971}
Start Time: 2/27/2008 4:15:55 PM
End Time: 2/27/2008 4:15:55 PM
Data Code: 0

It seems as though there is some issue with permissions. I am using a Windows account that is in the Domain Admins group. It should have access to everything.

Some forums have said that the wizard is "flaky." But I would like to know what needs to be done to get this to work. I just went to Barnes and Noble to see if any books would have the answer. None of them did, and I must have looked at well over ten.

Named pipes and TCP/IP are enabled on both servers. I am using the detach-attach method.

I have done some backups and restores. Those have worked fine.

Please give detailed answers. Thank you.

 

[mrdenny]

See my response in your other thread.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[shoalcreek]

Thank you for your help, Denny.