locked
system administrator password reset RRS feed

  • Question

  • I have inherited a sql server and no one knows the SA password.  I cannot login with windows authentication even if the account is administrator of the machine. Please advise.

    avnish sharma

    Friday, August 7, 2015 1:04 PM

Answers

All replies

  • Hello,

    See Connect to SQL Server When System Administrators Are Locked Out for how to solve it.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, August 7, 2015 1:15 PM
  • I followed the documentation but it still does not let me sign with windows authentication. I get the error persistently: Microsoft sql error 18456. I added the administrator in the group  SERVERMSSQLUSER as well.  Is ther anything specific about 2008R2

    avnish sharma

    Friday, August 7, 2015 7:01 PM
  • Is ther anything specific about 2008R2

    No, and if you follow the instructions step by step then it should work; I done it several time with different version and it always worked for me.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, August 7, 2015 7:06 PM
  • Here's a link which illustrate what Olaf has proposed by images.

    Follow it step by step.

    https://ahmedkasmi.wordpress.com/2013/04/08/how-to-recover-sa-password-on-microsoft-sql-server-2008-r2/


    Please click "Mark As Answer" if my post helped.

    Friday, August 7, 2015 7:12 PM