xSQLServer

9.1.0.0

Examples/Resources/xSQLServerPermission/1-AddServerPermissionForLogin.ps1

                                <#

    .EXAMPLE

        This example will add the server permissions AlterAnyAvailabilityGroup and ViewServerState

        to the login 'NT AUTHORITY\SYSTEM' and 'NT SERVICE\ClusSvc' to the default instance.

#>

Configuration Example

{

    param

    (

        [Parameter(Mandatory = $true)]

        [System.Management.Automation.PSCredential]

        [System.Management.Automation.Credential()]

        $SysAdminAccount

    )

    Import-DscResource -ModuleName xSQLServer

    node localhost

    {

        # Add permission

        xSQLServerPermission 'SQLConfigureServerPermission-SYSTEM'

        {

            Ensure               = 'Present'

            NodeName             = 'SQLNODE01.company.local'

            InstanceName         = 'MSSQLSERVER'

            Principal            = 'NT AUTHORITY\SYSTEM'

            Permission           = 'AlterAnyAvailabilityGroup', 'ViewServerState'

            PsDscRunAsCredential = $SysAdminAccount

        }

        xSQLServerPermission 'SQLConfigureServerPermission-ClusSvc'

        {

            Ensure               = 'Present'

            NodeName             = 'SQLNODE01.company.local'

            InstanceName         = 'MSSQLSERVER'

            Principal            = 'NT SERVICE\ClusSvc'

            Permission           = 'AlterAnyAvailabilityGroup', 'ViewServerState'

            PsDscRunAsCredential = $SysAdminAccount

        }

    }

}