Reset  SA Password of MSSQL DataBase

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
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:
sp_password NULL,’new_password’,’sa’
go

Now try to login to MSSQL using new password..

Leave a Reply