question

Chotudin-9437 avatar image
0 Votes"
Chotudin-9437 asked Criszhan-msft edited

Active Directory permission to install the SQL on Windows cluster.

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

sql-server-generalwindows-server-clustering
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered TomPhillips-1744 commented

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://docs.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://docs.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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

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.


https://docs.microsoft.com/en-us/windows-server/failover-clustering/create-failover-cluster#verify-the-prerequisites

0 Votes 0 ·
Chotudin-9437 avatar image
0 Votes"
Chotudin-9437 answered Criszhan-msft edited

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·