1. Support
  2. Knowledge base
  3. 100029753

The "Microsoft SQL Server" icon does not appear in the backup selections in Backup Exec for Windows Servers.

Article: 100029753
Last Published: 2017-12-07
Ratings: 0 0
Product(s): Backup Exec

Problem

The "Microsoft SQL Server" icon does not appear in the backup selections in Backup Exec for Windows Servers.

 

Error Message

None

 

Cause

This normally happens when the backup account being used does not have sufficient permissions.

 

Solution

Follow the procedure mentioned below to make sure that the backup account has sufficient permissions:

1. Confirm  that the ' Agent for Applications and Databases' feature has been installed\enabled in the Backup Exec Console.

2. Confirm that the BEDSSQL2.dll file is present in the following directories on the SQL server:
<Install Dir>\Program Files\Veritas\Backup Exec\RAWS
 
3. Grant the ' System Administrator' role to the backup account, within the SQL application.

4. Confirm that the ' Restrict Anonymous Support' value is enabled in the Registry, on the Backup Exec and SQL servers.
Warning: Incorrect use of the Windows registry editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making
 
HKey_Local_Machine\SOFTWARE\Veritas\Backup Exec For Windows\Backup Exec\Engine\NTFS> set as Value ' 0x00000001'  
 
5. Confirm that a UDL test to the SQL instance is successful, from the SQL server locally. Follow the article below to run a UDL test.
https://www.veritas.com/content/support/en_US/article.100016039.html

6. Grant ' Full Control' permissions to the backup account, on the following registry keys:
 
  • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server
  • HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer
7. Restart the Remote Agent service on the SQL server. Browse to the remote SQL server and the "Microsoft SQL Server" icon should be listed in the backup selection list.

 

Was this content helpful?

Article Languages