sqlserver

Table of contents

1. Overview
2. Module Description - What the module does and why it is useful
3. Setup - The basics of getting started with sqlserver
   • Setup requirements
   • Beginning with sqlserver
4. Usage - Configuration options and additional functionality
   • Install SQL Server tools and features
   • Create a new database
   • Set up a new login
   • Create a new login and a user
   • Manage the user's permissions
   • Run custom TSQL statements
5. Reference - An under-the-hood peek at what the module is doing and how
6. Limitations - OS compatibility, etc.
7. License
8. Development - Guide for contributing to the module

Overview

The sqlserver module installs and manages Microsoft SQL Server 2014, 2016, 2017, 2019 and 2022 on Windows systems.

Module Description

Microsoft SQL Server is a database platform for Windows. The sqlserver module lets you use Puppet to install multiple instances of SQL Server, add SQL features and client tools, execute TSQL statements, and manage databases, users, roles, and server configuration options.

Setup

Setup Requirements

The sqlserver module requires the following:

• .NET 3.5. (Installed automatically if not present. This might require an internet connection.)
• The contents of the SQL Server ISO file, mounted or extracted either locally or on a network share.
• Windows Server 2012+.

Beginning with sqlserver

To get started with the sqlserver module, include in your manifest:

sqlserver_instance{ 'MSSQLSERVER':
    features                => ['SQL'],
    source                  => 'E:/',
    sql_sysadmin_accounts   => ['myuser'],
}

This example installs MS SQL and creates an MS SQL instance named MSSQLSERVER. It also installs the base SQL feature set (Data Quality, FullText, Replication, and SQLEngine), specifies the location of the setup.exe, and creates a new SQL-only sysadmin, 'myuser'.

A more advanced configuration, including installer switches:

sqlserver_instance{ 'MSSQLSERVER':
  source                  => 'E:/',
  features                => ['SQL'],
  security_mode           => 'SQL',
  sa_pwd                  => 'p@ssw0rd!!',
  sql_sysadmin_accounts   => ['myuser'],
  install_switches        => {
    'TCPENABLED'          => 1,
    'SQLBACKUPDIR'        => 'C:\\MSSQLSERVER\\backupdir',
    'SQLTEMPDBDIR'        => 'C:\\MSSQLSERVER\\tempdbdir',
    'INSTALLSQLDATADIR'   => 'C:\\MSSQLSERVER\\datadir',
    'INSTANCEDIR'         => 'C:\\Program Files\\Microsoft SQL Server',
    'INSTALLSHAREDDIR'    => 'C:\\Program Files\\Microsoft SQL Server',
    'INSTALLSHAREDWOWDIR' => 'C:\\Program Files (x86)\\Microsoft SQL Server',
  }
}

This example creates the same MS SQL instance as shown above with additional options: security mode (requiring password to be set) and other optional install switches. This is specified using a hash syntax.

Usage

Note: For clarification on Microsoft SQL Server terminology, please see Microsoft SQL Server Terms below.

Install SQL Server tools and features not specific to a SQL Server instance

sqlserver_features { 'Generic Features':
  source   => 'E:/',
  features => ['BC', 'Conn', 'SDK'],
}

Create a new database on an instance of SQL Server

sqlserver::database{ 'minviable':
  instance => 'MSSQLSERVER',
}

Set up a new login

SQL Login
sqlserver::login{ 'vagrant':
  instance => 'MSSQLSERVER',
  password => 'Pupp3t1@',
}

# Windows Login
sqlserver::login{ 'WIN-D95P1A3V103\localAccount':
  instance   => 'MSSQLSERVER',
  login_type => 'WINDOWS_LOGIN',
}

Create a new login and a user for a given database

sqlserver::login{ 'loggingUser':
  password => 'Pupp3t1@',
}

sqlserver::user{ 'rp_logging-loggingUser':
  user     => 'loggingUser',
  database => 'rp_logging',
  require  => Sqlserver::Login['loggingUser'],
}

Manage the above user's permissions

sqlserver::user::permissions{'INSERT-loggingUser-On-rp_logging':
    user        => 'loggingUser',
    database    => 'rp_logging',
    permissions => 'INSERT',
    require     => Sqlserver::User['rp_logging-loggingUser'],
}

sqlserver::user::permissions{ 'Deny the Update as we should only insert':
  user        => 'loggingUser',
  database    => 'rp_logging',
  permissions => 'UPDATE',
  state       => 'DENY',
  require     => Sqlserver::User['rp_logging-loggingUser'],
}

Run custom TSQL statements

Use sqlserver_tsql to trigger other classes or defined types

sqlserver_tsql{ 'Query Logging DB Status':
  instance => 'MSSQLSERVER',
  onlyif   => "IF (SELECT count(*) FROM myDb.dbo.logging_table WHERE
      message like 'FATAL%') > 1000  THROW 50000, 'Fatal Exceptions in Logging', 10",
  notify   => Exec['Too Many Fatal Errors']
}

Clean up regular logs with conditional checks

sqlserver_tsql{ 'Cleanup Old Logs':
  instance => 'MSSQLSERVER',
  command  => "DELETE FROM myDb.dbo.logging_table WHERE log_date < '${log_max_date}'",
  onlyif   => "IF exists(SELECT * FROM myDb.dbo.logging_table WHERE log_date < '${log_max_date}')
      THROW 50000, 'need log cleanup', 10",
}

If you want your statement to always execute, leave out the onlyif parameter

sqlserver_tsql{ 'Always running':
  instance => 'MSSQLSERVER',
  command  => 'EXEC notified_executor()',
}

Advanced example

This advanced example:

• Installs the basic SQL Server Engine from installation media mounted at 'D:\' with TCP Enabled and various directories set.

• Uses only Windows-based authentication and installs with only the user that Puppet is executing as. Note that the 'sql_sysadmin_accounts' is only applicable during the instance installation and is not actively enforced.

• Creates a sqlserver::config resource, which is used in later resources to connect to the newly created instance. As we support only Windows-based authentication, a username and password is not required.

• Creates a local group called 'DB Administrators' and ensures that it is SQL System Administrator (sysadmin role); also creates the account that Puppet uses to install and manage the instance.

• Ensures that the advanced options for sp_configure are enabled, so that Puppet can manage the max memory setting for the instance.

• Ensure that the max memory (MB) configuration item is set to 2048 megabytes.

$sourceloc = 'D:/'

# Install a SQL Server default instance
sqlserver_instance{'MSSQLSERVER':
  source                => $sourceloc,
  features              => ['SQLEngine'],
  sql_sysadmin_accounts => [$facts['id']],
  install_switches      => {
    'TCPENABLED'          => 1,
    'SQLBACKUPDIR'        => 'C:\\MSSQLSERVER\\backupdir',
    'SQLTEMPDBDIR'        => 'C:\\MSSQLSERVER\\tempdbdir',
    'INSTALLSQLDATADIR'   => 'C:\\MSSQLSERVER\\datadir',
    'INSTANCEDIR'         => 'C:\\Program Files\\Microsoft SQL Server',
    'INSTALLSHAREDDIR'    => 'C:\\Program Files\\Microsoft SQL Server',
    'INSTALLSHAREDWOWDIR' => 'C:\\Program Files (x86)\\Microsoft SQL Server'
  }
}

# Resource to connect to the DB instance
sqlserver::config { 'MSSQLSERVER':
  admin_login_type => 'WINDOWS_LOGIN'
}

# Enforce SQL Server Administrators
$local_dba_group_name = 'DB Administrators'
$local_dba_group_netbios_name = "${facts['hostname']}\\DB Administrators"

group { $local_dba_group_name:
  ensure => present
}

-> sqlserver::login { $local_dba_group_netbios_name :
  login_type  => 'WINDOWS_LOGIN',
}

-> sqlserver::role { 'sysadmin':
  ensure   => 'present',
  instance => 'MSSQLSERVER',
  type     => 'SERVER',
  members  => [$local_dba_group_netbios_name, $facts['id']],
}

# Enforce memory consumption
sqlserver_tsql {'check advanced sp_configure':
  command => 'EXEC sp_configure \'show advanced option\', \'1\'; RECONFIGURE;',
  onlyif => 'sp_configure @configname=\'max server memory (MB)\'',
  instance => 'MSSQLSERVER'
}

-> sqlserver::sp_configure { 'MSSQLSERVER-max memory':
  config_name => 'max server memory (MB)',
  instance => 'MSSQLSERVER',
  reconfigure => true,
  restart => true,
  value => 2048
}

Note: $facts['hostnane'] is only suitable for building login names for local machine logins. For building domain logins you will need the domain name instead. $facts['domain'] returns the full domain name which will usually not be what you need. Try instead:

$netbios_name = split($facts['domain'],'\.')[0]

$dba_group_netbios_name = "${netbios_name}\\DB Administrators"

sqlserver::role { 'sysadmin':
  ensure   => 'present',
  instance => 'MSSQLSERVER',
  type     => 'SERVER',
  members  => [$dba_group_netbios_name, $facts['id']],
}

Reference

For information on the classes and types, see the REFERENCE.md

Limitations

SQL 2017, 2019 and 2022 detection support has been added. This support is limited to functionality already present for other versions.

The MSOLEDBSQL driver is now required to use this module. You can use this chocolatey package for installation. but it must version 18.x or earlier. (v19+ is not currently supported)

This module can manage only a single version of SQL Server on a given host (one and only one of SQL Server 2014, 2016, 2017, 2019 or 2022). The module is able to manage multiple SQL Server instances of the same version.

This module cannot manage the SQL Server Native Client SDK (also known as SNAC_SDK). The SQL Server installation media can install the SDK, but it is not able to uninstall the SDK. Note that the 'sqlserver_features' fact detects the presence of the SDK.

In SQL Server 2016 and newer, Microsoft separated the installation of SQL Server Management Studio (SSMS) from the installation of the SQL Server engine and other features. SSMS now has its own installer and can be installed and managed via Chocolatey. As such, specifying SSMS in the sqlserver as a feature to install no longer works with SQL Server 2016 and newer. Instead, use package resources with the Chocolatey provider to manage SSMS installation.

License

This codebase is licensed under the Apache2.0 licensing, however due to the nature of the codebase the open source dependencies may also use a combination of AGPL, BSD-2, BSD-3, GPL2.0, LGPL, MIT and MPL Licensing.

Development

This module was built by Puppet specifically for use with Puppet Enterprise (PE).

If you run into an issue with this module, or if you would like to request a feature, please file a ticket.

If you have problems getting this module up and running, please contact Support.

If you would like to contribute to this module, please follow the rules in the CONTRIBUTING.md. For more information, see our module contribution guide.

Reference

Table of Contents

Defined types

• sqlserver::config: Define Resource Type: sqlserver::config
• sqlserver::database: Define Resource Type: sqlserver::database
• sqlserver::login: Define Resource Type: sqlserver::login
• sqlserver::login::permissions: Define Resource Type: sqlserver::login::permissions#
• sqlserver::role: Define Resource Type: sqlserver::role::permissions
• sqlserver::role::permissions: Define Resource Type: sqlserver::role::permissions
• sqlserver::sp_configure: Defined Resource Type: sqlserver::sp_configure
• sqlserver::user: Define Resource Type: sqlserver::user
• sqlserver::user::permissions: Define Resource Type: sqlserver::user::permissions

Resource types

• sqlserver_features: Due to our prefetch and unaware of what name the user will provide we munge the value to meet our expecations.
• sqlserver_instance: Namevar
• sqlserver_tsql: Namevar

Functions

• sqlserver::partial_params_args: this function populates and returns the string of arguments which later gets injected in template.
• sqlserver_is_domain_or_local_user
• sqlserver_upcase
• sqlserver_validate_hash_uniq_values
• sqlserver_validate_instance_name
• sqlserver_validate_range
• sqlserver_validate_size

Tasks

• get_sql_logins: Retrieve information about the logins configured for a SQL Server instance.
• get_sqlagent_jobs: Return information about SQL Agent jobs and job steps.
• set_sql_logins: Set IsDisabled, and Password properties of a SQL Login
• start_sql_agent_job: Start SQL Agent jobs on a server. You can start at a specified job step number (zero based indexes), and you can either wait on the job to co

Defined types

sqlserver::config

Define Resource Type: sqlserver::config

Examples

sqlserver::config{'MSSQLSERVER':
  admin_user => 'sa',
  admin_pass => 'PuppetP@ssword1',
}

Parameters

The following parameters are available in the sqlserver::config defined type:

• instance_name
• admin_user
• admin_pass
• admin_login_type

instance_name

Data type: String[1,16]

The instance name you want to manage. Defaults to the $title when not defined explicitly.

Default value: $title

admin_user

Data type: Optional[Variant[Sensitive[String], String]]

Only required for SQL_LOGIN type. A user/login who has sysadmin rights on the server Can be passed as a sensitive value

Default value: undef

admin_pass

Data type: Optional[Variant[Sensitive[String], String]]

Only required for SQL_LOGIN type. The password in order to access the server to be managed. Can be passed as a sensitive value

Default value: undef

admin_login_type

Data type: Enum['SQL_LOGIN', 'WINDOWS_LOGIN']

The type of account use to configure the server. Valid values are SQL_LOGIN and WINDOWS_LOGIN, with a default of SQL_LOGIN The SQL_LOGIN requires the admin_user and admin_pass to be set The WINDOWS_LOGIN requires the adm_user and admin_pass to be empty or undefined

Default value: 'SQL_LOGIN'

sqlserver::database

Requirement/Dependencies: Requires defined type {sqlserver::config} in order to execute against the SQL Server instance

• See also
  • http://msdn.microsoft.com/en-us/library/ff929071.aspx
    • Contained Databases
  • http://msdn.microsoft.com/en-us/library/ms176061.aspx
    • CREATE DATABASE TSQL
  • http://msdn.microsoft.com/en-us/library/ms174269.aspx
    • ALTER DATABASE TSQL
  • http://msdn.microsoft.com/en-us/library/ms190303.aspx
    • System Languages

Parameters

The following parameters are available in the sqlserver::database defined type:

• db_name
• instance
• ensure
• compatibility
• collation_name
• filestream_non_transacted_access
• filestream_directory_name
• filespec_name
• filespec_filename
• filespec_size
• filespec_maxsize
• filespec_filegrowth
• log_name
• log_filename
• log_size
• log_maxsize
• log_filegrowth
• containment
• default_fulltext_language
• default_language
• nested_triggers
• transform_noise_words
• two_digit_year_cutoff
• db_chaining
• trustworthy

db_name

Data type: String[1,128]

The database you would like to manage

Default value: $title

instance

Data type: String[1,16]

The name of the instance which to connect to, instance names can not be longer than 16 characters

Default value: 'MSSQLSERVER'

ensure

Data type: Enum['present', 'absent']

Defaults to 'present', valid values are 'present' | 'absent'

Default value: 'present'

compatibility

Data type: Integer

Numberic representation of what SQL Server version you want the database to be compatabible with.

Default value: 100

collation_name

Data type: Optional[String[1]]

Default value: undef

filestream_non_transacted_access

Data type: Optional[Enum['OFF', 'READ_ONLY', 'FULL']]

Value should be { OFF | READ_ONLY | FULL } Specifies the level of non-transactional FILESTREAM access to the database.

Default value: undef

filestream_directory_name

Data type: Optional[Pattern[/^[\w|\s]+$/]]

A windows-compatible directory name. This name should be unique among all the Database_Directory names in the SQL Server instance. Uniqueness comparison is case-insensitive, regardless of SQL Server collation settings. This option should be set before creating a FileTable in this database.

Default value: undef

filespec_name

Data type: Optional[String[1,128]]

Specifies the logical name for the file. NAME is required when FILENAME is specified, except when specifying one of the FOR ATTACH clauses. A FILESTREAM filegroup cannot be named PRIMARY.

Default value: undef

filespec_filename

Data type: Optional[Stdlib::Absolutepath]

Specifies the operating system (physical) file name.

Default value: undef

filespec_size

Data type: Optional[String[1]]

Specifies the size of the file. The kilobyte (KB), megabyte (MB), gigabyte (GB), or terabyte (TB) suffixes can be used. The default is MB. Values can not be greater than 2147483647

Default value: undef

filespec_maxsize

Data type: Optional[String[1]]

Specifies the maximum size to which the file can grow. MAXSIZE cannot be specified when the os_file_name is specified as a UNC path

Default value: undef

filespec_filegrowth

Data type: Optional[String[1]]

Specifies the automatic growth increment of the file. The FILEGROWTH setting for a file cannot exceed the MAXSIZE setting. FILEGROWTH cannot be specified when the os_file_name is specified as a UNC path. FILEGROWTH does not apply to a FILESTREAM filegroup.

Default value: undef

log_name

Data type: Optional[String[1,128]]

Specifies the logical name for the file. NAME is required when FILENAME is specified, except when specifying one of the FOR ATTACH clauses. A FILESTREAM filegroup cannot be named PRIMARY.

Default value: undef

log_filename

Data type: Optional[Stdlib::Absolutepath]

Specifies the operating system (physical) file name.

Default value: undef

log_size

Data type: Optional[String[1]]

Specifies the size of the file. The kilobyte (KB), megabyte (MB), gigabyte (GB), or terabyte (TB) suffixes can be used. The default is MB. Values can not be greater than 2147483647

Default value: undef

log_maxsize

Data type: Optional[String[1]]

Specifies the maximum size to which the file can grow. MAXSIZE cannot be specified when the os_file_name is specified as a UNC path

Default value: undef

log_filegrowth

Data type: Optional[String[1]]

Specifies the automatic growth increment of the file. The FILEGROWTH setting for a file cannot exceed the MAXSIZE setting. FILEGROWTH cannot be specified when the os_file_name is specified as a UNC path. FILEGROWTH does not apply to a FILESTREAM filegroup.

Default value: undef

containment

Data type: Enum['PARTIAL', 'NONE']

Defaults to 'NONE'. Other possible values are 'PARTIAL', see http://msdn.microsoft.com/en-us/library/ff929071.aspx

Default value: 'NONE'

default_fulltext_language

Data type: String[1]

Language name i.e. us_english which are documented at http://msdn.microsoft.com/en-us/library/ms190303.aspx

Default value: 'English'

default_language

Data type: String[1]

Language name i.e. us_english which are documented at http://msdn.microsoft.com/en-us/library/ms190303.aspx

Default value: 'us_english'

nested_triggers

Data type: Optional[Enum['ON', 'OFF']]

On | Off see http://msdn.microsoft.com/en-us/library/ms178101.aspx

Default value: undef

transform_noise_words

Data type: Optional[Enum['ON', 'OFF']]

ON | OFF

Default value: undef

two_digit_year_cutoff

Data type: Integer[1753, 9999]

Defaults to 2049 | <any year between 1753 and 9999>

Default value: 2049

db_chaining

Data type: Enum['ON', 'OFF']

ON | OFF When ON is specified, the database can be the source or target of a cross-database ownership chain. When OFF, the database cannot participate in cross-database ownership chaining. The default is OFF.

Default value: 'OFF'

trustworthy

Data type: Enum['ON', 'OFF']

When ON is specified, database modules that use an impersonation context can access resources outside the database. For example, views, user-defined functions, or stored procedures. When OFF, database modules in an impersonation context cannot access resources outside the database. The default is OFF.

Default value: 'OFF'

sqlserver::login

Requirement/Dependencies: Requires defined type {sqlserver::config} in order to execute against the SQL Server instance

• See also
  • Puppet::Parser::Fucntions#sqlserver_validate_instance_name
  • http://msdn.microsoft.com/en-us/library/ms186320(v=sql.110).aspx
    • Server Role Members
  • http://technet.microsoft.com/en-us/library/ms189751(v=sql.110).aspx
    • Create Login
  • http://technet.microsoft.com/en-us/library/ms189828(v=sql.110).aspx
    • Alter Login

Parameters

The following parameters are available in the sqlserver::login defined type:

• login
• instance
• ensure
• password
• svrroles
• login_type
• default_database
• default_language
• check_expiration
• check_policy
• disabled
• permissions

login

Data type: String[1, 128]

The SQL or Windows login you would like to manage

Default value: $title

instance

Data type: String[1,16]

The name of the instance which to connect to, instance names can not be longer than 16 characters

Default value: 'MSSQLSERVER'

ensure

Data type: Enum['present', 'absent']

Defaults to 'present', valid values are 'present' | 'absent'

Default value: 'present'

password

Data type: Optional[Variant[Sensitive[String], String]]

Plain text password. Only applicable when Login_Type = 'SQL_LOGIN'. Can be passed through as a sensitive value.

Default value: undef

svrroles

Data type: Hash

A hash of preinstalled server roles that you want assigned to this login. sample usage would be { 'diskadmin' => 1, 'dbcreator' => 1, 'sysadmin' => 0, }

Default value: {}

login_type

Data type: Enum['SQL_LOGIN', 'WINDOWS_LOGIN']

Defaults to 'SQL_LOGIN', possible values are 'SQL_LOGIN' or 'WINDOWS_LOGIN'

Default value: 'SQL_LOGIN'

default_database

Data type: String

The database that when connecting the login should default to, the default value is 'master'

Default value: 'master'

default_language

Data type: String

The default language is 'us_english', a list of possible

Default value: 'us_english'

check_expiration

Data type: Boolean

Default value is false, possible values of true | false. Only applicable when Login_Type = 'SQL_LOGIN'.

Default value: false

check_policy

Data type: Boolean

Default value is false, possible values are true | false. Only applicable when Login_Type = 'SQL_LOGIN'.

Default value: true

disabled

Data type: Boolean

Default value is false. Accepts [Boolean] values of true or false.

Default value: false

permissions

Data type: Hash

A hash of permissions that should be managed for the login. Valid keys are 'GRANT', 'GRANT_WITH_OPTION', 'DENY' or 'REVOKE'. Valid values must be an array of Strings i.e. {'GRANT' => ['CONNECT SQL', 'CREATE ANY DATABASE'] }

Default value: {}

sqlserver::login::permissions

Requirement/Dependencies: Requires defined type {sqlserver::config} in order to execute against the SQL Server instance

Parameters

The following parameters are available in the sqlserver::login::permissions defined type:

• login
• permissions
• state
• instance
• with_grant_option

login

Data type: String[1,128]

The login for which the permission will be manage.

permissions

Data type: Array[String[4,128]]

An array of permissions you would like managed. i.e. ['SELECT', 'INSERT', 'UPDATE', 'DELETE']

state

Data type: Pattern[/(?i)^(GRANT|REVOKE|DENY)$/]

The state you would like the permission in. Accepts 'GRANT', 'DENY', 'REVOKE'. Please note that REVOKE equates to absent and will default to database and system level permissions.

Default value: 'GRANT'

instance

Data type: String[1,16]

The name of the instance where the user and database exists. Defaults to 'MSSQLSERVER'

Default value: 'MSSQLSERVER'

with_grant_option

Data type: Boolean

Bolean value that allows user to grant options.

Default value: false

sqlserver::role

Requirement/Dependencies: Requires defined type {sqlserver::config} in order to execute against the SQL Server instance

Parameters

The following parameters are available in the sqlserver::role defined type:

• ensure
• role
• instance
• authorization
• type
• database
• permissions
• members
• members_purge

ensure

Data type: Enum['present', 'absent']

Whether the role should be absent or present

Default value: 'present'

role

Data type: String[1,128]

The name of the role for which the permissions will be manage.

Default value: $title

instance

Data type: String[1,16]

The name of the instance where the role and database exists. Defaults to 'MSSQLSERVER'

Default value: 'MSSQLSERVER'

authorization

Data type: Optional[String]

The database principal that should own the role

Default value: undef

type

Data type: Enum['SERVER', 'DATABASE']

Whether the Role is SERVER or DATABASE

Default value: 'SERVER'

database

Data type: String[1,128]

The name of the database the role exists on when specifying type => 'DATABASE'. Defaults to 'master'

Default value: 'master'

permissions

Data type: Hash

A hash of permissions that should be managed for the role. Valid keys are 'GRANT', 'GRANT_WITH_OPTION', 'DENY' or 'REVOKE'. Valid values must be an array of Strings i.e. {'GRANT' => ['CONNECT', 'CREATE ANY DATABASE'] }

Default value: {}

members

Data type: Array[String]

An array of users/logins that should be a member of the role

Default value: []

members_purge

Data type: Boolean

Whether we should purge any members not listed in the members parameter. Default: false

Default value: false

sqlserver::role::permissions

Requirement/Dependencies: Requires defined type {sqlserver::config} in order to execute against the SQL Server instance

Parameters

The following parameters are available in the sqlserver::role::permissions defined type:

• role
• permissions
• state
• with_grant_option
• type
• database
• instance

role

Data type: String[1,128]

The name of the role for which the permissions will be manage.

permissions

Data type: Array[String[4,128]]

An array of permissions you want manged for the given role

state

Data type: Pattern[/(?i)^(GRANT|REVOKE|DENY)$/]

The state you would like the permission in. Accepts 'GRANT', 'DENY', 'REVOKE'. Please note that REVOKE equates to absent and will default to database and system level permissions.

Default value: 'GRANT'

with_grant_option

Data type: Boolean

Whether to give the role the option to grant this permission to other principal objects, accepts true or false, defaults to false

Default value: false

type

Data type: Enum['SERVER','DATABASE']

Whether the Role is SERVER or DATABASE

Default value: 'SERVER'

database

Data type: String[1,128]

The name of the database the role exists on when specifying type => 'DATABASE'. Defaults to 'master'

Default value: 'master'

instance

Data type: String[1,16]

The name of the instance where the role and database exists. Defaults to 'MSSQLSERVER'

Default value: 'MSSQLSERVER'

sqlserver::sp_configure

Required Dependencies: Requires defined type {sqlserver::config} in order to execute against the SQL Server instance

@see http://msdn.microsoft.com/en-us/library/ms176069.aspx Reconfigure Explanation @see http://msdn.microsoft.com/en-us/library/ms189631.aspx Server Configuration Options

Parameters

The following parameters are available in the sqlserver::sp_configure defined type:

• config_name
• value
• instance
• reconfigure
• with_override
• restart

config_name

Data type: Pattern['^\w+']

The config name found within sys.configurations that you would like to update

Default value: $title

value

Data type: Integer

The value you would like to change to for the given config_name, must be an integer value

instance

Data type: String[1,16]

The name of the instance you would like to manage against

Default value: 'MSSQLSERVER'

reconfigure

Data type: Boolean

If you would like to run RECONFIGURE against the server after updating the value, defaults to true

Default value: true

with_override

Data type: Boolean

This pertains tot he reconfigure in which you would want to override or force the reconfigure, defaults to false

Default value: false

restart

Data type: Boolean

Will ensure service resource and notify if changes occur for a restart

Default value: false

sqlserver::user

Requirement/Dependencies: Requires defined type {sqlserver::config} in order to execute against the SQL Server instance

Examples

sqlserver::user{'myUser':
  database  => 'loggingDatabase',
  login     => 'myUser',
}

Parameters

The following parameters are available in the sqlserver::user defined type:

• user
• database
• ensure
• default_schema
• instance
• login
• password
• permissions

user

Data type: String[1]

The username you want to manage, defaults to the title

Default value: $title

database

Data type: String[1,128]

The database you want the user to be created as

ensure

Data type: Enum['present', 'absent']

Ensure present or absent

Default value: 'present'

default_schema

Data type: Optional[String]

SQL schema you would like to default to, typically 'dbo'

Default value: undef

instance

Data type: String[1,16]

The named instance you want to manage against

Default value: 'MSSQLSERVER'

login

Data type: Optional[String[1]]

The login to associate the user with, by default SQL Server will assume user and login match if left empty

Default value: undef

password

Data type: Optional[String[1,128]]

The password for the user, can only be used when the database is a contained database.

Default value: undef

permissions

Data type: Hash

A hash of permissions that should be managed for the user. Valid keys are 'GRANT', 'GRANT_WITH_OPTION', 'DENY' or 'REVOKE'. Valid values must be an array of Strings i.e. {'GRANT' => ['SELECT', 'INSERT'] }

Default value: {}

sqlserver::user::permissions

Requirement/Dependencies: Requires defined type {sqlserver::config} in order to execute against the SQL Server instance

Parameters

The following parameters are available in the sqlserver::user::permissions defined type:

• user
• database
• permissions
• state
• with_grant_option
• instance

user

Data type: String[1,128]

The username for which the permission will be manage.

database

Data type: String[1,128]

The databaser you would like the permission managed on.

Default value: 'master'

permissions

Data type: Array[String[4,128]]

An array of permissions you would like managed. i.e. ['SELECT', 'INSERT', 'UPDATE', 'DELETE']

state

Data type: Pattern[/(?i)^(GRANT|REVOKE|DENY)$/]

The state you would like the permission in. Accepts 'GRANT', 'DENY', 'REVOKE'. Please note that REVOKE equates to absent and will default to database and system level permissions.

Default value: 'GRANT'

with_grant_option

Data type: Boolean

Whether to give the user the option to grant this permission to other users, accepts true or false, defaults to false

Default value: false

instance

Data type: String[1,16]

The name of the instance where the user and database exists. Defaults to 'MSSQLSERVER'

Default value: 'MSSQLSERVER'

Resource types

sqlserver_features

Due to our prefetch and unaware of what name the user will provide we munge the value to meet our expecations.

Properties

The following properties are available in the sqlserver_features type.

ensure

Valid values: present, absent

The basic property that the resource should be in.

Default value: present

features

Valid values: Tools, BC, Conn, SSMS, ADV_SSMS, SDK, IS, MDS, BOL, DREPLAY_CTLR, DREPLAY_CLT, DQC

Specifies features to install, uninstall, or upgrade. The list of top-level features include BC, Conn, SSMS, ADV_SSMS, SDK, IS and MDS. The 'Tools' feature is deprecated. Instead specify 'BC', 'SSMS', 'ADV_SSMS', 'Conn', and 'SDK' explicitly.

Parameters

The following parameters are available in the sqlserver_features type.

• install_switches
• is_svc_account
• is_svc_password
• name
• pid
• provider
• source
• windows_feature_source

install_switches

A hash of switches you want to pass to the installer

is_svc_account

Either domain user name or system account. Defaults to "NT AUTHORITY\NETWORK SERVICE"

is_svc_password

Password for domain user.

name

namevar

Due to our prefetch and unaware of what name the user will provide we munge the value to meet our expecations.

pid

Specify the SQL Server product key to configure which edition you would like to use.

provider

The specific backend to use for this sqlserver_features resource. You will seldom need to specify this --- Puppet will usually discover the appropriate provider for your platform.

source

Location of the source files.

windows_feature_source

Specify the location of the Windows Feature source files. This may be needed to install the .Net Framework. See https://support.microsoft.com/en-us/kb/2734782 for more information.

sqlserver_instance

Namevar

Properties

The following properties are available in the sqlserver_instance type.

ensure

Valid values: present, absent

The basic property that the resource should be in.

Default value: present

features

Valid values: SQL, SQLEngine, Replication, FullText, DQ, AS, RS, POLYBASE, ADVANCEDANALYTICS

Specifies features to install, uninstall, or upgrade. The list of top-level features include SQLEngine, Replication, FullText, DQ AS, and RS. The 'SQL' feature is deprecated. Instead specify 'DQ', 'FullText', 'Replication', and 'SQLEngine' explicitly.

Parameters

The following parameters are available in the sqlserver_instance type.

• agt_svc_account
• agt_svc_password
• as_svc_account
• as_svc_password
• as_sysadmin_accounts
• install_switches
• name
• pid
• polybase_svc_account
• polybase_svc_password
• provider
• rs_svc_account
• rs_svc_password
• sa_pwd
• security_mode
• source
• sql_svc_account
• sql_svc_password
• sql_sysadmin_accounts
• windows_feature_source

agt_svc_account

Either domain user name or system account

agt_svc_password

Password for domain user name. Not required for system account

as_svc_account

The account used by the Analysis Services service.

as_svc_password

The password for the Analysis Services service account.

as_sysadmin_accounts

Specifies the list of administrator accounts to provision.

install_switches

A hash of switches you want to pass to the installer

name

namevar

Namevar

pid

Specify the SQL Server product key to configure which edition you would like to use.

polybase_svc_account

The account used by the Polybase Engine service. Only applicable for SQL Server 2016+.

polybase_svc_password

The password for the Polybase Engine service account. Only applicable for SQL Server 2016+.

provider

The specific backend to use for this sqlserver_instance resource. You will seldom need to specify this --- Puppet will usually discover the appropriate provider for your platform.

rs_svc_account

Specify the service account of the report server. This value is required. If you omit this value, Setup will use the default built-in account for the current operating system (either NetworkService or LocalSystem). If you specify a domain user account, the domain must be under 254 characters and the user name must be under 20 characters. The account name cannot contain the following characters: " / \ [ ] : ; | = , + * ? < >

rs_svc_password

Specify a strong password for the account. A strong password is at least 8 characters and includes a combination of upper and lower case alphanumeric characters and at least one symbol character. Avoid spelling an actual word or name that might be listed in a dictionary.

sa_pwd

Required when :security_mode => "SQL"

security_mode

Valid values: SQL

Specifies the security mode for SQL Server. If this parameter is not supplied, then Windows-only authentication mode is supported. Supported value: SQL

source

Location of source files.

sql_svc_account

Account for SQL Server service: Domain\User or system account.

sql_svc_password

A SQL Server service password is required only for a domain account.

sql_sysadmin_accounts

Windows account(s) to provision as SQL Server system administrators.

windows_feature_source

Specify the location of the Windows Feature source files. This may be needed to install the .Net Framework. See https://support.microsoft.com/en-us/kb/2734782 for more information.

sqlserver_tsql

Namevar

Properties

The following properties are available in the sqlserver_tsql type.

onlyif

SQL Query to run and only run if exits with non-zero

returns

Returns the result of the executed command

Default value: 0

Parameters

The following parameters are available in the sqlserver_tsql type.

• command
• database
• instance
• name
• provider

command

command to run against an instance with the authenticated credentials used in sqlserver::config

database

initial database to connect to during query execution

Default value: master

instance

requires the usage of sqlserver::config with the user and password

name

namevar

Namevar

provider

The specific backend to use for this sqlserver_tsql resource. You will seldom need to specify this --- Puppet will usually discover the appropriate provider for your platform.

Functions

sqlserver::partial_params_args

Type: Ruby 4.x API

arguments that return string holds is conditional and decided by the the input given to function.

sqlserver::partial_params_args(Hash $args)

arguments that return string holds is conditional and decided by the the input given to function.

Returns: Variant[String] String Generated on the basis of provided values.

args

Data type: Hash

contains Enum['ON', 'OFF'] $db_chaining Enum['ON', 'OFF'] $trustworthy String[1] $default_fulltext_language String[1] $default_language Optional[Enum['ON', 'OFF']] $nested_triggers Optional[Enum['ON', 'OFF']] $transform_noise_words Integer[1753, 9999] $two_digit_year_cutoff

sqlserver_is_domain_or_local_user

Type: Ruby 3.x API

The sqlserver_is_domain_or_local_user function.

sqlserver_is_domain_or_local_user()

The sqlserver_is_domain_or_local_user function.

Returns: Boolean Returns true is the username is for local/domain.

sqlserver_upcase

Type: Ruby 3.x API

The sqlserver_upcase function.

sqlserver_upcase()

The sqlserver_upcase function.

Returns: Any Upcase values

sqlserver_validate_hash_uniq_values

Type: Ruby 3.x API

The sqlserver_validate_hash_uniq_values function.

sqlserver_validate_hash_uniq_values()

The sqlserver_validate_hash_uniq_values function.

Returns: String Returns the arguments or a message with the duplicate values.

sqlserver_validate_instance_name

Type: Ruby 3.x API

The sqlserver_validate_instance_name function.

sqlserver_validate_instance_name()

The sqlserver_validate_instance_name function.

Returns: Any Error if not a valid instance name.

sqlserver_validate_range

Type: Ruby 3.x API

The sqlserver_validate_range function.

sqlserver_validate_range()

The sqlserver_validate_range function.

Returns: Any Error if value is not between range

sqlserver_validate_size

Type: Ruby 3.x API

The sqlserver_validate_size function.

sqlserver_validate_size()

The sqlserver_validate_size function.

Returns: Any Error if not a valid size value

Tasks

get_sql_logins

Retrieve information about the logins configured for a SQL Server instance.

Supports noop? false

Parameters

instance_name

Data type: Optional[Variant[Array[String], String]]

The name of the SQL Instance running on the machine to connect to. Leave blank for the default instance of MSSQLSERVER

login_name

Data type: Optional[Variant[Array[String], String]]

The name of a particular login to search for. You can use partial names and any pattern that will work with the PowerShell '-match' operator.

exact_match

Data type: Optional[Boolean]

If set to true it will force names passed to the LoginName parameter to be an exact match to a SQL Login to pass the filter.

detailed

Data type: Optional[Boolean]

Return more detailed information from the server instead of the default summary information

get_sqlagent_jobs

Return information about SQL Agent jobs and job steps.

Supports noop? false

Parameters

instance_name

Data type: Optional[Variant[Array[String],String]]

The instance to get job information from

job_name

Data type: Optional[Variant[Array[String],String]]

The name or the pattern to match of the job to search for.

exact_match

Data type: Optional[Boolean]

Use only exact name matches for the job_name parameter instead of the default fuzzy matching.

set_sql_logins

Set IsDisabled, and Password properties of a SQL Login

Supports noop? true

Parameters

instance_name

Data type: Optional[Variant[Array[String],String]]

Instance that has the login to be modified. Leave blank for default instance.

login_name

Data type: Variant[Array[String],String]

Name of the login to modify. Matches are exact only by default.

fuzzy_match

Data type: Optional[Boolean]

Allow -match operator matches on $login_name so that inputs like 'sql' will match any login with 'sql' anywhere in the name.

enabled

Data type: Optional[Boolean]

Enable or disable an account. Set this to false to disable the account.

password

Data type: Optional[String]

The password to set for an account.

start_sql_agent_job

Start SQL Agent jobs on a server. You can start at a specified job step number (zero based indexes), and you can either wait on the job to complete, or return immediately.

Supports noop? false

Parameters

instance_name

Data type: Optional[Variant[Array[String],String]]

The instance to start a job on.

job_name

Data type: Variant[Array[String],String]

The name of the job to start.

fuzzy_match

Data type: Optional[Boolean]

Turn the job_name parameter into a pattern to match using the PowerShell -match operator.

step

Data type: Optional[Integer]

The zero based index number of the jop step to start from. Defaults to zero.

wait

Data type: Optional[Boolean]

Wait for all jobs started to complete before returning data. Defaults to false such that the task will return immediately indicating only that the job was started.

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog and this project adheres to Semantic Versioning.

v5.0.2 - 2024-07-18

Full Changelog

Fixed

• (CAT-1939) Reverting deferred function changes #477 (Ramesh7)

v5.0.1 - 2024-02-22

Full Changelog

Fixed

• (CAT-1728) - Unable to use password function as deferred function #469 (Ramesh7)

v5.0.0 - 2024-02-16

Full Changelog

Changed

• [CAT-1065] : Removing support for SQL Server 2012 #455 (rajat-puppet)

Added

• (CAT-1148) Conversion of ERB to EPP #454 (praj1001)

Fixed

• (Bug) - Remove default switch of UpdateEnabled=false when Action=Install #466 (jordanbreen28)
• (bugfix) Update Issues URL #456 (pmcmaw)

v4.1.0 - 2023-06-27

Full Changelog

Added

• pdksync - (MAINT) - Allow Stdlib 9.x #438 (LukasAud)
• (CONT-567) allow deferred function for password #436 (Ramesh7)

v4.0.0 - 2023-04-26

Full Changelog

Changed

• (CONT-800) - Add Puppet 8/Drop Puppet 6 #430 (jordanbreen28)

v3.3.0 - 2023-03-07

Full Changelog

Added

• (CONT-490) - Add support for SQL Server 2022 #420 (jordanbreen28)

Fixed

• Fix puppet strings formatting #414 (GSPatton)

v3.2.1 - 2022-12-13

Full Changelog

Fixed

• (CONT-370) Reinstate lost sqlserver documentation on feature & tool deprecations #412 (GSPatton)

v3.2.0 - 2022-08-23

Full Changelog

Added

• (CAT-136) Update dependencies #405 (LukasAud)

v3.1.0 - 2022-05-30

Full Changelog

Added

• pdksync - (FM-8922) - Add Support for Windows 2022 #397 (david22swan)
• (MODULES-5472) Login values can now be passed as sensitive strings #393 (david22swan)

Fixed

• (MODULES-10825) - Dotnet installation fix #392 (david22swan)

v3.0.0 - 2021-03-03

Full Changelog

Changed

• pdksync - Remove Puppet 5 from testing and bump minimal version to 6.0.0 #369 (carabasdaniel)

Added

• pdksync - (feat) - Add support for Puppet 7 #363 (daianamezdrea)

Fixed

• (FM-8879) Handle T-SQL Errors Properly #349 (RandomNoun7)

v2.6.2 - 2020-01-21

Full Changelog

Fixed

• (MODULES-10384) - Registry value check tightened #343 (david22swan)
• (MODULES-10335) - Update exec's title to be unique #341 (david22swan)

v2.6.1 - 2020-01-20

Full Changelog

Fixed

• (MODULES-10388) fix missing gem #339 (sheenaajay)

v2.6.0 - 2019-10-22

Full Changelog

Added

• Add support for Server 2019 #327 (sanfrancrisko)

v2.5.1 - 2019-09-20

Full Changelog

Fixed

• (MODULES-9912) ERB Template Errors #320 (RandomNoun7)
• (MODULES-6904) Restart SQL Server Service with Dependent Services #315 (RandomNoun7)
• (MODULES-8439) Fix sqlserver_instances custom fact #314 (carabasdaniel)
• (MODULES-8600) add DQC to sqlserver_features #313 (tphoney)

2.5.0 - 2019-03-26

Full Changelog

Added

• (MODULES-8610) Add start agent job task #301 (RandomNoun7)

Fixed

• (MODULES-8749) Make job_name param required. #303 (RandomNoun7)

Other

• (MAINT) Increase timeout interval #306 (RandomNoun7)
• (MODULES-8761) Docs release review #305 (clairecadman)

2.4.0 - 2019-03-12

Full Changelog

Other

• Release Prep 2.4.0 #298 (RandomNoun7)
• (MODULES-8721) README edit #297 (clairecadman)
• (MODULES-8677) Made resource title unique among many instances #296 (dylanratcliffe)
• (MODULES-8685) Changed END to be in the same conditional as BEGIN #295 (dylanratcliffe)
• (MODULES-8692) Get Agent Jobs Task #294 (RandomNoun7)
• (MODULES-8606) Add SQL Logins Tasks #291 (RandomNoun7)
• (MAINT) Migrate test resources to artifactory - Fix Pipelines. #290 (RandomNoun7)
• (MODULES-8489) Mergeback to master #289 (ThoughtCrhyme)

2.3.0 - 2019-01-22

Full Changelog

Other

• (MODULES-8485) Release Prep 2.3.0 #288 (RandomNoun7)
• (MAINT) Fix changelog. #287 (RandomNoun7)
• Updated license terms #286 (turbodog)
• (MODULES-8438) Install 2019 #285 (RandomNoun7)
• (maint) Update pdk template #284 (jpogran)
• (MODULES-8130) Merge-back of release to master #283 (glennsarti)
• MODULES-7734 Detect installed features with value greater than 1 #274 (GrammatonKlaric)

2.2.0 - 2018-12-04

Full Changelog

Other

• Update Release Date In Changelog #281 (RandomNoun7)
• (MAINT) fix CHANGELOG compare link #280 (ThoughtCrhyme)
• (MODULES-8126) release prep for 2.2.0 #279 (ThoughtCrhyme)
• (L10n) Updating translations for readmes/README_ja_JP.md #278 (ThoughtCrhyme)
• (MODULES-7833) Update metadata for Puppet 6 #277 (ThoughtCrhyme)
• (maint) Spec fixes #273 (Iristyle)
• pdksync - (MODULES-7658) use beaker4 in puppet-module-gems #272 (tphoney)
• pdksync - (MODULES-7705) - Bumping stdlib dependency from < 5.0.0 to < 6.0.0 #271 (pmcmaw)
• pdksync - (MODULES-7658) use beaker3 in puppet-module-gems #270 (tphoney)
• (MODULES-7406) PDK Convert the module #269 (glennsarti)
• Merge Release Back To Master #268 (RandomNoun7)

2.1.1 - 2018-03-14

Full Changelog

Other

• (MAINT) Fix Release Date in Changelog #267 (RandomNoun7)
• (MAINT) Fix Changelog Link #266 (RandomNoun7)
• (MODULES-6760) prep for 2.1.1 release #265 (RandomNoun7)
• (DOCUMENT-824) Update Changelog Format #264 (RandomNoun7)
• (MODULES-6281) Return Errors from T-SQL #263 (RandomNoun7)
• (FM-6605) Add CONTRIBUTING.MD to repository #262 (glennsarti)
• (maint) modulesync 65530a4 Update Travis #260 (michaeltlombardi)
• (MODULES-6356) Fixes a problem still remaining from MODULES-2904 #259 (kreeuwijk)
• (maint) modulesync cd884db Remove AppVeyor OpenSSL update on Ruby 2.4 #258 (michaeltlombardi)
• (maint) - modulesync 384f4c1 #256 (tphoney)
• Merge Release back to master #255 (jpogran)

2.1.0 - 2017-12-08

Full Changelog

Other

• (MODULES-6239) prep for 2.1.0 release #254 (RandomNoun7)
• (MODULES-6244) Update 2017 Support #253 (RandomNoun7)
• Merge Release back to Master #252 (michaeltlombardi)
• (MODULES-6168) Detect SQL 2017 #251 (RandomNoun7)

2.0.2 - 2017-12-04

Full Changelog

Other

• (MODULES-6022) Make SQLServer Instance Idempotent Again #250 (michaeltlombardi)
• (maint) - modulesync 1d81b6a #248 (pmcmaw)
• Merge release back into master #247 (glennsarti)
• (FM-6464) Update metadata for open sourcing #245 (michaeltlombardi)

2.0.1 - 2017-11-14

Full Changelog

Other

• (MODULES-5961) Prep for release 2.0.1 #246 (michaeltlombardi)
• (MAINT) Correct supported versions & platforms #244 (michaeltlombardi)
• (MODULES-5693) Replace SQLOLEDB with SQLNCLI11 #243 (michaeltlombardi)
• (maint) Remove instance during acceptance tests #242 (glennsarti)
• (MODULES-5566) Rewrite Instance Discovery #241 (michaeltlombardi)
• (Maintenance) remove redundant rake task #240 (ThoughtCrhyme)
• Added 2016 to supported versions #239 (davinhanlon)
• (maint) modulesync 892c4cf #238 (HAIL9000)
• release 2.0.0 mergeback #237 (eputnam)

2.0.0 - 2017-08-10

Full Changelog

Other

• (maint) Update changelog to comply with Puppet formatting #236 (glennsarti)
• (maint) modulesync 915cde70e20 #235 (glennsarti)
• (MODULES-5209) Prepare for 2.0.0 release #234 (glennsarti)
• (FM-6141) Add test-tiering, and README to spec directory #233 (ThoughtCrhyme)
• some edits for sqlserver changes #232 (jbondpdx)
• (MODULES-5070) Add polybase parameters to sql_instance #231 (glennsarti)
• (MODULES-5126) Use integer in acceptance test #230 (glennsarti)
• (MODULES-5187)(MODULES-52080) mysnc puppet 5 and ruby 2.4 #229 (eputnam)
• (MODULES-5144) Prep for puppet 5 #228 (hunner)
• (MODULES-5126) Puppet4ing SQL Server #227 (glennsarti)
• (maint) Add more advanced examples to documentation #226 (glennsarti)
• (MODULES-4842) Update puppet compatibility with 4.7 as lower bound #225 (glennsarti)
• (MODULES-4915) Remove forced TCP connection for SQL management #224 (glennsarti)
• (FM-5062) Add testmode switcher to sqlserver module #223 (ThoughtCrhyme)
• (FM-5021) Escaping identifiers when creating a database #222 (glennsarti)
• (MODULES-2543) Purge members from SQL Server Role #221 (glennsarti)
• (MODULES-2386) Using as_sysadmin_accounts without AS feature should error #220 (glennsarti)
• (FM-5389) Fix sql_features when installing SNAC_SDK #219 (glennsarti)
• (FM-5389) Add missing shared feature SNAC_SDK #218 (glennsarti)
• (MODULES-5030) Remove service_ensure parameter #217 (glennsarti)
• (MODULES-5092) Failures during .Net 3 installation should be obvious #216 (glennsarti)
• (MODULES-4257) Modify instance and features for SQL Server 2016 #215 (glennsarti)
• (maint) Update test helper for SQL Server 2016 #213 (glennsarti)
• (MODULES-5031) Modify facts for SQL Server 2016 #212 (glennsarti)
• (MODULES-4257) Add SQL Server 2016 support in acceptance tests #211 (glennsarti)
• Release mergeback #210 (pmcmaw)

1.2.0 - 2017-05-09

Full Changelog

Other

• 1.2.0 Release Prep #209 (HelenCampbell)
• fixing a typo for jp translation #208 (jbondpdx)
• Adding correct project url and newline to metadata #207 (HelenCampbell)
• (MODULES-4667) Update beaker tests for Jenkins CI #206 (glennsarti)
• [msync] 786266 Implement puppet-module-gems, a45803 Remove metadata.json from locales config #205 (wilson208)
• (MODULES-4334) - Adding locales directory, POT file and config.yaml #204 (pmcmaw)
• [MODULES-4528] Replace Puppet.version comparison with Puppet::Util::Package.versioncmp #203 (wilson208)
• (maint) Release mergeback #202 (DavidS)

1.1.6 - 2017-03-07

Full Changelog

Other

• [FM-6077] Release 1.1.6 #201 (wilson208)
• [PE-17491] Do not fail on install when a restart exit code is returned #200 (wilson208)

1.1.5 - 2017-02-16

Full Changelog

Other

• (FM-6026) Release 1.1.5 #199 (glennsarti)
• (MODULES-4321): edit sqlserver for loc #198 (jbondpdx)
• (maint) Prime Feature and Instance installation with .Net 3.5 source #197 (wilson208)
• (MODULES-4098) Sync the rest of the files #196 (hunner)
• [MODULES-4255] Obfuscate passwords in sqlserver_instance #195 (wilson208)
• (MODULES-4263) add blacksmith rake tasks #194 (eputnam)
• (MODULES-4097) Sync travis.yml #193 (hunner)
• (FM-5972) Update to next modulesync_configs [dedaf10][#192](https://github.com/puppetlabs/puppetlabs-sqlserver/pull/192) (DavidS)
• (MODULES-3632) Use json_pure always #191 (hunner)
• (MODULES-3704) Update gemfile template to be identical #190 (hunner)

1.1.4 - 2016-08-31

Full Changelog

Other

• (FM-5476) (docs) Edits for docs signoff #189 (gguillotte)
• (MODULES-3775) (msync 8d0455c) update travis/appveyer w/Ruby 2.3 #188 (MosesMendoza)
• (maint) modulesync 70360747 #187 (glennsarti)
• (FM-5473) Release 1.1.4 #186 (glennsarti)
• (MODULES-3752) Fix modifying server_roles for an existing WINDOWS_LOGIN #185 (glennsarti)
• (BKR-914) Add workaround for beaker bug BKR-914 #184 (glennsarti)
• (MODULES-3202) Fix install dependencies with custom source #183 (glennsarti)
• (MODULES-3256)(MODULES-2323)(MODULES-2554)(MODULES-3083) Fix sqlserver::login resource #182 (glennsarti)
• (MODULES-3640) Update modulesync 30fc4ab #181 (MosesMendoza)
• (PA-285) Branding name change #166 (jpogran)

1.1.3 - 2016-07-12

Full Changelog

Other

• (MODULES-3493) Prepare for Release v1.1.3 #179 (glennsarti)
• (MODULES-3536) modsync update #177 (glennsarti)
• (maint) Update rakefile for puppetlabs_spec_helper #176 (glennsarti)
• (FM-5387) Remove simplecov gem and update for modsync #175 (glennsarti)
• (PE-16132) Add Windows Based Authentication for sqlserver::config #174 (glennsarti)
• (FM-5324) Fix TSQL error propagation #173 (Iristyle)
• (maint) remove trailing README whitespace #171 (Iristyle)
• (MODULES-3355) Fix acceptance tests for Sqlserver role #169 (jpogran)
• (MODULES-3356) Branding Name Change #168 (jpogran)
• (MODULES-3355) Fix Role Name Collisions #167 (jpogran)
• Merge up to master from stable after modsync changes #165 (ferventcoder)
• (maint) modsync update - stable #163 (glennsarti)
• (MODULES-3240) Fix rspec-puppet incompatibility #162 (glennsarti)

1.1.2 - 2016-04-08

Full Changelog

Other

• (FM-5081) Supported Release 1.1.2 #160 (ferventcoder)
• (FM-5080) add Puppet version ranges #159 (ferventcoder)
• (FM-5041) Install PE License for Acceptance Testing #158 (cowofevil)
• (FM-4918) update modsync / Restrict Rake ~> 10.1 #153 (ferventcoder)

1.1.1 - 2015-12-08

Full Changelog

Other

• (FM-3940) Fix specs - Puppet 4.x validation errors #155 (ferventcoder)
• (FM-3502) Release 1.1.1 #154 (ferventcoder)
• (FM-3706)Create database with optional compatibility breaks CI #152 (phongdly)
• (FM-3655) SQL Server CI acceptance issues #151 (phongdly)
• (MODULES-2497) SQLSERVER - Create Automated Tests for sqlserver::login #150 (phongdly)
• (MODULES-2496) Create Automated Tests for sqlserver::database #149 (phongdly)
• (MODULES-3094) Release 1.1.0 #148 (cyberious)
• (MODULES-2469) Create Automated Tests for sqlserver::role #147 (phongdly)
• (MODULES-2454)/Automated_Test_For_Database_User #142 (phongdly)
• Merge master to stable #136 (cyberious)

1.1.0 - 2015-09-08

Full Changelog

Other

• (MODULES-2498) Fix the check on removal #146 (cyberious)
• (MODULES-2498) generate random instance name in each context #145 (phongdly)
• (MODULES-2464) Simplify query for sp_configure check #144 (cyberious)
• (MODULES-2453) Create Automated Tests for sqlserver_tsql #141 (phongdly)
• (MODULES-2392) Automated Tests for sqlserver::config #140 (phongdly)
• (MODULES-2451) Fix issue with integer interpretations #139 (cyberious)
• (FM-3094) Prepare for release 1.1.0 #137 (cyberious)
• (maint) Guarantee Facter version for old Puppets / (MODULES-2452) Update Beaker Version #135 (ferventcoder)
• (MODULES-2391) Create Automated Tests For sqlserver_instance 2015-08-26 #134 (phongdly)
• (MODULES-2430) Fix issue parsing facts with puppet 4 #133 (cyberious)
• (FM-3252) CI Pipeline for sqlserver at step 7a #132 (phongdly)
• (MODULES-2403) Improve error handling for sqlserver_tsql #131 (cyberious)
• (MODULES-2377) Add validation for sp_configure bools #130 (cyberious)
• (docs) Several docs updates #129 (cyberious)
• (docs) MODULES-2325 update readme to reflect permissions #128 (cyberious)
• (DO NOT MERGE)(MODULES-2312) Use sp_executesql to execute T-SQL #127 (Iristyle)
• (maint) puppetlabs_spec_helper ~>0.10.3 #125 (ferventcoder)
• (maint) replaced debian6 by centos7 master in nodesets yml files #124 (phongdly)
• (MODULES-2207) bin beaker-rspec to ~> 5.1 #123 (ferventcoder)
• (MODULES-2245) Fixes issue with assumption of strings #122 (cyberious)
• (MODULES-2207) Modulesync #121 (ferventcoder)
• (maint) Move to use Beaker-puppet_install_helper #120 (cyberious)
• (maint) fix future parser acceptance failures #119 (Iristyle)
• (maint) remove unneeded pre-suite module installs #118 (Iristyle)
• Fix Jenkins acceptance failures #117 (Iristyle)
• (FM-2303, FM-2790, FM-2445) WMI / Registry impl of Discovery Report #116 (Iristyle)
• (maint) remove references to beaker method step #115 (zreichert)
• (maint) Inject CommonProgramFiles env var #113 (Iristyle)
• (FM-2791) Add database param to sqlserver_tsql #112 (cyberious)
• Update README per DOC-1595 #110 (psoloway)
• (maint) Lint and strict variables #109 (cyberious)
• (MAINT) remove forge host from nodesets #108 (zreichert)
• (maint) fix module installation #107 (Iristyle)
• (FM-2713) Remove sqlserver::config file requirement #106 (cyberious)
• (FM-2577) Minor SQL server connection building refactorings #105 (Iristyle)
• (fix) - upcase instance name so we always have a consistent pattern to how SQL Server reports back names #104 (cyberious)
• (fix) - Autoload property sqlserver_tsql when running from master #100 (cyberious)
• (FM-2577) - Change from sqlcmd.exe to win32ole connector #99 (cyberious)
• (maint) - Add .geppetto-rc.json to configure excludes #98 (cyberious)
• Fix spec tests raise_error check #91 (cyberious)
• Setup acceptance tests #87 (zreichert)
• (BKR-147) add Gemfile setting for BEAKER_VERSION for puppet... #84 (anodelman)
• FM-2328: document install_switches param in sqlserver #82 (jbondpdx)
• FM-2303 Add install switches needed by customer #81 (cyberious)
• FM-2298 and FM-2299 update Login and User to take hash of permissions #79 (cyberious)
• FM-2303 Add install switches to sqlserver_install and sqlserver_features #78 (cyberious)
• FM-2288 Role members #77 (cyberious)
• FM-2287 Add Role Permissions ability #76 (cyberious)
• Update sqlserver_validate_range to take array #74 (cyberious)
• (DO NOT MERGE) - Pending Readme changes for Review #73 (cyberious)
• FM-1556 Add ability to manage login server level permissions #72 (cyberious)
• FM-2236 Add with_grant_option for user permissions #71 (cyberious)
• FM-1898 Add sqlserver::user::permssion with GRANT, REVOKE and DENY #70 (cyberious)
• FM1901 Add delete user capabilities #69 (cyberious)
• FM-1900 Add User defined type #68 (cyberious)
• Fix bug with TSQL provider rework #67 (cyberious)
• DOC-1510: edit tsql additions #66 (jbondpdx)
• FM-2110 README Predocs for sqlserver_tsql provider #65 (cyberious)
• FM-2110 Prep TSQL provider ... #64 (cyberious)
• FM-2102 fix examples/sp_configure.pp #63 (cyberious)
• FM-2122: Deleted irrelevant contribution information #62 (jbondpdx)
• add geppetto-rc file to ignore examples #61 (justinstoller)
• Fix metadata.json and capture back puppet module build metadata.json #60 (cyberious)

1.0.0 - 2014-12-15

Full Changelog