Post reply

How to change security back to SQL

  • March 31, 2005 at 8:36 am

    #185577

    I was testing the Windows Authentication security on my Server and now that I need to change the properties back to SQL authentication, the system does not let me get to it. It tells me that only user with sysadmin rolles are allowed. I'm using the only user I have in Windows, which is the Computer Administrator. I have all the groups in windows assigned to this user.

    Thanks....

  • March 31, 2005 at 8:53 am

    #549856

    Hi,

    Read this

    http://www.microsoft.com/sql/techinfo/tips/administration/May3.asp

    and change this:

    • In SQL Server 7.0, the key is:

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft \MSSQLServer\MSSQLServer\LoginMode

    • In SQL Server 2000, the key is:

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft

      MicrosoftSQLServer\<instance_name>\MSSQLServer\LoginMode

    The value of LoginMode is 1 for Windows Authentication only, and 2 for Mixed Mode. After locking yourself out, you can change the value of LoginMode to 2, restart SQL Server, and log in as the system administrator (sa), provided you know the sa password.

    Yelena

    Regards,Yelena Varsha

  • March 31, 2005 at 10:19 am

    #549883

    Thank you, That Did it.

    Thanks.....

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

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