Microsoft® SQL Server® 2012 Bible

496

Part V: Enterprise Data Management

Security-Confi guration Properties

The security-confi guration properties, as shown in Table 19-4, control the security features

of SQL Server.

TABLE 19- 4 Security-Confi guration Properties

Property Level* Graphic Control Code Option

Server Authentication

Mode

S Management

Studio

Security Audit Level S Management

Studio

C2 Audit Tracing

Common Criteria

Compliance

S

S

Management

Studio

EXEC sp_configure 'c2 audit mode'

EXEC sp_configure

'common criteria compliance

enabled'

Cross Database

Ownership Chaining

S

D

Management

Studio

EXEC sp_configure 'cross db own-

ership chaining'

ALTER DATABASE xxx SET DB_

CHAINING {ON | OFF}

* The confi guration level refers to server, database, or connection.

The same security-confi guration options established during the installation are again pre-

sented in the Security tab of the Server Properties page (see Figure 19-8), so the confi gura-

tion may be adjusted after installation.

Server Authentication Mode

The server authentication modes are exactly the same as presented during the SQL Server

installation. Following are two server authentication modes:

■ (^) Windows Authentication mode: This uses Windows Authentication to validate
connections.
■ (^) SQL Server and Windows Authentication mode: This uses both SQL and Windows
Authentication to validate connections.
During installation, if you select SQL Server and Windows Authentication mode, you are prompted for an sa pass-
word. When you select Windows Authentication mode, the sa account gets a random strong password, unknown to
the user. When you change to SQL Server and Windows Authentication mode, the sa account is disabled. You need to
enable the sa account and then change the sa password to use the account (refer to Figure 19-8).
c19.indd 496c19.indd 496 7/30/2012 5:42:58 PM7/30/2012 5:42:58 PM
http://www.it-ebooks.info