There are many situations that people forgot the SA password shortly after installing the MS SQL Server. This article shows you the methods to help you change forgotten SA password for your SQL Server 2000/2005/2008/2012/2014 database installation.You can use any of below methods to change SQL Server Password. You can also download any third party tool for the same but for security prospective you should do this by your own.
Method 1: Change SQL Server Password in Management Studio
If you’ve forgotten the sa password for your SQL server, you will try to search for ways to change your sa password. Fear not, for you can change the password and once again have access to the powers of the SA account using Windows Authentication mode.
- 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.
Method 2: Change SQL Server Password Using SQL Script
- Open the SQL Server Management Studio.
- Open a New Query.
- Copy, paste, and execute the following:
1234567GOALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]GOUSE [master]GOALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGEGO
where NewPassword is the password you wish to use for the sa account.
Any third party tool can also be used to change/reset you sa Password but we would suggest you to change sa password preferably using Management Studio or using SQL Script.