Requirements for using the SQL Agent

The following are required for the SQL Agent:

  • Backup Exec must have access rights to read both of the following SQL registry keys:

    • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server

    • HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer

    If Backup Exec does not have access to these registry keys, a restore to the default directory may not work, and the Automate master database restore option on the Restore Job Properties for SQL dialog box will not work.

    To ensure that Backup Exec has access rights, verify that the logon account used has administrator rights to the Windows server that the SQL instance is installed on.

  • The media server must have access to the SQL installation.

  • The credentials stored in the Backup Exec logon account used for backing up and restoring SQL must have been granted the System Administrator role on the SQL instance.

  • The Backup Exec Remote Agent for Windows Systems (Remote Agent) must be installed on any remote SQL Server that you want to back up.

Requirements for using the SQL Agent