How to Change the ‘sa’ password in SQL Server 2005,2008
Login into SQL Server using Windows Authentication.
In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.
Change SA password, and confirm it. Click OK.
Make sure to restart the SQL Server and all its services and test new password by log into system using SA login and new password.
1.Open the SQL Server express management studio
2.Connect to SQL Server using windows authentication
Method 3: (From Command prompt)
1. Start a command prompt by typing Start – Run – cmd
2. Enter the following commands, pressing Enter after each line
OSQL -S yourservername -E
1> EXEC sp_password NULL, ‘yourpassword’, ’sa’
Where yourservername is the name of your server and yourpassword is the new sa account password. Type exit twice to return to the server desktop.
Method 4: (Query) my personal favorite
Make a new query & write in it, then run.
USE [master] GO ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON GO USE [master] GO ALTER LOGIN [sa] WITH PASSWORD=N’<insert_new_password_here>’ MUST_CHANGE GO