Jul 25 2009 July 25, 2009 July 25, 2009 NoComment by christian

How to: Change the Default Login Authentication Mode to SQL

Posted in

How to Change the Default Login Authentication Mode to SQL

short description:
use SECURITYMODE=SQL as command line setup parameter when installing SQL Server
or
change one of the following registry keys:

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 security. (Integrated is the default setup for the SQL Server 2000 Data Engine.)

for more refer to article MS Q285097