While registering MSSQL server on a Windows Plesk server we may get the following error:
Get database server version failed: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Error code 1)
Several condition can result in this issue:- MSSQL server is not installed.
- SQL Server Authentication mode which is enabled only for "Windows Authentication Mode".
- Incorrect hostname/instance name is used for MSSQL server.
Possible fix for these cases are: - Install the MSSQL server if it is not installed:
%plesk_bin%\ai.exe" --select-product-id panel --select-release-current --show-components
mssql2008 [up2date] - MSSQL 2008 server
mssql2008-only [up2date] - MSSQL 2008 server only
mssql2012 [install] - MSSQL 2012 server
mssql2012-only [install] - MSSQL 2012 server only
"%plesk_bin%\ai.exe" --select-product-id panel --select-release-current --install-component mssql2008-only
- Enable "SQL server and Windows Authentication Mode" and retry MS SQL registration in Plesk
- Make sure that you can connect to MSSQL server using the same hostname, user and password that you specify in Plesk Control panel->Tools and Settings->Database Servers