Skip to main content
Version: v23.0

Minimum SQL Server Security Privileges for Managing HA Instances

Summary

The minimum SQL Server security privileges for the DxEnterprise HA instance management account to failover and manage SQL Server instances.

Information

The DxEnterprise HA management account requires the following security roles within SQL Server in order to failover and manage SQL Server instances.

note

The DxEnterprise HA management account can be a SQL Server login, a local user or a domain user. If specifying a domain user, the username must be in UPN format (i.e. user@domain). If using a SQL Server login or a local user account, then the account specified must be the same across all nodes and instances that are members of the Vhost.

  • ALTER ANY LINKED SERVER
  • ALTER ANY DATABASE
  • CREATE ANY DATABASE
  • VIEW ANY DEFINITION
  • Setupadmin fixed server role

Additional Information