Issue Migration Error | User or role 'user' does not exist in this database.

[riick]

Server operating system version

Microsoft Windows Server 2022

Plesk version and microupdate number

Version 18.0.59 Update #2

We are migrating websites from one Windows Plesk server to another Windows Plesk server and we got the following error from the migration tool:

Please advice:
Plesk restore report problem:
Failed deployment of user user for any database(domain domain.com)

---

Plesk restore report problem:
Execution of "C:\Program Files (x86)\Plesk\bin\database.exe" --update-dbuser user -server .\MSSQLSERVER2019:0 -domain domain -user-role readWrite -passwd "" -passwd_type sym -ignore-nonexistent-options failed with return code 1.
Stderr is
An error occurred while updating database user settings: Failed to update user permissions for user: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]User or role 'user' does not exist in this database.

---

Plesk restore report problem:
Execution of "C:\Program Files (x86)\Plesk\bin\database.exe" --update-dbuser user -server .\MSSQLSERVER2019:0 -domain domain -passwd "" -passwd_type sym -ignore-nonexistent-options failed with return code 1.
Stderr is
An error occurred while updating database user settings: Failed to update user permissions for user: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]User or role 'user' does not exist in this database.

Please help with this error.

thank you

 

[Kaspar@Plesk]

There is another known issue that generates the "User or role 'user' does not exist in this database." error. Perhaps the described solution in the knowledge base article helps in your case too:

https://support.plesk.com/hc/en-us/articles/12377864733847-Unable-to-activate-deactivate-domain-or-import-MSSQL-dump-in-Plesk-User-or-role-does-not-exist-in-this-database

 

[riick]

Thank you for your update. When I do RDP in the old server, it only have 2 options under Login. sa and Builtin users

Here in this error after migration, the error is due to a specific database user added in plesk