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

Closed
JamesCuneo opened this issue Oct 17, 2024 · 2 comments
Closed

Availability Group Replica name case lower #2049

JamesCuneo opened this issue Oct 17, 2024 · 2 comments
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
Copy link

This issue has been automatically closed because it is has not had activity from the community in the last 40 days. If this issue was wrongly closed, for a issue author please comment and re-open it, if you are not the issue author comment with a reason for it to be reopened and tag a maintainer in the comment.

@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Dec 28, 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