Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Microsoft SQL Server › Configuring Microsoft SQL Server Security Settings › Authentication Requirements

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.