We upgraded to VDP advanced 5.8 today and installed the new SQL agent in 3 different SQL servers. The two SQL Server 2008 machines work fine with VDP-- it can see all the databases.
But when I try to create a backup of the SQL Server 2014 machine, by selecting individual databases, the VDP appliance (as controlled through vSphere Web Client) only sees the three system databases
Master, MSDB, and Temp. And when I tried to backup the Master database, the process failed with a non-explanatory miscellaneous error.
Is there something special about setting up SQL Server 2014 to be backed up by VDP advanced?
See M80ARM - Virtualization Warrior: VDP Advanced SQL Agent Permissions
Basically you either need to run the service "Backup Agent" in a context that had rights to the SQL server or you have to grant the NT AUTHORITY\SYSTEM account with appropriate rights to the SQL server. Not clear in the documentation but that solved it for me.
See M80ARM - Virtualization Warrior: VDP Advanced SQL Agent Permissions
Basically you either need to run the service "Backup Agent" in a context that had rights to the SQL server or you have to grant the NT AUTHORITY\SYSTEM account with appropriate rights to the SQL server. Not clear in the documentation but that solved it for me.
Jasonfz--
Thanks much.
Must be some difference between SQL Server 2014 and SQL Server 2008, but what you described fixes the problem.