[How To] Change password of the `sa` user in MS SQL

Created:

2016-11-16 13:09:45 UTC

Modified:

2017-04-24 11:23:03 UTC

0

Was this article helpful?


Have more questions?

Submit a request

[How To] Change password of the `sa` user in MS SQL

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Question

How to change password of the sa user of MS SQL server?

Answer

For the local server use the following command:

osql -E -Q "exec sp_password NULL,'new_password','sa'"

For the remote server use the following command:

osql -S servername_or_address -E -Q "exec sp_password NULL,'new_password','sa'"

Note : To be able to perform the above actions the current account must have administrative privileges on the server.

Have more questions? Submit a request
Please sign in to leave a comment.