xSQLServer

3.0.0.0

Examples/Resources/xSQLServerRole/2-RemoveServerRole.ps1

                                <#

.EXAMPLE

    This example shows how to ensure that the user account CONTOSO\SQLUser

    does not have "setupadmin" SQL server role. 

#>

    Configuration Example 

    {

        param(

            [Parameter(Mandatory = $true)]

            [PSCredential]

            $SysAdminAccount

        )

        Import-DscResource -ModuleName xSqlServer

        node localhost {

            xSQLServerRole Add_SqlServerRole_SQLAdmin

            {

                DependsOn = '[xSQLServerLogin]Add_SqlServerLogin_SQLAdmin'

                Ensure = 'Absent'

                Name = 'CONTOSO\SQLUser'

                ServerRole = "setupadmin"

                SQLServer = 'SQLServer'

                SQLInstanceName = 'DSC'

                PsDscRunAsCredential = $SysAdminAccount

            }

        }

    }