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