Configuring Authentication and Auditing
You configure authentication and auditing options with the Security page of the Server Properties dialog box. This page is shown in Figure 6-2.
Figure 6-2. The Security page options.
Setting the Authentication Mode
SQL Server security is completely integrated with Windows domain security, allowing for authentication based on user and group memberships as well as standard SQL Server user accounts.
In the Server Properties dialog box, go to the Security page. The Server Authentication options on the Security page allow you to configure authentication. To use combined authentication, select the SQL Server And Windows ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
