Question Database connection issues

[hzl]

Server operating system version

windows Server 2022

Plesk version and microupdate number

18.0.70

On the Database Settings page, select Refresh.

The following error page appeared.

密碼驗證失敗。密碼太短，不符合作業系統原則的要求
The translation within the red box is as follows:
Password verification failed. The password is too short and does not meet the requirements of the operating system.

The database version is MSSQL 2019, and the password is set to 16 characters or more, but the same error occurs.
The error message is the same when setting the database to the default database.


The following error page appeared.

密碼驗證失敗。密碼太短，不符合作業系統原則的要求
The translation within the red box is as follows:
Password verification failed. The password is too short and does not meet the requirements of the operating system.





The error message is the same when setting the database to the default database.

 

[alapshin]

Hello @hzl
Most probably the issue lays in Windows local password policy.
Try the following:
1. Connect to the server via RDP
2. [Winkey]+[R] and open secpol.msc
3. Account Policies > Password Policy and check/set requirements for password:



Submit a request to Plesk support for deeper inverstigation.

 

[hzl]

This machine adheres to the principle of setting the password length to 12 characters and enabling complexity.

 

[scsa20]

Use SSMS to edit the login for the SA account to a complex password and try updating the connection to utilize that new password.