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 TierBack to
Frequently Asked Questions