Post reply

Local admin cannot view/launch failover cluster manager

  • January 22, 2024 at 5:28 am

    #4365598

    hi all.

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

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

    sqlcluster1

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

    sqlcluster2

    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.

  • January 22, 2024 at 2:05 pm

    #4365828

    My opinion - this is not a SQL related question, but a WFC related question, so you will get better results from looking on a WFC related forum. Now that being said, a quick google brought me to this link:

    https://techgenix.com/grant-users-limited-or-full-access-windows-failover-clusters/

    Which explains how to grant permissions for users to see and manage the cluster confg. To summarize the solution, also in case that link breaks, it states:

    For example, to allow User1 of TechGenix.com domain to have read only access to a Windows Failover cluster, run below command:

    Grant-ClusterAccess -User TechGenix.Com\User1 -ReadOnly

    In case you need to give a user full access to the failover cluster, add -Full parameter as shown below:

    Grant-ClusterAccess -User TechGenix.Com\User2 -Full

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • January 22, 2024 at 2:32 pm

    #4365829

    Hello Mr. Brian Gale,

    Thank you very much for the reply.

    I have tried the link that you provided but no luck.

    I will try to look at the WFC related forum to find if there is any luck there.

    Thank you

  • February 28, 2024 at 2:37 pm

    #4386407

    The permissions between the Local admin and Domain admin users are not the same.

    Domain user profile is different from the Local user admin profile in most cases.

     

    DBASupport

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply