Post reply

change the sql authentication mode

  • July 21, 2010 at 12:28 am

    #97398

    Hi,

    How to change the Authentication of SQL Server from Registry level.

    Thanks in advance.

  • July 21, 2010 at 1:31 am

    #1195994

    The T-SQL command executed by Management Studio when running this against SQL Server 2000 is:

    EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 1

    So, if you search the registry for the instance's settings, you should find the LoginMode value in Software\Microsoft\MSSQLServer\MSSQLServer. However, I would prefer to use Management Studio to configure this value, unless you were automating the installation process. And even then, you're better off using the T-SQL statement to edit this than directly editing the registry. For more information, see http://www.databasejournal.com/features/mssql/article.php/3672926/Scripting-the-Installation-of-SQL-Server-2005.htm

  • July 21, 2010 at 2:55 am

    #1196015

    Too Good! 🙂

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

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