Skip to content

MSFT_SqlAGReplica failed to execute Set-TargetResource functionality with error message: HADR is not enabled #1182

Closed
@cnilak

Description

@cnilak
    SqlServerLogin AddNTServiceClusSvc
    {
        Ensure               = 'Present'
        Name                 = 'NT SERVICE\ClusSvc'
        LoginType            = 'WindowsUser'
        ServerName           = $SqlNode
        InstanceName         = "MSSQLSERVER"
        PsDscRunAsCredential = $SqlInstallCredential
    }

    # Add the required permissions to the cluster service login
    SqlServerPermission AddNTServiceClusSvcPermissions
    {
        DependsOn            = '[SqlServerLogin]AddNTServiceClusSvc'
        Ensure               = 'Present'
        ServerName           = $SqlNode
        InstanceName         = "MSSQLSERVER"
        Principal            = 'NT SERVICE\ClusSvc'
        Permission           = 'AlterAnyAvailabilityGroup', 'ViewServerState'
        PsDscRunAsCredential = $SqlInstallCredential
    }

    SqlServerEndpoint HADREndpoint
    {
        EndPointName         = 'HADR'
        Ensure               = 'Present'
        Port                 = $portNumber
        ServerName           = $SqlNode
        InstanceName         = "MSSQLSERVER"
        PsDscRunAsCredential = $SqlInstallCredential
    }

SqlAGReplica AddReplica
{
Ensure = 'Present'
Name = $SqlNode
AvailabilityGroupName = $avgGroupName
ServerName = $SqlNode
InstanceName = "MSSQLSERVER"
PrimaryReplicaServerName = $SqlPrimaryReplicaNode
PrimaryReplicaInstanceName = "MSSQLSERVER"
PsDscRunAsCredential = $SqlInstallCredential
DependsOn = '[SqlSetup]InstallDefaultInstance'
}

Metadata

Metadata

Assignees

Labels

documentationThe issue is related to documentation only.good first issueThe issue should be easier to fix and can be taken up by a beginner to learn to contribute on GitHub

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions