How User Authentication Is Changed
102 Agent for Microsoft SQL Server Guide
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 2000 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 CA
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 CA ARCserve Backup.
More information regarding the steps in this process are contained in the
following sections.
Check or Change the Microsoft SQL Server Authentication Method
To check or change the Microsoft SQL Server authentication method for
SQL Server 7.0 or 2000
1.
On the system where Microsoft SQL Server is running, open the SQL Server
Enterprise Manager.
2.
In the Tree pane, expand the entries below Console Root until you reach the
instance of the database server.
3.
Right-click the instance and select Properties from the drop-down list. The
Properties dialog opens.
4.
In the Properties dialog, choose the Security tab.
5.
Under Authentication, select either Microsoft SQL Server and Windows to
enable Microsoft SQL server-based authentication or Windows Only to
enable only Windows user names and passwords.
6.
Click OK.
7.
Restart the SQL Server instance for the changes to take effect.
