Resource Type: dsc_sqlconfiguration

Defined in:

lib/puppet/type/dsc_sqlconfiguration.rb

Overview

The DSC SqlConfiguration resource type. Automatically generated from version 16.6.0

Properties

• dsc_optionvalue

  The desired value of the configuration option.

• dsc_restartservice

  Determines whether the instance should be restarted after updating the configuration option.

• dsc_restarttimeout

  The length of time, in seconds, to wait for the service to restart. Default is ‘120` seconds.

• dsc_servername

  The hostname of the _SQL Server_ to be configured. Default value is the current computer name.

Parameters

• dsc_instancename (namevar)

  Name of the _SQL Server_ instance to be configured.

• dsc_optionname (namevar)

  The name of the _SQL Server Database Engine_ instance configuration option. For all possible values reference the article [Server Configuration Options (SQL Server)](docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-configuration-options-sql-server) or run ‘sp_configure`.

• dsc_psdscrunascredential
• dsc_timeout

  The maximum time in seconds to wait for the DSC resource to complete.

• name (namevar)

  Description of the purpose for this resource declaration.

• validation_mode (defaults to: property)

  Whether to check if the resource is in the desired state by property (default) or using Invoke-DscResource in Test mode (resource).