Changing MSSQL sa password

[Shane Melson]

Following are the steps to change MSSQL 'sa' login password:

1) Go to the command prompt of the server and type in command prompt

Quote:

osql -L

This command will list all the MSSQL servers near you.

2) Copy full name of required MSSQL server and type

Quote:

osql -S copied_servername -E

By this command you'll connect to MSSQL server using administrator account.

3) To change sa password you should execute the following query:

Quote:

sp_password NULL,'new_password','sa'
go