V-79-57344-38749: Backup Exec was unable to prepare Microsoft SQL resources for Granular Recovery Technology (GRT) operations.

Problem

SQL Virtual Machine Application GRT enabled backup completes with exception "V-79-57344-38749 - Backup Exec was unable to prepare Microsoft SQL resources for Granular Recovery Technology (GRT) operations"

Error Message

V-79-57344-38749 - Backup Exec was unable to prepare Microsoft SQL resources for Granular Recovery Technology (GRT) operations.

Cause

The user account used to backup the SQL Virtual machine (VM) did not have rights on the Virtual Machine and also on the SQL databases which were backed up as part of the VM.

Solution

1. Add the Backup account which is used for the backup to local administrator group of the Virtual Machine.

2. Create the user account which is being used for the backup via SQL -> Logins.  Use SQL Management studio or seek assistance from a DBA to 
ensure the user account is created appropriately and has all necessary privileges to Backup the SQL databases.
HV2012N2 in this case is the Virtual SQL Machine which shows the exception.

Ensure that the sysadmin server role is provided for the user account.
 

Add the Database membership roles of db_owner, db_backupoperator, db_datareader and db_datawriter are provided for all the databases.

3. Rerun the Backup Job.