I`ve investigated same issue:
For some VMs SQL DBs also were not visible through Enterprise Manager Portal. Also those DBs not returned by Veeam Powershell (as it should):
- Code: Select all
$restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "YOURSQLVM"
Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint | ft servername, name
Result was null.
Despite results of backup job were successful, In backup job logs (located C:\ProgramData\Veeam\Backup\_JOBNAME_) I`ve found error for AAIP account: "Win32 error:Logon failure: the user has not been granted the requested logon type at this computer."
2 reasons for such error:
1) account for AAIP was denied for logon locally (by GPO) - similar issue here
2) account for AAIP doesn`t have sysadmin role permissions on SQL (add.info - here
After I`ve granted sysadmin role permissions and allow logon locally for AAIP account, SQL databases became visible in Enterprise Manager Portal, and veeam powershell now returns DBs correctly
Hope, this workaround helps you