FAQ-A sa user of SQL Server 2005 forgot his password

Publication Date:  2012-09-17 Views:  120 Downloads:  0
Issue Description
Q:
After SQL Server 2005 installation, when installed SM and established SECODB, forgot SA password and can not continue next-step. How to solve the problem that SA user forgot password?
Alarm Information
None
Handling Process
A:
Ordinarily, SQL Server 2005 installation use “hybrid mode”. Can use Windows account  to login SQL Server 2005 first,then modify the sa password. Concrete operation as the follows:
Run SQL Server Management Studio, choice “Windows Identity Authentication” in “Identity Authentication”. Use Windows account  to login SQL Server 2005,choose “Security| Login name| sa in the left window options , click the user with the mouse right key, choose “Property”, entry the new passwords and confirm. Notice the password policy, if password is easy (as 123456), you need to cancel“Force Actualize Password Policy” option.
Root Cause
None
Suggestions
None

END