Migration Error

[buddychrist]

Hello

When i try to migrate a domain from one plesk 8.1 server to a plesk 8.2 server, everything is ok except database backup. Despite the Windows Account User has enough privileges i always get the same error:

Debug 31/08/2007 16:26:16.967 : /\/\/\/\/\/\/\/\ End SyncLog /\/\/\/\/\/\/\/\
Debug 31/08/2007 16:26:17.232 : ForeignMigratorCore.MigratorException: Error during prepare backup archive (C:\PMMtemp\migrator backup/2007_08_31_16[3]/psaDump.zip) ---> psabackup.InformationalException: Unable to create dump file for MS-SQL database siteset on domain raredesign.es ---> System.Data.SqlClient.SqlException: Cannot open database requested in login 'siteset'. Login fails.
Login failed for user 'SP2960A\sehnsucht'.
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 psabackup.data_base.onPostDumpOperation(XMLRow row, DumpEnv env, DumpOperation operation)
--- End of inner exception stack trace ---
at psabackup.data_base.onPostDumpOperation(XMLRow row, DumpEnv env, DumpOperation operation)
at psabackup.DumpEnv.XMLRow.onSaved(DumpEnv env)
at psabackup.DumpEnv.XMLRow.onSaved(DumpEnv env)
at psabackup.DumpEnv.XMLRow.onSaved(DumpEnv env)
at psabackup.DumpEnv.dump()
at psabackup.DumpEnv.start()
at PleskBackup811.PleskBackupDump.dumpBackup(String backupDir, ArrayList backupClients, ArrayList backupDomains)
--- End of inner exception stack trace ---

I cant backup a domain cause database always fail.
Please, i need help to solve my problem.

Thanks in advance!

 

[buddychrist]

Problem solved

PROBLEM SOLVED:

Don't know why the domain had associated a database that was erased a long time ago.

After trying to delete the database from the domain's database list using Plesk Control Panel without success, i deleted directly accesing mysql psa database:

mysql -u admin -p 'yourpleskadminpassword' -P8306 psa

It was necessary to eliminate corresponding entries from tables "data_bases" and "db_users".

After that the migration manager utility for plesk 8.2 worked like a charm.

Hope it helps anyone with a similiar problem!

 

[ldejager]

Thanks! This helped me with a migration from Plesk 8.1 to Plesk 8.3