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
By this command you'll connect to MSSQL server using administrator account.
3) To change sa password you should execute the following query:
Now try to login to MSSQL using new password..
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
osql -S copied_servername -E
3) To change sa password you should execute the following query:
sp_password NULL,'new_password','sa'
go
go
Comment