How to Reset/Change Your Lost SQL sa Password by Windows Authentication

In today's article I will show you easy and simple tutorial with example how you can reset or change your lost SQL server sa password by windows authentication. So, for this here are the steps to reset or change the lost sa password. 

Step 1:

Login to your system as an administrator and open Microsoft SQL client. Now try to login with use "sa". You will not be able to login.

Step 2:

Now login to your SQL server using windows authentication.

Step 3:

In this step we need to open Object Explorer → Security → Logins. Ones we click on login folder We need to select the user "sa".

Step 4:

Richt clicks on user "sa" and select Property.

Step 5:

Now here you will get a field named as password. Here you need to add both the add your new password. Here your new password and confirm password must be same.

After adding new password, you need to click on Ok. Now try login for user "sa" with new password.