SQL SERVER – How to change sa password

  • Login into SQL Server using Windows Authentication.

  • In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.




  • Change the passwork and click ok. Now you have successfully changed the sa password.

  • Make sure to restart the SQL Server and all its services and test new password by logging into system.

0 comments:

Post a Comment

 
Copyright © My Beat