SqlServerDsc

12.2.0.0

Examples/Resources/SqlServiceAccount/2-ConfigureServiceAccount-VirtualAccount.ps1

                                <#

.EXAMPLE

    This example shows how to ensure the SQL Server service

    on TestServer\DSC is running under a virtual account.

    Force will cause this account to be set every time the

    configuration is evaluated. Specifying RestartService will

    cause the service to be restarted.

#>

Configuration Example

{

    param(

        [Parameter(Mandatory = $true)]

        [System.Management.Automation.PSCredential]

        $ServiceAccountCredential

    )

    Import-DscResource -ModuleName SqlServerDsc

    Node localhost {

        SqlServiceAccount SetServiceAccount_User

        {

            ServerName     = 'TestServer'

            InstanceName   = 'DSC'

            ServiceType    = 'DatabaseEngine'

            ServiceAccount = $ServiceAccountCredential

            RestartService = $true

            Force          = $true

        }

    }

}