How do I change my SA password?

Modified on Fri, 20 Jan 2012 09:47 by CAREWare Help Desk — Categorized as: FAQ

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 here.

To change the SA password in Management Studio:

  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