Local admin cannot view/launch failover cluster manager

Jeffrey Ooi 1 Reputation point
2024-04-18T07:30:18.6466667+00:00

Hi all.

I am new to this and hope someone can help me.

We have created a Windows failover cluster for our SQL. When I log in using a Domain Admin user (Domain\user), I can view the cluster manager.

Log in as domain administrator
User's image

But when I log in using a local admin (local administrator group), I cannot/am unable to view the failover cluster manager.

Log in as a local administrator

User's image

May I know what permission I should granted to view the failover cluster manager when I log in as a local administrator?

Thank you very much in advance.

~Jeffrey

Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,374 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,739 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ian Xue (Shanghai Wicresoft Co., Ltd.) 29,891 Reputation points Microsoft Vendor
    2024-04-22T04:47:52.9566667+00:00

    Hi Jeffery,

    Thanks for your post. Based on my research, When you first create a cluster or add servers to it, you must sign in to the domain with an account with administrator rights and permissions for all servers in that cluster. The account you use doesn't need to be a Domain Admins account, but can be a Domain Users account that is in the Administrators group on each clustered server. If the account isn't a Domain Admins account, then you need to give the account or the group it's a member of the Create Computer Objects and Read All Properties permissions in the domain organizational unit (OU) that you plan to add it to.

    Reference: https://learn.microsoft.com/en-us/windows-server/failover-clustering/deploy-two-node-clustered-file-server?tabs=server-manager#network-infrastructure-and-domain-account-requirements

    Best Regards,

    Ian Xue


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

    0 comments No comments