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?
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.