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:
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