question

Chotudin-9437 avatar image
0 Votes"
Chotudin-9437 asked jiayaozhu-MSFT commented

AD permission for SQL clustering

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.

sql-server-generalwindows-server-clustering
· 3
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,

I would like to check if the reply could be of help? If yes, please help accept answer, so that others meet a similar issue can find useful information quickly. If you have any other concerns or questions, please feel free to feedback.

Best Regards,
Joan

0 Votes 0 ·

Hello,

We haven't heard from you for a few days amd I would like to check if the reply could be of help? If yes, please help accept answer, so that others meet a similar issue can find useful information quickly. If you have any other concerns or questions, please feel free to feedback.

Best Regards,
Joan

0 Votes 0 ·

Hello,

We haven't heard from you for a long time and I would like to check if the replies in this blog could be of help? If yes, please help accept answer, so that others meet a similar issue can find useful information quickly. If you have any other concerns or questions, please feel free to feedback. Your support is really important to our work.

Best Regards,
Joan

0 Votes 0 ·
learn2skills avatar image
0 Votes"
learn2skills answered

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.


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.

jiayaozhu-MSFT avatar image
1 Vote"
jiayaozhu-MSFT answered jiayaozhu-MSFT edited

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 @learn2skills 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://docs.microsoft.com/en-us/windows-server/failover-clustering/configure-ad-accounts

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

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.

Chotudin-9437 avatar image
0 Votes"
Chotudin-9437 answered jiayaozhu-MSFT commented

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

· 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,

Thanks for your reply!

I am glad to hear that you have solved your issue and thanks for your sharing. Your experience will definitely help other people on our forum who have a similar issue!

So, would you please help me Accept Answer? Just accept any answers in this blog you think is useful. You can also accept your own answer. In this way, your blog can be put on top of our forum and the public can get access to your blog more easily.

Thanks for your support! Have a nice day! : )

BR,
Joan

0 Votes 0 ·