Product:
Search Type:

[How To] Changing password of the `sa` user in MSSQL

Article ID: 870 
Last Review: Nov,26 2007
APPLIES TO:
  • Plesk 6.5 for Windows
  • Plesk 7 for Windows
  • Plesk 7.5.x for Windows
  • Plesk 7.5.6 for Windows
  • Plesk 7.5.5 for Windows
  • Plesk 7.6.x for Windows
  • Plesk 7.6.1 for Windows
  • Plesk 8.1.0 for Windows
  • Plesk 8.1.1 for Windows
  • Plesk 8.1 for Windows
  • Plesk 8.1.1.2 for Windows
  • Plesk 8.2 for Windows

RESOLUTION

For  MSSQL on the local server in the following command can be used:
osql -E -Q "exec sp_password NULL,'new_password','sa'" 

for remote server:

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


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

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields