Post reply

login issues

  • February 2, 2006 at 1:06 am

    #111372

    My SQL server is configured to login with Windows authentication only. I was the system administrator (newbie) and I have deleted my own login.

    Since the server is configured as windows authentication, even "sa" can not login. What should I do to get access to the server?

  • February 2, 2006 at 1:37 am

    #618300

    Shailendra

    in the registry there's a setting HKey_Local_Machine\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode

    If you change this to 2, Sql logins are allowed and you can use the sa account to logon (if you know the password).

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • February 2, 2006 at 1:51 am

    #618306

    I did that. The value is 2 now. but I get the error that "sa" is not associated with a trusted connection. any other ideas?

    Thanks.

  • February 2, 2006 at 1:51 am

    #618305

    I did that. The value is 2 now (it was 1 earlier) . but I get the error that "sa" is not associated with a trusted connection. any other ideas?

    Thanks.

  • February 2, 2006 at 2:08 am

    #618308

    I had to restart the server and I could login as sa. Thanks a lot for the solution!

     

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

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