Article ID: 129476, created on Sep 21, 2016, last review on Sep 21, 2016

  • Applies to:
  • Plesk Automation 11.5

Symptoms

  1. Not possible to register existing MSSQL instance in Plesk Automation 11.5.
  2. MSSQL is configured and available from PA Management node (default port is 1433).
  3. In SQL Server Logs following error appears:

    Login failed for user 'someusername'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only.
    

Cause

The MS SQL Server is only configured for Windows authentication. The 'someusername' login can only connect to the server using SQL Server Authentication.

Resolution

  1. To enable "SQL Server and Windows Authentication mode", refer to this Microsoft article.

  2. Restart MSSQL DB engine to apply changes.

  3. If the issue is not resolved, check the Windows Event logs > Application where Source is MSSQLSERVER and the Task Category is Logon.

Search Words

Get database server version failed

MSSQL Login failed for user

Test connection to the database server has failed because of network problems

Server is configured for Windows authentication only

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF