How to change "sa" password in SQL server management studio 2014
Before going ahead, I would like to share some thing which you might have also known earlier. There are two modes of connecting to SQL server in SQL server management studio. So if you are unable to authenticate using SQL server authentication, here's the way to change the password of your " sa " account. I have provided two solutions. Solution A: 1. Login using Windows authentication. ** Server Name will be your computer's name. Windows authentication 2. Once you successfully log in using Windows authentication, follow the steps as shown in figure below. Step 1: Expand "Security" => "Login" and look for "sa" Step 2: Right click on "sa" and select "Properties". Step 3: In the dialog box, make sure you check the option "Enforce password expiration". Click OK. 3. Now try to...