Admin-Ahead Community

Windows => Control Panels => Plesk => Topic started by: jominj on February 10, 2014, 09:50:08 pm

Title: Error: Get database server version failed
Post by: jominj on February 10, 2014, 09:50:08 pm

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

Code: [Select]

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.