How to Change MSSQL 'SA' password

[Albert.Nawaro]

How to Change MSSQL 'SA' password
Hi,

SA login is the administrative login for the MSSQL.. To Change the MSSQL SA password you have to execute following commands from command prompt of your server:

1) Go to the command prompt of the server & type in command prompt osql -L
This command will list all the MSSQL servers near you.

2) Copy full name of required MSSQL server & type
Code:

PHP Code:

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:

Code:

PHP Code:

sp_password NULL,'new_password','sa'
 go 


Now try to login to MSSQL using new password..