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>


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


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

Publication Date:  2012-09-17 Views:  261 Downloads:  0
Issue Description
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
Handling Process
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