Log on to Windows with the Windows account selected in step 6. Then perform the procedure described in “Selecting the SQL host and instance” on page 63. The database login parameters that you choose will be selected for SQL Server backups launched from the NetBackup scheduler.
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
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.
Log on to your Windows host using the Windows account which you intend to use for the NetBackup Client Service.
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.
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.
Configuration SQL Server privileges