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.
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
Hmmmmm... what are you thinking? Do not forget to comment,It helps us to improve this blog and help us to make better. on