Resolved Update sa password for MS SQL from plesk

[Nitesh]

Hello, By mistake we have changed the password for "sa" user on MS SQL instance directly from SSMS. Once this has been done, we're unable to make any changes via the Plesk panel.

It says "Error: The test connection to the database server has failed because of an unacceptable password:

mssqlmng failed: Login failed for user 'sa'."

Please help me resolve this. Thanks in advance.

 

[IgorG]

Please help me resolve this.

Have you tried solutions from this KB article How to reset a password for the 'sa' user of a Microsoft SQL Server instance ?

 

[Nitesh]

Hi Igor, I have tried the link using "Microsoft SQL Management Studio" approach. I feel that Plesk stores the "sa" password at soem instance. Since, the password was changed directly from RDP, Plesk has no idea regarding the new password.

 

[PavelV]

If you have modified SA password inside MSSQL instance, you can just set this new password in Plesk, and everything should work properly.
Go to Tools&Settings -> Database Servers -> your server -> Settings

And here please specify new password for SA, so Plesk will know how to connect to this instance.

 

[Nitesh]

Thanks PavelV. It works like a charm!