How to: Change the Default Login Authentication Mode to SQL
Posted in SQL Server
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