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

 

[riick]

I still have the same issue. Please help

 

[scsa20]

The steps would still be the same, you might need to add the user manually if needed. If you're still having issues, your best bet would be to open a ticket with Plesk themselves. The support is included free if you got the license directly from Plesk or you can buy a support subscription if you got the license through a third party (if you got the license through a third party, you can sign up for the support subscription and get a month free to use to get the support then cancel it after words). You can refer to https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk for more information of how to get support directly from Plesk.

 

[riick]

The steps would still be the same, you might need to add the user manually if needed. If you're still having issues, your best bet would be to open a ticket with Plesk themselves. The support is included free if you got the license directly from Plesk or you can buy a support subscription if you got the license through a third party (if you got the license through a third party, you can sign up for the support subscription and get a month free to use to get the support then cancel it after words). You can refer to https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk for more information of how to get support directly from Plesk.

Thank you!