How User Authentication Is Changed
Appendix B: Configuring Microsoft SQL Server Security Settings 105
The SQL Server ODBC Data Source Test dialog opens. After a few seconds,
the dialog displays the results of a quick connection test:
■
If the Microsoft SQL Server ODBC Data Source Test dialog reports that
the tests finished successfully, click OK and click OK on the ODBC
Microsoft SQL Server Setup dialog. You are returned to the ODBC Data
Source Administrator dialog. Click OK.
■
If the SQL Server ODBC Data Source Test dialog reports any errors or
failures, this is due to an error in ODBC or the Microsoft SQL Server. See
the Microsoft SQL Server documentation for troubleshooting
instructions.
Update the Backup Manager
To update the Backup Manager and backup jobs
1.
On the system where you have installed CA ARCserve Backup, start CA
ARCserve Backup and open the Job Status Manager.
2.
If you have any recurring or pending backup jobs already scheduled for this
Microsoft SQL Server, select the Job Queue folder tab in the Job Status
Manager.
3.
Select the first job you need to update, right-click and select Modify from the
pop-up window. The Backup Manager will open and load the job.
4.
Select the Source tab.
5.
In the left pane navigation tree, expand the server on which Microsoft SQL
Server is running to show the database. If the server does not appear in the
tree, see the
Implementation Guide
for instructions on how to add it.
6.
Right-click the database and choose Security from the pop-up window. The
Security dialog opens.
7.
If you are using Windows security, specify the user name for the account you
are using to access the server and either enter the password or leave the
field blank.
If you are using Microsoft SQL Server security, enter the user name and
password for the Microsoft SQL Server account and click OK.
8.
Click Submit to resubmit the backup job.
9.
Repeat these steps for each applicable backup job.
Note:
If you have any restore jobs scheduled for this Microsoft SQL Server, you
must delete and recreate them.
