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

Refers to:

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

Created:

2016-11-16 13:19:36 UTC

Modified:

2016-12-21 20:27:52 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

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.