AD permission for SQL clustering

Question

Hello All,

Can anyone help me to understand. What AD permission will require to install SQL clustering on Windows failover cluster. What level of permission I need to give each user ?

I have created three account 1) Sql installation account 2) Service Account 3) SQL server network name.

Answer 1

Hi,

Thanks for posting on our forum!

Based on your requirements, firstly, you need to make sure that all of the user servers are added to your DC computer and your DC Admin has full control over all of these user accounts.

Secondly, If you need to configure a file share like what @SUNOJ KUMAR YELURU mentioned, I think you can just follow the steps in the article he or she offered you. The way to configure AD permissions for each user to create and store their files to your local drives, mentioned in that article, is called NTFS permissions. In this case, all of your shared volumes need formatting as NTFS model.

Finally, here are some articles that help you better understand configuring AD accounts in sql cluster:

https://learn.microsoft.com/en-us/windows-server/failover-clustering/configure-ad-accounts

https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc731002(v=ws.10)?redirectedfrom=MSDN

http://bradctchen.blogspot.com/2013/01/ad-account-permission-required-for-sql.html

(Please note: Information posted in the given link is hosted by a third party. Microsoft does not guarantee the accuracy and effectiveness of information.)

Besides, since your AD administrator (your DC account) should create admin access for each user accounts (i.e. add these user accounts into the same Admin domain) before configuring cluster, the service account (AD Account) for the services does not need to be an AD Admin, but does need to be a Admin to the physical servers in the Cluster.

Thanks for your support! I would appreciate it if you could help me accept answer to support my work! : )

BR,
Joan

---

If the Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @dineshnegi-9437

Refer to the below url it is explained.
https://www.mssqltips.com/sqlservertip/4769/stepbystep-installation-of-sql-server-2016-on-a-windows-server-2016-failover-cluster--part-1/

Configuring cluster accounts in Active Directory

If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

Answer 3

Thanks for your help. It was issue on OS, I am able to install the sql on windows cluster successfully