While doing some operation with MSSQL database\user, or with a subscription\customer that holds a MSSQL database we may get a error as follows :
Get database server version failed: Login failed for user "sa"or
Get database server version failed: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Error code )The reason for this is admin password for a mssql server instance stored in plesk database does not match actual administrative password
To solve this issue make sure that the password in the plesk panel and database server instance are the same.
- Set a password for the mssql server by login under the windows authentication mode
cd C:\Program Files\Microsoft SQL Server\100\Tools\Binn
osql -S .\MSSQLSERVER2008 -E -Q "EXEC sp_password @new='1qazXSW@', @loginame = 'sa'"- Now set the same password for the mssql in the plesk panel
1. Login to the plesk panel and Goto Home>>Tools & Settings>>Database Servers
2. Select the mssql server instance from the list
3. Click on the change password and set the same password that have been set from the command line.
