Applicable to:
- Plesk Onyx for Windows
Symptoms
-
Database server keeps getting disconnected (the icon is greyed out in Tools & Settings > Database Servers);
-
The following error is shown in the
%plesk_dir%admin\logs\php_error.log:
CONFIG_TEXT: [2018-05-08 15:22:36] ERR [1] "C:\Program Files (x86)\Plesk\admin\bin\mssqlmng" --check "--server=.\MSSQLSERVER2016" "--login=sa" "--password=*****" failed with code 1.
stdout:
Login failed for user 'sa'.
at (VADOConnection::open line 48)
at Unable to ADO conect with connection string: Provider=SQLNCLI11;Initial Catalog=master;Data Source=.\MSSQLSERVER2016(VADODatabaseProvider::connect line 182)
at execute console command --check(vconsoleapp::start line 93)
at execute "C:\Program Files (x86)\Plesk\admin\bin\mssqlmng" --check "--server=.\MSSQLSERVER2016" "--login=sa" "--password="(vconsoleapp::run line 110)
-
The
sauser is locked out as it can be found in SQL Server Management Studio > Security > Logins > sa > Properties > Status:
-
The
sauser keeps getting locked after the unlocking.
Cause
Password Policy is set to lockout the account after a certain number of failed login attempts.
Resolution
-
Connect to the server via RDP;
-
Go to SQL Server Management Studio > Security > Logins > sa > Properties > General and untick the Enforce password policy box:
Note: Check the server's log in order to find out what is causing many failed login attempts.
Comments
2 comments
~~~~~~
~~~~~~
Hello @Shahzad,
Thank you for the input.
However, the cause of the issue in the article is that "sa" user being locked out due to a number of failed logins.
It is possible that the cause of the error is the same as in the article, however, it requires additional investigation in order to precisely determine the reason for it.
If the issue still persists I suggest submitting a request to Plesk support using instructions from the following article:
https://support.plesk.com/hc/en-us/articles/213608509-How-to-submit-a-request-to-Plesk-support-
Please sign in to leave a comment.