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 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. To use combined authentication, select the SQL Server and Windows Authentication mode option button. Now users in Windows domains can access the server using a domain account, and other users can be logged on using a SQL ...
Get Microsoft® SQL Server™ 2005 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.
