While changing the MSSQL database user we may see the following error near MSSQL server instance name:
Error: Test connection to the database server has failed because of network problems
The problem might be either due to problem in network connection or password synchronisation
How can we solve this?
Please do the following steps when you get this error:
- Make sure that MSSQL Server, SQL browser service are running on the server.
- Make sure that you can login to MSSQL server with the same username (usually it is "sa" user) and password that mentioned in Plesk Control panel->Tools and Utilities->Database Servers->MSSQL server. You can check connection using MSSQL Server Management Studio.
- Ensure that "sa" user (or other MSSQL admin user specified in Plesk) is enabled by logging to MSSQL Server. Check it with MSSQL Server Management Studio or other MSSQL database Manager.
- You should be able to connect to MSSQL server using hostname/instance name mentioned in Plesk Control panel->Tools and Utilities->Database Servers->MSSQL server
- Uncheck "Enforce password Expiration for "sa" user, because the reason may in in expired password.
- Make sure that the port 1433 is opened and listening by MSSQL instance.
- Make sure that "Nimed Pipes" connection method is enabled in SQL Server Configuration Manager->Protocols for MSSQLSERVER.
Doing these steps will help you solve the issue.