How to Change MSSQL 'SA' password

[firew@ll]

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

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.

- Firew@ll

[Rock]

Hello,

Many people are bored of the old black screen (command prompt). I like the way its done through a Graphical Interface.

To change the password on the 'sa' account from the graphical interfaces of MSSQL Server 7.0 and 2000 on both Windows NT 4.0 and 2000:

1. Open the "SQL Server Enterprise Manager". This is usually under "Start"-->"Programs"-->"Microsoft SQL Server".

2. Navigate to the "Logins" object under the "Security" folder on the SQL Server you wish to administer. Then, right click on the 'sa' account and select "Properties".

3. Now, enter a new password in the "Password" field under the "Authentication" options.

Thats it !