Share via

SQL Server Workgroup Cluster

Tushar Verma A 21 Reputation points
2022-07-04T08:04:54.123+00:00

I'm to trying create a Domain Independent Always on availability group using the documentation

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/domain-independent-availability-groups?view=sql-server-ver15

The documentation says -Using the instructions at this link, deploy a Workgroup Cluster composed of all servers that will participate in the availability group-

I have followed the prerequisites in the documentation and created two vm's having sql installed with dns suffix .

While I try to create a Workgroup Cluster using PowerShell on one machine , it keeps giving

'Administrative privileges not present on other machine '

though I have created a user under administrative group on both machines

Please suggest

Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
979 questions
Accepted answer
  1. Xu Gu (Shanghai Wicresoft Co,.Ltd.) 501 Reputation points Microsoft Vendor
    2022-07-06T02:10:36.977+00:00

    Hello TusharVermaA,

    Based on your description and the hint that "administrator privileges do not exist on other machines", I focus on thinking about this from a privilege perspective. The reference is as follows:
    (1) During the creation process, each computer in the administrator group should have its own account, and it is necessary to ensure that each node must be added to the current administrator group to ensure that each node has the same permissions.
    (2) In the process of setting administrative permissions, we need to set the value of LocalAccountTokenFilterPolicy to 1, you can open PowerShell, enter the command new-itemproperty -path HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System -Name LocalAccountTokenFilterPolicy -Value 1 is enough.
    (3) May I ask, did you get any errors in the process of creating the cluster or when using the command? Can you show it to me if you can?
    (4)Could you provide the commands and errors that you involved in creating the cluster?
    (5) In addition, in the process of creating a cluster, the firewall will play a certain role in blocking, you can try to close the firewall, and then see if it can go on normally.
    The link below may give you some inspiration.
    Hope my answer can help you!
    create-failover-cluster
    availability-group-clusterless-workgroup-configure

    Best Regards,
    XuGu

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Limitless Technology 39,511 Reputation points
    2022-07-05T13:38:43.287+00:00

    Hello

    Thank you for your question and reaching out. I can understand you are having issues related to Workgroup Cluster.

    You should create a local user with a similar user name and password in both the cluster nodes. We can use this account to manage the failover cluster instead of using the default administrator account.

    Disable any Antivirus program or Windows firewall you may have for temporary purpose.

    ----------------------------------------------------------------------------------------------------------------------------------------

    --If the reply is helpful, please Upvote and Accept as answer--

    0 comments