X hits on this document

415 views

0 shares

0 downloads

0 comments

44 / 200

8

Log on to Windows with the Windows account selected in step 6. Then perform the procedure described in “Selecting the SQL host and instanceon page 63. The database login parameters that you choose will be selected for SQL Server backups launched from the NetBackup scheduler.

9

Stop and restart the NetBackup Client Service from the service dialog box.

How to use standard SQL Server security

If you are using standard SQL Server security, the NetBackup Client Service must be started with a Windows account associated with a standard SQL Server userid that has sufficient administrative privileges to perform backups and restores.

To associate a Windows userid with a SQL Server userid

To set up the NetBackup client Service to login to SQL Server

1

If you are using standard SQL Server security, first map a Windows account to a standard SQL Server userid. (See “How to use standard SQL Server security” on page 44.)

2 3 4 5 6 7

Open the Windows Services application. Double-click on the NetBackup Client Service entry. Click on the Log On tab. Select This account. Type the name of the account, or browse for and select an account. Type the password and the password confirmation.

1

Log on to your Windows host using the Windows account which you intend to use for the NetBackup Client Service.

2

Start the NetBackup Database Extension GUI and go to the DBMS login parameters window. Type the standard SQL Server login name and password into the edit boxes provided. The values that you supply will be encrypted in a registry entry that is associated with the current Windows account.

3

Follow the instructions in previous section “Authorizing scheduled operations (for sites with SQL Server security restrictions)” to set the login account for the NetBackup Client Service.

Note: If you later change the password, then you must also indicate the new password for the NetBackup Client Service, then restart the NetBackup Client Service. If you do not do this, NetBackup scheduled backup operations will fail.

44

Configuration SQL Server privileges

Document info
Document views415
Page views415
Page last viewedSat Dec 03 20:45:29 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments