PleskMainDBException - Resolved

ISSUE: Logging into Plesk fails and you receive the following message:

ERROR: PleskMainDBException
Source: Microsoft OLE DB Provider for SQL Server
Description: Cannot open database "psa" requested by the login. The login failed.

0: plibcommon_func.php3:600
db_mssql_connection()
1: plibcommon_func.php3:629
reconnect()
2: plibcommon_func.php3:590
db_connect()
3: auto_prependauth.php3:87


CAUSE: This happens when Plesk is not able to log into its PSA database. The most common causes for this are:
1) SQL is not running
2) The "admin" user's password was changed.

RESOLUTION:
Part 1: Reset the "admin" password in SQL.

Log into the server via remote desktop
Ensure that SQL is running.
Open up SQL Server Management Studio and connect to the local server.
In Management Studio, Go to Security > Logins.
Right-Click on the "admin" user and select "Properties"
Under "Password" and "Confirm Password", type in the new password and then click "OK"

Part 2: Reset the "admin" password in Plesk.

Click on Start > Run. Type "cmd" and press enter.
In the command prompt, type (the quotes are required): "%plesk_bin%PleskSrvClient.exe"
A "Set Plesk Admin Password" dialog will appear. It will display an error message indicating that it can not connect to the Plesk SQL Server. That is OK.
Type in the same password you typed above and then click "OK" followed by "Yes".
You will now be able to log into Plesk with the password you entered.