Skip to main content
Version: v23.0

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.

info

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.