Sunday, 28 August 2011

Set SA Password in SQL Server Management Studio Express


During the installation of SQL Server,we select mixed mode authentication and give complex password for sa.Sometime we may need to change the password of sa.
To change the password of sa follow the below steps. 
1.Open SQL Server Express Management Studio.
2.Connect to SQL Server using windows authentication.
3. Expand the server and choose security and expand logins.
4. Right click on sa, from properties modify the password and confirm password
5. Uncheck Enforce password policy.
6.Click OK

No comments:

Post a Comment