How to change the SA password

RSS

» How to change the SA password

To change the SA password in Management Studio Express for SQL Server 2008:

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 the Data Tier

Back to Frequently Asked Questions

jProg is a registered trademark of Jeff Murray's Programming Shop, Inc. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to JeffMurray@jprog.com.