Applicable to:
- Plesk for Windows
Symptoms
-
When registering a new Microsoft SQL Server in Plesk at Tools & Settings > Database Servers > Add Database Server, after you enter a Username and Password and press OK, the operation fails with an error that is similar to the following:
PLESK_ERROR: Failed to connect to the database server: SQLSTATE[28000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'administrator'.
PLESK_ERROR: Failed to connect to the database server: SQLSTATE[28000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'sa'.
-
In Windows > Event Viewer > Windows Logs > Application, you can see information entries that are similar to the following:
CONFIG_TEXT: Login failed for user 'administrator'. Reason: Password did not match that for the login provided. [CLIENT: 203.0.113.2]
CONFIG_TEXT: Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 203.0.113.2]
Cause
The MS SQL user which was used to register a SQL Server instance in Plesk either does not exist or you are attempting to use an incorrect password for it, due to which the connection from Plesk to MSSQL cannot be established.
Resolution
Make sure that the MSSQL (Microsoft SQL Server) user and password you are using are accurate and try again..
If the password of the sa user (or another MSSQL user) is unknown, forgotten or lost, you can set a new one by using the steps in this article:
How to reset a password for the 'sa' user of a Microsoft SQL Server instance on a server with Plesk
Comments
I have this error when I'm trying to add MSSQL database server to Plesk.
Database server was created with error: The test connection to the database server has failed because of network problems: Failed to connect to the database server: SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].
What should I do? I have tried everything.
Please sign in to leave a comment.