Error - Could not locate database file locations out of master DB
Summary
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
Event Details
Log Name: DH2i
Source: DxEngine
Date: <date_time>
Event ID: 4359
Task Category: None
Level: Error
Computer: <node>
Description:
[<instance>] Could not locate database file locations out of master DB.
Please ensure [NT Authority\System] is granted SQL Sysadmin role before virtualizing
Resolution
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.