How to change the SA password

Modified on Mon, 23 Jan 2012 17:42 by CAREWare Help Desk — Categorized as: FAQ

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

  1. Connect to the database instance using Windows User Authentication
  2. Expand the instance
  3. Expand Security
  4. Expand Logins
  5. Right click on SA and select Properties
  6. Delete the old password and enter the new one
  7. Delete the old confirm password and enter the new one
  8. Click OK
  9. Disconnect from the database instance
  10. Reconnect to the database instance using the SQL Server Authentication

Back to the Data Tier

Back to Frequently Asked Questions