Appendix B: Configuring Microsoft SQL Server Security Settings 101
Appendix B: Configuring Microsoft SQL
Server Security Settings
This appendix explains how to configure Microsoft SQL Server security settings
for CA ARCserve Backup.
This section contains the following topics:
Types of Microsoft SQL Server Authentication
(see page 101)
Authentication Requirements
(see page 101)
How User Authentication Is Changed
(see page 102)
Types of Microsoft SQL Server Authentication
Microsoft SQL Server provides two types of user authentication:
■
Use the active Windows login identification
■
Use separate user credentials specific to Microsoft SQL Server
Although Microsoft recommends using only Windows authentication wherever
possible, in certain instances it is appropriate, or even necessary, to enable
Microsoft SQL Server-based authentication. For example, you must use
Microsoft SQL Server authentication for Microsoft SQL Server 7.0 or Microsoft
SQL Server 2000 when the database is running in a cluster.
Authentication Requirements
For Microsoft SQL Server authentication, you must specify a user account with
system administrator access privileges. By default, Microsoft SQL Server creates
an account with this level of access, called
sa
, but the Agent for Microsoft SQL
Server can use any account with equivalent privileges.
For Windows authentication, any account with administrator equivalency for the
machine on which the database is running typically has system administrator
access privileges for the database instance.
Note:
A Windows or domain administrator does not automatically have system
administrator access privileges for the database if the BUILTIN\Administrators
login entry in Microsoft SQL Server has been removed or does not have this role,
or if a separate login entry exists for this user in Microsoft SQL Server and does
not have this role.
