Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Microsoft SQL Server › Configuring Microsoft SQL Server Security Settings › How User Authentication Is Changed

How User Authentication Is Changed

Regardless of the authentication option you choose, you must configure the Agent and confirm that the settings in Windows are configured to match. In addition, if you change the option, you must update any existing backup jobs to reflect the change. If you are using Microsoft SQL Server 2005 or later, you must update the setting separately for each instance of SQL Server.

To change user authentication and update the settings in both Windows and Arcserve Backup so that this change is reflected, perform the following process:

1. Check and change the Microsoft SQL Server authentication method.
2. Update the Agent for Microsoft SQL Server Account Configuration.
3. Check and change the ODBC (open database connectivity) settings.
4. Update existing backup jobs in Arcserve Backup.

More information regarding the steps in this process are contained in the following sections.