"Unable to fix restored Microsoft SQL Server user" when migrate from Plesk 11.5 to Plesk 12.0.18

Created:

2016-11-16 13:19:36 UTC

Modified:

2017-08-08 13:22:57 UTC

0

Was this article helpful?


Have more questions?

Submit a request

"Unable to fix restored Microsoft SQL Server user" when migrate from Plesk 11.5 to Plesk 12.0.18

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

At the end of migrating from Plesk 11.5 to Plesk 12.0.18 (from Windows 2008 to Windows 2012 , from MSSQL 2008 to MSSQL 2012 ) we got the following warnings:

    Warning: database "U000001_AboothManual"
Unable to fix restored Microsoft SQL Server user abth_hout ( psadumpagent.InformationalException: Unable to fix restored Microsoft SQL Server user abooth_hout ---> System.Data.SqlClient.SqlException: An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, Run
Behavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at psadumpagent.RestoreEnv.checkRestoredMsSqlUsers(SqlConnection connection, String dbName) --- End of inner exception stack trace --- )

Cause

Complex non-standard scheme MSSQL on the source server.

Resolution

This warnings can be safely ignored. All objects should be translated properly.

Have more questions? Submit a request
Please sign in to leave a comment.