Posts Tagged ‘login using Windows Authentication’
Change MSSQL 2005 Express ‘SA’ password From Command Prompt
Written by Mike on October 17, 2008 – 2:20 pm -SA is the administrative login for the MSSQL. To Change the MSSQL SA password please use following steps:
Step 1. Go to the command prompt of the server ( Start >> Run >> Cmd ) and type in command prompt
osql –L
This command will list all the MSSQL servers near you.
Step 2. Copy full name of required MSSQL server and type
osql -S copied_servername –E
By this command you’ll connect to MSSQL server using Server administrator account (Windows Authentication).
Step 3. To change sa password you should execute the following query:
1> sp_password NULL,’new_password’,'sa’
2> go
Here the new_password will be the password which you want to set.
Now try to login to MSSQL using new password.
Tags: Change MSSQL 'sa' password, login using Windows Authentication
Posted in Windows VPS | 3 Comments »








