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>Search


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

Knowledge Base

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

Publication Date:  2012-09-17  |   Views:  390  |   Downloads:  0  |   Author:  w00226954  |   Document ID:  EKB1000014883


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