\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
or for a named instance:
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft
\Microsoft SQL Server\
REG_DWORD, 2
Monday, 21 May 2007
To enable SQL Authentication for the default instance using T-SQL
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft
\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
or for a named instance:
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft
\Microsoft SQL Server\\MSSQLServer\', N'LoginMode',
REG_DWORD, 2
\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
or for a named instance:
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft
\Microsoft SQL Server\
REG_DWORD, 2
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment