Symptoms
- Unable to copy database or change database user’s password with the following error:
PLESK_ERROR: Error : Error: mssqlmng failed: ‘user_name’ is not a valid login or you do not have permission.Â
- Login to user MSSQL database via Plesk > Subscriptions > example.com > Database > example >myLittleAdmin fails with the following error:
PLESK_INFO: myLittleAdmin Silent Logon Error
Login failed for user ‘user_name’
Cause
Database inconsistency.
Resolution
Click on a section to expand
From Plesk interface
- Remove the user under Plesk > Subscriptions > example.com > Databases > User Management > select user “user_name” and click Remove .
- Recreate the user with the same name and password Plesk > Subscriptions > example.com > Databases > User Management :
3.1. Select MSSQL server in Database Server .
3.2. Type the necessary Database username and password .
3.3. Select the necessary Database .
3.4. Select Use this user’s credentials by default for accessing myLittleAdmin
3.5. Click OK
Click on a section to expand
From RDP access to the server
- Connect to the server via RDP
Note: if direct RDP access to the server is not possible, contact server administrator for further assistance.
- Open Command Prompt as AdministratorÂ
- Recreate missing users running the command below:
C:> plesk repair mssql -database-users