MSSQL Server Regitsration Fails In Plesk Windows Server

[jominj]

While registering MSSQL server on a Windows Plesk server we may get the following error:

Code: [Select]

    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:

Code: [Select]

%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