
10-10-2006, 18:46
|
|
Junior Member
|
|
Join Date: Oct 2006
Posts: 10
|
|
How to Change MSSQL 'SA' password
Hello,
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 and type in command prompt “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
|
Now try to login to MSSQL using new password.
- Firew@ll
|