Hosting Articles Technical Articles

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.

 

Connection to the database server has failed because of network problems

 

– 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.

About the author

admin

5 Comments

Click here to post a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.