Authorizing scheduled operations (for sites with SQL Server security restrictions)

You must set up an account that the NetBackup Client Service can use to log in to SQL Server. The account must have sufficient SQL Server privileges to perform a backup. You can then use NetBackup to perform automatic SQL Server backups of a site that places SQL Server security restrictions on the right to back up databases.

Note:

If your site does not place SQL Server security restrictions on the right to back up databases, authorization of scheduled operations is not needed.

To authorize scheduled operations for a site with SQL Server security restrictions

  1. If you use standard SQL Server security, first map a Windows account to a standard SQL Server user ID.

  2. Open the Windows Services application.

  3. Double-click the NetBackup Client Service entry.

  4. Click the Log On tab.

  5. Select This account.

  6. Type the name of the account, or browse for and select an account.

  7. Type the password and the password confirmation.

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

  8. Log on to Windows with the Windows account selected in step 6.

  9. Select the SQL host and instance.

    The database logon parameters are used for the SQL Server backups that the NetBackup scheduler launches.

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

More Information

Mapping a Windows account to a standard SQL Server user ID

Selecting the SQL host and instance