xSQLServer

8.1.0.0

Examples/Resources/xSQLServerDatabaseOwner/1-SetDatabaseOwner.ps1

                                <#

.EXAMPLE

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

    is "Owner" of SQL database "AdventureWorks".

#>

Configuration Example

{

    param

    (

        [Parameter(Mandatory = $true)]

        [System.Management.Automation.PSCredential]

        [System.Management.Automation.Credential()]

        $SysAdminAccount

    )

    Import-DscResource -ModuleName xSqlServer

    node localhost

    {

        xSQLServerLogin Add_SqlServerLogin_SQLAdmin

        {

            Ensure               = 'Present'

            Name                 = 'CONTOSO\SQLAdmin'

            LoginType            = 'WindowsUser'

            SQLServer            = 'SQLServer'

            SQLInstanceName      = 'DSC'

            PsDscRunAsCredential = $SysAdminAccount

        }

        xSQLServerDatabaseOwner Set_SqlDatabaseOwner_SQLAdmin

        {

            Name                 = 'CONTOSO\SQLAdmin'

            Database             = 'AdventureWorks'

            SQLServer            = 'SQLServer'

            SQLInstanceName      = 'DSC'

            PsDscRunAsCredential = $SysAdminAccount

        }

    }

}