Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Availability Group Replica name case lower #2049

Open
JamesCuneo opened this issue Oct 17, 2024 · 1 comment
Open

Availability Group Replica name case lower #2049

JamesCuneo opened this issue Oct 17, 2024 · 1 comment
Labels
question The issue is a question. stale The issue or pull request was marked as stale because there hasn't been activity from the community.

Comments

@JamesCuneo
Copy link

I am creating an availability group using

    SqlAG 'AG01'
    {
        Ensure               = 'Present'
        Name                 = 'AG01'
        InstanceName         = 'MSSQLSERVER'
        ServerName           = $Node.NodeName
        DependsOn            = '[SqlAlwaysOnService]EnableAlwaysOn', '[SqlPermission]AddNTServiceClusSvcPermissions'
        SeedingMode          = 'Automatic'
        PsDscRunAsCredential = $ActiveDirectoryAdministratorCredential
    }

I am then adding a replica using

    # Add the availability group replica to the availability group
    SqlAGReplica 'AddReplica'
    {
        Ensure                        = 'Present'
        Name                          = $Node.NodeName
        AvailabilityGroupName         = 'AG01'
        ServerName                    = $Node.NodeName
        InstanceName                  = 'MSSQLSERVER'
        PrimaryReplicaServerName      = 'SERVERNAME.Domain'
        PrimaryReplicaInstanceName    = 'MSSQLSERVER'
        ProcessOnlyOnActiveNode       = $true
        FailoverMode                  = 'Manual'
        AvailabilityMode              = 'AsynchronousCommit'
        ConnectionModeInSecondaryRole = 'AllowAllConnections'
        SeedingMode                   = 'Automatic'
        DependsOn                     = '[SqlAlwaysOnService]EnableAlwaysOn'
        PsDscRunAsCredential          = $ActiveDirectoryAdministratorCredential
    }

For some reason when the primary is created, the server name is lowercase and the secondary server name is uppercase. Has anyone else seen this? Everything is obviously working ok.

@johlju johlju added the question The issue is a question. label Oct 17, 2024
Copy link

This issue has been automatically marked as stale because it has not had activity from the community in the last 30 days. It will be closed if no further activity occurs within 40 days. If the issue is labelled with any of the work labels (e.g bug, enhancement, documentation, or tests) then the issue will not auto-close.

@github-actions github-actions bot added the stale The issue or pull request was marked as stale because there hasn't been activity from the community. label Nov 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question The issue is a question. stale The issue or pull request was marked as stale because there hasn't been activity from the community.
Projects
None yet
Development

No branches or pull requests

2 participants