Reset Forgotten Sa password
To configure startup options
- Login computer from administrator Account
- At SQL Server Configuration Manager, click SQL Server Services.
- In the right side, right-click SQL Server (<instance_name>), and then click Properties.
- Startup Parameters boxtype the parameters separated by semicolons (;). at the Advanced tab, ,
For example, to start in single-user mode, insert -m; in front of the existing startup options, and then restart the database.
Important you must remove the -m; after finished using single-user mode, from the Startup Parameters box before you can start a multiuser mode in production. - Click OK.
- Restart the Database Engine.
- Change security authentication mode (You may not require this step if you have already enabled sa user)
- In SQL Server Management Studio Object Explorer, right-click the server, and click Properties.
- On the Security page, under Server authentication, select the new server authentication mode, and click OK.
- In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
- You can change password here.
- Enable the sa login by using Management Studio(You may not require this step if you have already enabled dual authentication )
- In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
- On the General page, you might have to create and confirm a password for the sa login.
- On the Status page, in the Login section, click Enabled, and then click OK.
- Now you can logon with sa user and password .You can also set permission of the local user account from that.