- Plesk for Windows
Unable to change properties of MS SQL database server in Plesk. The following error is shown:
Error: The test connection to the database server has failed because of network problems:
Get database server version failed: mssqlmng failed: [DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.
at (VADOConnection::open line 48)
at Unable to ADO conect with connection string: Provider=SQLOLEDB.1;Initial Catalog=master;Data Source=,\localhost(VADODatabaseProvider::connect line 182)
at execute console command --get-server-version(vconsoleapp::start line 100)
at execute "C:\Program Files (x86)\Parallels\Plesk\admin\bin\mssqlmng.exe" --get-server-version "--server=,\localhost" "--login=sa" "--password=*"(vconsoleapp::run line 117)
(Error code 1)
Connection issue, incorrect login/password credentials or login is disabled.
Make sure that MS SQL Server and the SQL browser service are running on the server.
Make sure that you can log in to MS SQL server with the same username (usually it is "sa" user) and password that was specified in Plesk > Tools & Settings > Database Servers > MS SQL server . You can check the connection using SQL Server Management Studio.
Ensure that " SQL Server and Windows Authentication mode " and login for the user are enabled.
You should be able to connect to the MS SQL server using the hostname/instance name mentioned in the Plesk > Tools and Settings > Database Servers > MS SQL server
Make sure that 1433 port is opened for MS SQL instance and it is listening on it.
Make sure that the "Named Pipes" connection method is enabled in SQL Server Configuration Manager > Protocols for MS SQL instance.