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