Backing up Microsoft SQL Server
170
SonicWALL CDP 6.0 Administrator’s Guide
Step 2
Right-click a server, and then click
Properties
.
Step 3
On the
Security
tab, under
Authentication
, click
Windows only
.
Step 4
Under
Audit level
, select the level at which user accesses to Microsoft SQL Server are
recorded in the SQL Server error log:
•
None
causes no auditing to be performed.
•
Success
causes only successful login attempts to be audited.
•
Failure
causes only failed login attempts to be audited.
•
All
causes successful and failed login attempts to be audited.
Setting Up Mixed Mode Security
To set up Mixed Mode security with the SQL management interface:
Step 1
Expand a server group.
Step 2
Right-click a server, and then click
Properties
.
Step 3
On the
Security
tab, under
Authentication
, click
SQL Server and Windows
.
Step 4
Under
Audit level
, select the level at which user accesses to Microsoft SQL Server are
recorded in the SQL Server error log:
•
None
causes no auditing to be performed.
•
Success
causes only successful login attempts to be audited.
•
Failure
causes only failed login attempts to be audited.
•
All
causes successful and failed login attempts to be audited.
Summary of Contents for CDP 6.0
Page 15: ...xiv SonicWALL CDP 6 0 Administrator s Guide...
Page 99: ...Creating a Global Policy 84 SonicWALL CDP 6 0 Administrator s Guide...
Page 215: ...Recovering Data from Microsoft SQL Server 200 SonicWALL CDP 6 0 Administrator s Guide...
Page 229: ...Replacing the Downstream CDP Appliance 214 SonicWALL CDP 6 0 Administrator s Guide...
Page 267: ...Contributors 252 SonicWALL CDP 6 0 Administrator s Guide...
