SqlServerDsc

11.2.0.0

Tests/Integration/MSFT_SqlAlwaysOnService.config.ps1

# This is used to make sure the integration test run in the correct order.
[Microsoft.DscResourceKit.IntegrationTest(OrderNumber = 2)]
param()

<#
    Get all adapters with static IP addresses, all of which should be ignored
    when creating the cluster.
#>
$ignoreAdapterIpAddress = Get-NetAdapter |
    Get-NetIPInterface |
        Where-Object -FilterScript {
            $_.Dhcp -eq 'Disabled'
        } | Get-NetIPAddress

$ignoreIpNetwork = @()
foreach ($adapterIpAddress in $ignoreAdapterIpAddress)
{
    <#
        Get-NetIPAddressNetwork is in CommonTestHelper.psm1 which is imported
        withing the integration test before this file is dot-sourced.
    #>
    $ipNetwork = (Get-NetIPAddressNetwork -IPAddress $adapterIpAddress.IPAddress -PrefixLength $adapterIpAddress.PrefixLength).NetworkAddress
    $ignoreIpNetwork += ('{0}/{1}' -f $ipNetwork, $adapterIpAddress.PrefixLength)
}

$ConfigurationData = @{
    AllNodes = @(
        @{
            NodeName                    = 'localhost'
            ComputerName                = $env:COMPUTERNAME
            InstanceName                = 'DSCSQL2016'
            RestartTimeout              = 120

            LoopbackAdapterName         = 'ClusterNetwork'
            LoopbackAdapterIpAddress    = '192.168.40.10'
            LoopbackAdapterGateway      = '192.168.40.254'

            ClusterStaticIpAddress      = '192.168.40.11'
            IgnoreNetwork               = $ignoreIpNetwork

            PSDscAllowPlainTextPassword = $true
        }
    )
}

Configuration MSFT_SqlAlwaysOnService_CreateDependencies_Config
{
    Import-DscResource -ModuleName 'PSDscResources'
    Import-DscResource -ModuleName 'xNetworking'

    node localhost
    {
        WindowsFeature 'AddFeatureFailoverClustering'
        {
            Ensure = 'Present'
            Name   = 'Failover-clustering'
        }

        WindowsFeature 'AddFeatureFailoverClusteringPowerShellModule'
        {
            Ensure = 'Present'
            Name   = 'RSAT-Clustering-PowerShell'
        }

        xIPAddress LoopbackAdapterIPv4Address
        {
            IPAddress      = $Node.LoopbackAdapterIpAddress
            InterfaceAlias = $Node.LoopbackAdapterName
            AddressFamily  = 'IPv4'
        }

        <#
            Must have a default gateway for the Cluster to be able to use the
            loopback adapter as clustered network.
            This will be removed directly after the cluster has been created.
        #>
        xDefaultGatewayAddress LoopbackAdapterIPv4DefaultGateway
        {
            Address      = $Node.LoopbackAdapterGateway
            InterfaceAlias = $Node.LoopbackAdapterName
            AddressFamily  = 'IPv4'
        }

        <#
            This is not using a dedicated DSC resource because xFailOverCluster
            does not support administrative access point at this time.
            Issue https://github.com/PowerShell/xFailOverCluster/issues/147.
        #>
        Script 'CreateActiveDirectoryDetachedCluster'
        {
            SetScript  = {
                $clusterStaticIpAddress = $Using:Node.ClusterStaticIpAddress
                $ignoreNetwork = $Using:Node.IgnoreNetwork

                Write-Verbose -Message ('Ignoring networks: ''{0}''' -f ($ignoreNetwork -join ', ')) -Verbose

                $newClusterParameters = @{
                    Name                      = 'DSCCLU01'
                    Node                      = $env:COMPUTERNAME
                    StaticAddress             = $clusterStaticIpAddress
                    IgnoreNetwork             = $ignoreNetwork
                    NoStorage                 = $true
                    AdministrativeAccessPoint = 'Dns'

                    # Ignoring warnings that cluster might not be able to start correctly.
                    WarningAction             = 'SilentlyContinue'

                    # Make sure to stop on any error.
                    ErrorAction               = 'Stop'
                }

                Write-Verbose -Message ('Creating Active Directory-Detached cluster ''{0}'' with IP address ''{1}''.' -f $newClusterParameters.Name, $clusterStaticIpAddress)

                New-Cluster @newClusterParameters | Out-Null
            }

            TestScript = {
                $result = $false

                <#
                    Only create Active Directory-Detached cluster if the computer
                    is not part of a domain.
                #>
                if (-not (Get-CimInstance Win32_ComputerSystem).PartOfDomain)
                {
                    $clusterName = 'DSCCLU01'
                    if (Get-Cluster -Name $clusterName -ErrorAction SilentlyContinue)
                    {
                        Write-Verbose -Message ('Cluster ''{0}'' exist.' -f $clusterName)
                        $result = $true
                    }
                    else
                    {
                        Write-Verbose -Message ('Cluster ''{0}'' does not exist.' -f $clusterName)
                    }
                }
                else
                {
                    Write-Verbose -Message 'Computer is domain-joined. Skipping creation of Active Directory-Detached cluster. Expecting a cluster to be present by other means than thru the integration test.'
                    $result = $true
                }

                return $result
            }

            GetScript  = {
                [System.String] $clusterName = $null

                $cluster = Get-Cluster -Name 'DSCCLU01' -ErrorAction SilentlyContinue
                if ($cluster)
                {
                    $clusterName = $cluster.Name
                }

                return @{
                    Result = $clusterName
                }
            }

            DependsOn            = @(
                '[WindowsFeature]AddFeatureFailoverClustering'
                '[WindowsFeature]AddFeatureFailoverClusteringPowerShellModule'
            )

        }
    }
}

Configuration MSFT_SqlAlwaysOnService_CleanupDependencies_Config
{
    Import-DscResource -ModuleName 'xNetworking'

    node localhost
    {
        <#
            Removing the default gateway from the loopback adapter.
        #>
        xDefaultGatewayAddress LoopbackAdapterIPv4DefaultGateway
        {
            InterfaceAlias = $Node.LoopbackAdapterName
            AddressFamily  = 'IPv4'
        }
    }
}

Configuration MSFT_SqlAlwaysOnService_EnableAlwaysOn_Config
{
    param
    (
        [Parameter(Mandatory = $true)]
        [ValidateNotNullOrEmpty()]
        [System.Management.Automation.PSCredential]
        $SqlInstallCredential
    )

    Import-DscResource -ModuleName 'SqlServerDsc'

    node localhost {
        SqlAlwaysOnService 'Integration_Test'
        {
            Ensure               = 'Present'
            ServerName           = $Node.ComputerName
            InstanceName         = $Node.InstanceName
            RestartTimeout       = $Node.RestartTimeout

            PsDscRunAsCredential = $SqlInstallCredential
        }
    }
}

Configuration MSFT_SqlAlwaysOnService_DisableAlwaysOn_Config
{
    param
    (
        [Parameter(Mandatory = $true)]
        [ValidateNotNullOrEmpty()]
        [System.Management.Automation.PSCredential]
        $SqlInstallCredential
    )

    Import-DscResource -ModuleName 'SqlServerDsc'

    node localhost {
        SqlAlwaysOnService 'Integration_Test'
        {
            Ensure               = 'Absent'
            ServerName           = $Node.ComputerName
            InstanceName         = $Node.InstanceName
            RestartTimeout       = $Node.RestartTimeout

            PsDscRunAsCredential = $SqlInstallCredential
        }
    }
}