Page History: How do I change my SA password?
Compare Page Revisions
Page Revision: Wed, 25 Aug 2010 10:06
You will need to use Microsoft Management Studio or Management Studio Express to complete these steps. You can download the SQL Server 2008 Management Studio Express version from
http://www.microsoft.com/downloads/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=enhere.
To change the SA password in Management Studio:
- Connect to the database instance using Windows User Authentication
- Expand the instance
- Expand Security
- Expand Logins
- Right click on SA and select Properties
- Delete the old password and enter the new one
- Delete the old confirm password and enter the new one
- Click OK
- Disconnect from the database instance
- Reconnect to the database instance using the SQL Server Authentication
Back to
Frequently Asked Questions