SQL SERVER – Change Password of SA Login Using Management Studio

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.

SQL SERVER - Change Password of SA Login Using Management Studio sapass1

Change SA password, and confirm it. Click OK.

SQL SERVER - Change Password of SA Login Using Management Studio sapass2

Make sure to restart the SQL Server and all its services and test new password by log into system using SA login and new password.

Reference : Pinal Dave (https://blog.sqlauthority.com)

UPDATE : There has been discussion about restarting the SQL Server and all its services. Please read all of them before making final decision for your scenario.

Previous Post
SQL SERVER – Difference Between Quality Assurance and Quality Control – QA vs QC
Next Post
SQL SERVER – Remove Duplicate Characters From a String

Related Posts

262 Comments. Leave new

  • Hi Dave,

    I followed your instructions above. but it seems like is not working on my end.

    Please Help.

    Got this Error Message after using the new Password

    Login failed for user ‘sa’. (Microsoft SQL Server, Error : 18456)

    Thanks,

    Reply
  • Hi Dave,

    Im using SQL server 2008 R2 and Windows 2008R2 server i would like to change both passwords.Is there SQL server 2008 R2 linked with Domine if linked it raise any error.this is live operation

    Reply
  • Hi All,
    Please me on below issue!!!!!!!!!
    I am using SQL Server 2008 R2 and Windows server 2008R2. My SQL Server Authentication setting is Mixed Mode there is windows login disabled and SA password also forgot.
    Is there any way to reset SA password please reveal me ?
    Appreciate the reply.

    Regards,
    Rajendiran

    Reply
    • Shashikant Singh
      June 25, 2013 9:43 pm

      Dear Sir,

      Follow The pinaldave Article->
      SQL SERVER – Change Password of SA Login Using Management Studio
      You can sure reset SA password.

      Regards,
      Shashikant

      Reply
  • Harish Ranganathansh
    July 4, 2013 7:54 pm

    This was very useful Pinal. Thanks! In addition, sometimes the SA login is disabled by default in certain server installations. So, after changing password, I also had to go and explicitly enable this login

    Reply
  • Sir, namskar , when I try for log in through ‘sa’ password= ‘sh’
    my sql server 2008 not login and show the following message
    ‘Login fail for user ‘sa’ Reason: The account is Disable (Microsoft Sql Server Error : 18470)

    Reply
  • I unable to change the password, its always fire a error message : Alert failed to Login ‘sa’ (Microsoft.SqlServer.Smo)

    Reply
  • Now I change the password after check the check box but unable to login with ‘sa’ usrname.
    ur suggestion required

    Reply
  • I am using sql server 2008 R2. I changed the password as mentioned in the article. I am getting below error when I am trying to login using sa and new password.

    TITLE: Connect to Server
    ——————————

    Cannot connect to ServernameInstancename

    ——————————
    ADDITIONAL INFORMATION:

    A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

    For help, click:

    ——————————
    BUTTONS:

    OK
    ——————————

    Reply
  • Chitakula Avinash
    August 18, 2013 6:14 pm

    I am using sql server 2012

    Reply
  • Grant Dornford
    August 21, 2013 4:01 am

    How do I change password on Cracker sa

    Reply
  • Hi Pinal, does sql 2k have an audit logs for every change of password? Thanks in advance

    Reply
  • Thanks…Good Tut.

    Reply
  • i am getting error that can not alter sa pawword

    can not set the principal for creditial ‘sa’
    i have also try to stop sql service but it is not showing any sql service running in congigration manager.insted of service it is showing error” remote procedure call failed”

    Reply
  • Dear Pinal,

    I follow the same process but getting below mention error kindly me asap , i done on my very important Db. I restart the services after that i m getting error
    TITLE: Connect to Server
    ——————————

    Cannot connect to SID-PCSQLEXPRESS.

    ——————————
    ADDITIONAL INFORMATION:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

    For help, click:

    Reply
  • This is not help full for me I want without Open sql login window Show my password

    Reply
  • i want to change setting of sa password from strong to normal or weak .
    i want to set password as “abcd” simple password . how to do it ?

    Reply
  • thank u so much

    Reply
  • Hello Pinal Sir. I am a new DBA. very very new and facing lots of problem everywhere. Any way..I forgot my sa passwword and thanks to your post i reset it.

    I have another question. I have installed second instance on my laptop. and also lost its id and password. How to get that?

    Reply
  • Good one

    Reply
  • Whats up very nice site!! Man .. Beautiful .. Amazing .. I’ll bookmark your web site and take the feeds additionally? I’m happy to find so many useful info here in the put up, we want work out extra techniques in this regard, thanks for sharing. . . . . .

    Reply

Leave a Reply

Menu