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