Plesk for Windows
kb: technical
Applicable to:
- Plesk for Windows
Symptoms
When registering a new Microsoft SQL Server in Plesk at Tools & Settings > Database Servers > Add Database Server, the operation fails with:
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'.
Cause
The MS SQL user which was used to register a SQL Server instance does not exist: there is no Administrator
user in SQL Management Studio under the section Security > Logins.
Resolution
Add the MS SQL database server using the sa
(System Administrator) user.
Note: If the password of the sa
user is unknown, reset it.
Comments
1 comment
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.