Resource Type: dsc_xsqlserverinstall

Defined in:

lib/puppet/type/dsc_xsqlserverinstall.rb

Providers:

powershell

Overview

The DSC xSqlServerInstall resource type. Automatically generated from ‘xSqlPs/DSCResources/MSFT_xSqlServerInstall/MSFT_xSqlServerInstall.schema.mof’

To learn more about PowerShell Desired State Configuration, please visit technet.microsoft.com/en-us/library/dn249912.aspx.

For more information about built-in DSC Resources, please visit technet.microsoft.com/en-us/library/dn249921.aspx.

For more information about xDsc Resources, please visit github.com/PowerShell/DscResources.

Properties

• ensure

  The basic property that the resource should be in.

  Supported values:

  • exists?
  • present

Parameters

• dsc_agentsvcaccount

  AgentSvcAccount - Specify the account for SQL server agent service.

• dsc_features

  Features - List of names of Sql Server features to install

• dsc_installsqldatadir

  InstallSqlDataDir - Specify the directory for SQL server system db files

• dsc_instancename

  InstanceName - The name of sql instance.

• dsc_psdscrunascredential

  PsDscRunAsCredential

• dsc_sourcepath

  SourcePath - The share path of sql server software.

• dsc_sourcepathcredential

  SourcePathCredential - The credential that vm could use to access net share of sql server software.

• dsc_sqladministratorcredential

  SqlAdministratorCredential - Sql sa credential

• dsc_sqlbackupdir

  SqlBackupDir - Specify the directory for backup files.

• dsc_sqlcollation

  SqlCollation - Specify the default collation for SQL server

• dsc_sqltempdbdir

  SqlTempDBDir - Specify the directory for TempDB files.

• dsc_sqluserdbdir

  SqlUserDBDir - Specify the directory for UserDB data files.

• dsc_sqluserdblogdir

  SqlUserDBLogDir - Specify the directory for UserDB log files.

• dsc_svcaccount

  SvcAccount - Specify the startup account for the SQL server service.

• dsc_sysadminaccounts

  SysAdminAccounts - Specify logins to be members of the sysadmin role.

• dsc_updateenabled

  UpdateEnabled - Specify whether SQL server setup should discover and include product updates.

  Supported values:

  • true
  • false
• dsc_versionid

  VersionID - The numeric version identifier for the instance to be installed

• name (namevar)
• provider

  The specific backend to use for this ‘dsc_xsqlserverinstall` resource. You will seldom need to specify this — Puppet will usually discover the appropriate provider for your platform.