Articles in this section

See more

Unable to add MS SQL Server in Plesk: Login failed for user 'administrator'

Avatar
Kuzma Ivanov
Updated
Follow
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

Sort by Date Votes
  • Avatar
    European Academy Admin

    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.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles