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 system 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 Backup Exec 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.
When you test the logon account, apply the logon account to the Windows server that SQL is installed on, not to the actual SQL instance.
Note: SQL Server credentials are not supported.
-
The Agent for Windows must be installed on any remote SQL Server that you want to back up.
-
Jobs that back up or restore default instances of SQL Server may fail unless you upgrade to Agent for Windows version 2012 or later on the computer that contains the SQL Server instance.
You can also edit the backup selections and delete the SQL Server instance from the Selection Details tab. Then, on the Browse tab, select the SQL Server instance.
For specific operating system requirements and supported SQL Server service packs for the SQL Agent, see the Backup Exec Software Compatibility List at the following URL:
More Information
Related information