Error - Could not locate database file locations out of master DB
The following error is logged to the DH2i Event Log when attempting to virtualize an instance of Microsoft SQL Server:
Could not locate database file locations out of master DB
Log Name: DH2i
Event ID: 4359
Task Category: None
[<instance>] Could not locate database file locations out of master DB.
Please ensure [NT Authority\System] is granted SQL Sysadmin role before virtualizing
Verify that NT Authority\System has Microsoft SQL Server Sysadmin rights. To add a Sysadmin role please see: Microsoft - sp_addsrvrolemember
If a more restrictive role is necessary for the SQL Server management account, then please see: Minimum SQL Server Security Privileges for Managing HA Instances.
From the DxEnterprise Administration Guide - Add an HA SQL Server Instance:
By default DxEnterprise executes under the LocalSystem account context. It may be necessary to add this account to SQL Admin group in order to have a successful virtualization. If it is necessary to run DxEnterprise under a different account, please ensure the account used for DxCMonitor, DxLMonitor, DxHealthMonitor, DxRegMonitor, and DxStorMonitor is part of the local Administrators group, the SQL Admin group, and has full access to any SQL data folders.