Posted by Jens on 09/13/05 14:32

-----------------------------------------------------------------
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q285097
-----------------------------------------------------------------
INF: How to Change the Default Login Authentication Mode to SQL While
Installing SQL Server 2000 Desktop Engine by Using Windows Installer
-----------------------------------------------------------------
<snip>
Another way to change the security mode after installation is to stop
SQL Server and set the appropriate registry key for your installation:


Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode


Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode


to 2 for mixed-mode or 1 for integrated. (Integrated is the default
setup for the SQL Server 2000 Data Engine.)
</snip>


-URL----------------------------------------------------------------

• Next in forum: Find the Stored procedure
• Prev in forum: Re: Changing From Windows To Mixed Authentication
• Thread view: Re: Changing From Windows To Mixed Authentication

[Reply to this message]