Active Directory permission to install the SQL on Windows cluster.

Question

Hello Everyone, What AD permission will require to install the SQL on Windows cluster? I have created three normal AD account in AD. One for Windows cluster install ; 2nd is service account for sql and 3rd is sql server network name. Do I need to give any specific permission please suggest.

Windows Cluster installation.
cluinstall ==> For Windows failover cluster installation. .

SQL Installation.

Srv.sql==> Service account for sql.
sqlvirtualname ===>sql server network name

Answer 1

Hello,

To install a windows server failover cluster, You'd better use a domain administrator account, or make sure that the account has administrator rights on all servers that you want to add as failover cluster nodes.
https://learn.microsoft.com/en-us/windows-server/failover-clustering/create-failover-cluster#verify-the-prerequisites

The service account of sql server failover cluster instance can be a domain account or managed service account. It is recommended to always run SQL Server services by using the lowest possible user rights.
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver15

sql server virtual network name -- A computer object (Active Directory computer account) for the SQL Server network resource name will be created when installing the sql server failover cluster.

Answer 2

I am using single account for cluster and sql installation. And, one account for sql service

1) User is domain user and have domain admin rights.
2) user is added in all the local administrative group.

Account which I am using for sql services, added that account also in local administrative group.

only i am facing issue while installing sql