Sunday, August 7, 2011

Change SQL Server Password by Windows Authentication

Change SQL Server Password

Change SQL Server Password by Windows Authentication

If Builtin/Administrator is present in SQL Server, you can login with an ID which is member of Administrators group and reset sa password in SQL Server. Just do as follows:

  • 1. Login into SQL server using Windows Authentication.
  • 2. In Object Explorer, open Security folder, open Logins folder. Right Click on sa account and go to Properties.
  • 3. Type a new SQL sa password, and confirm it. Click OK to finish.
After restarting SQL Server and all its services, you can log into SQL Server by sa login with new SQL sa password.


No comments:

Post a Comment