- Not possible to register existing MSSQL instance in Plesk Automation 11.5.
- MSSQL is configured and available from PA Management node (default port is 1433).
SQL Server Logsfollowing error appears:
Login failed for user 'someusername'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only.
The MS SQL Server is only configured for Windows authentication. The 'someusername' login can only connect to the server using SQL Server Authentication.
To enable "SQL Server and Windows Authentication mode", refer to this Microsoft article.
Restart MSSQL DB engine to apply changes.
- If the issue is not resolved, check the
Windows Event logs > Applicationwhere Source is
MSSQLSERVERand the Task Category is