No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

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

Publication Date:  2012-09-17 Views:  191 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