Back to question Answer 1 of 1

Discuss Jennifer John's answer to: How to Reset MS SQL Server 2008 Password？

I’ve forgotten the password of SA account, therefore I am not able to login to my SQL Server 2008 R2. I have another account, but with no special privileges. Anyone here can tell me how to reset ...

Jennifer John Answered:

1.Open the SQL Server express management studio
2.Connect to SQL Server using windows authentication
3.Right click the server name and choose properties
4.Go to security tab. Change server authentication to “SQL Server and Windows Authentication mode”
5.Click OK and restart SQL Server
6.Go to SQL Server studio management express
7.Expand the server and choose security and expand logins
8.Right click on SA, from properties modify the password and confirm password