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 login again using SQL server authentication. It will ask you for  a new password.
    note down your password this time somewhere so that you won't lose it again. This won't work           every time.

Solution B:

Create a new "sa" account by going to Security => Logins.  Right click on Logins and select "New Login".


These are some "luck by chance" or "hit and trial" methods as there is no practical mechanism to change your "sa" password.

Hope this helps. Happy querying. :)

Comments

Post a Comment

Popular posts from this blog

Silde show of images In JSP

In order to perform this, first create a folder in your project where you store your images to be used in the slideshow. Here the folder is 'newFolder'. <html> <head>     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <script type="text/javascript"> var slide = new Array() //array to load the images slide[0] = new Image() slide[0].src = "newFolder/image1.jpg" slide[1] = new Image() slide[1].src = "newFolder/image2.jpg" slide[2] = new Image() slide[2].src = "newFolder/image3.jpg" </script> </head> <body>     <img id="slide" src="newFolder/image1.jpg"   align="center" alt="Image not found"> <script type="text/javascript"> var step=0 function slideimages() { if (step<2)         step++;     else         step=0;  setTimeout("slideimages()",1000);  //function is...
Read more

Compression ratio, Compression factor, saving percentage in C++

#include<iostream.h> #include<conio.h> void main() { float ori,aft; float CR,CF,SP; clrscr(); cout<<"\nEnter the size of the source file : "; cin>>ori; cout<<"\nEnter the size of the compressed file : "; cin>>aft; CR=aft/ori; CF=ori/aft; SP=((ori-aft)/ori)*100; cout<<" Compression Ratio = "<<CR; cout<<"\n Compression Factor = "<<CF; cout<<"\n Saving percentage = "<<SP<<" %"; getch(); }
Read more

Working with database in Vb.net

Image
Fig: Design (grey square is the gridview) Source Code: Imports System.Data Imports System.Data.SqlClient Public Class Database_Connectivity     Dim conn As New SqlConnection("Data Source=.;Initial Catalog=practice ete;Integrated Security=True;Pooling=False") 'Inserting data     Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click         conn.Open()         Dim str As String = "insert into Table1 values(@id,@name,@age,@phone)"         'Dim str As String = "alter table Table1 add phone int"         Dim comm As New SqlCommand()         comm = New SqlCommand(str, conn)         comm.Parameters.AddWithValue("@id", TextBox1.Text)         comm.Parameters.AddWithValue("@name", TextBox2.Text)         comm.Parameters.AddWithValue("@age", ...
Read more