Connection to the database server has failed because of network problems

Connection to the database server has failed because of network problems: Get database server version failed: Login failed for user ‘sa’.(Error code 1)

Description:

While try to reset the password of the database user name in plesk control panel it is giving error.Users are not connecting with the new passwords.

Solutions:

Database default user sa password is not sync with Plesk database user.Normally this issue raised if the password was changed from the server it will not communicate with the plesk database user.

– Log in to the server with Administrator account.

– open command prompt.

– Go to the below mention path

C:\Program Files (x86)\Parallels\Plesk\admin\bin>

– Now follow the below steps,

          C:\Program Files (x86)\Parallels\Plesk\admin\bin>plesksrvclient.exe -get

       C:\Program Files (x86)\Parallels\Plesk\admin\bin>cd %plesk_bin%

C:\Program Files (x86)\Parallels\Plesk\admin\bin>mssqlmng.exe –check –server=localhost –login=sa –password=XXXXXXXX

C:\Program Files (x86)\Parallels\Plesk\admin\bin>plesksrvclient.exe -get

      C:\Program Files (x86)\Parallels\Plesk\admin\bin>cd …/..

C:\Program Files (x86)\Parallels\Plesk>cd mysql/bin

          C:\Program Files (x86)\Parallels\Plesk\MySQL\bin>mysqldump.exe -u admin -p XXXXX -p8306 psa >C:\psa_backupxx-xx-xxxx-support.sql

– Now restart the plesk service.

– Try to change the password of the database user from plesk control panel.

Tags:Database,DB password,Parallels,Plesk control panel,Database issue,Hosting issues,Hosting panel,Hosting Tutorials,Hosting Articles.