Backing up Microsoft SQL Server
167
SonicWALL CDP 6.0 Administrator’s Guide
Step 5
Select the
System Administrators
role.
Step 6
Click the
Database Access
tab.
Step 7
Make sure that the user has the
db_owner
role, and make sure that access is permitted to the
databases to backup.
SQL Authentication
For access to Microsoft SQL Server, SonicWALL CDP uses Windows Authentication in which
the Windows user credentials are submitted to SQL.
This section contains the following subsections:
•
“Authentication Modes in Microsoft SQL Server” section on page 167
•
“About Windows Authentication” section on page 168
•
“About SQL Server Authentication” section on page 169
•
“Setting Up Windows Authentication Mode Security” section on page 169
•
“Setting Up Mixed Mode Security” section on page 170
Authentication Modes in Microsoft SQL Server
Microsoft SQL Server can operate in one of two security (authentication) modes:
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...
