Repository navigation
MSFT_SqlAGReplica failed to execute Set-TargetResource functionality with error message: HADR is not enabled #1182
Description
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'
}
Activity
johlju commentedon Jul 14, 2018
You must enable AG with SqlAlwaysOnService resource.
stale commentedon Aug 13, 2018
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 commentedon Aug 23, 2018
I ran into this issue today.
Is it not worth adding this to the example here ?
johlju commentedon Aug 24, 2018
@SphenicPaul absolutely, great suggestion! 😃
If someone wants to send in a PR for that, I'm happy to review it.
Updating examples to include enable HADR option (#1208)