Microsoft® SQL Server® 2012 Bible

834

Part VI: Securing Your SQL Server

You may also check the Authentication mode under the SQL Server properties in SQL Server

Management Studio under the Security tab, as shown in Figure 32-1.

FIGURE 32-1

SQL Server authentication in properties.

You can change the Authentication mode in SQL Server Management Studio (refer to Figure

32-1) or by modifying the LoginMode registry key found under Computer\HKEY_LOCAL_

MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.MSSQLServer\

MSSQLServer\where MSSQLServer is the instance name. Figure 32-2 shows the

LoginMode registry key in the Registry Editor.

You can manually change the LoginMode registry key in the Registry Editor or with the fol-

lowing T-SQL script:

EXEC xp_instance_regwrite

N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\MSSQLServer\MSSQLServer',

N'LoginMode', REG_DWORD, 1

c32.indd 834c32.indd 834 7/31/2012 10:01:03 AM7/31/2012 10:01:03 AM

http://www.it-ebooks.info