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.