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

[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'
}

[johlju]

You must enable AG with SqlAlwaysOnService resource.

[stale]

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 10 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.

[SphenicPaul]

I ran into this issue today.

Is it not worth adding this to the example here ?

[johlju]

@SphenicPaul absolutely, great suggestion! 😃

If someone wants to send in a PR for that, I'm happy to review it.