Post reply

lost SA pwd, disabled windows logon, no DAC enabled how to login with Builtin\administrators

  • April 7, 2009 at 6:45 am

    #129778

    i have a local vista machine installed sql server 2005 developer.

    i lost sa password, no other system admin login created, disabled windows trusted connection.

    is there a way to login to the sql server to enable & reset sa password?

    can i login using Builtin\Administrators account?

    Thanks.

  • April 7, 2009 at 7:34 am

    #973341

    I got it. I gave the other user in the same PC administrative access to SQL Server via Windows Groups. Then logged on to windows using other user & was able to login to SQL Server with SSMS.

    Thanks.

  • April 7, 2009 at 7:43 am

    #973353

    Thanks for the update.

    FYI, you cannot disable trusted authentication. You can disable SQL Authentication, but Windows is always enabled.

  • April 7, 2009 at 8:15 am

    #973391

    Thanks, Steve.

    We actually disabled the default trusted connection for testing purpose thinking we had the sa password. but unfortunately we didn't hence we had this problem. we disabled the trusted connection from status tab both disabled & denied access.

    but was able to enable creating a new user & granting it sysadmin on sql server.

    Thanks

    RJ

  • April 7, 2009 at 9:07 am

    #973481

    You are welcome. Glad it's working for you.

    You can't disable trusted connections. you can disable a login, which has a status tab, but that's not the server. If you call it a connection, then you confuse others, and perhaps confuse yourself as well.

    A login makes a connection. The connection is the link between the client and server, using the credentials of the login. It may or may not be denied.

    The admin access is by default. The local administrators have trusted connection access since that group has been added as a login to SQL by default.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply