This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 57.99999999999999%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
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
Additional SQL Server features and topics not covered by specific categories
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Hi,
>only i am facing issue while installing sql
What error did you encounter when installing a SQL Server failover cluster instance?
First, you should have established a Windows Server failover cluster.
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.
MS doc create lot of confusion. Do you have any straight forward document?
cluinstall account is ( using failover cluster installation and sql installation )
like cluinstall is AD account and delegate as as AD joined rights. Also, added local administrative group on
both node.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
The documentation is pretty clear:
Additionally, verify the following account requirements:
Make sure that the account you want to use to create the cluster is a domain user who has administrator rights on all servers that you want to add as cluster nodes.
Make sure that either of the following is true:
The user who creates the cluster has the Create Computer objects permission to the OU or the container where the servers that will form the cluster reside.
If the user does not have the Create Computer objects permission, ask a domain administrator to prestage a cluster computer object for the cluster. For more information, see Prestage Cluster Computer Objects in Active Directory Domain Services.
