Computer Associates SQLSTQ99000600 Microsoft SQL Guide - Page 105

Update the Backup Manager, How User Authentication Is Changed

Get Computer Associates SQLSTQ99000600 - Unicenter SQL-Station 6.0.0 PDF manuals and user guides
UPC - 757943257441
View all Computer Associates SQLSTQ99000600 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 105 highlights

How User Authentication Is Changed 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. Appendix B: Configuring Microsoft SQL Server Security Settings 105

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
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.