Post reply

Help please! I had disabled my local admin account

  • February 21, 2011 at 5:51 am

    #235286

    Hello, please help -

    I have SQL 2008 on my pc, windows authentication - using windows administrator account.

    Now I have disabled win admin account in SQL (for testing an app), enabled SA - but forgot to change SQLServer's authentication mode.

    Is there a way to connect now, when mode is windows authentication and I have disabled single windows user?

  • February 21, 2011 at 6:03 am

    #1289389

    http://msdn.microsoft.com/en-us/library/ms188236.aspx

    Carlton

  • February 21, 2011 at 6:12 am

    #1289393

    You can change back to Windows and SQL Authentication by editing the registry.

    Change the value for this key to 2 (it's probably 1 at the moment):-

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.[your instance name]\MSSQLServer\LoginMode

  • February 21, 2011 at 6:24 am

    #1289401

    Ian,

    thanks for your response - it worked fine!

    Alexey

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

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