sqlserver

supported
pdk
tasks
The `sqlserver` module installs and manages MS SQL Server 2012, 2014, 2016, 2017, and 2019 on Windows systems.
Puppet

Puppet

puppetlabs

121,856 downloads

8,510 latest version

5.0 quality score

Version information

  • 2.6.2 (latest)
  • 2.6.1
  • 2.6.0
  • 2.5.1
  • 2.5.0
  • 2.4.0
  • 2.3.0
  • 2.2.0
  • 2.1.1
  • 2.1.0
  • 2.0.2
  • 2.0.1
  • 2.0.0
  • 1.2.0
  • 1.1.6
  • 1.1.5
  • 1.1.4
  • 1.1.3
  • 1.1.2
  • 1.1.1
  • 1.1.0
  • 1.0.0
  • 0.0.1
released Jan 21st 2020
This version is compatible with:
  • Puppet Enterprise 2019.8.x, 2019.7.x, 2019.5.x, 2019.4.x, 2019.3.x, 2019.2.x, 2019.1.x, 2019.0.x, 2018.1.x
  • Puppet >=5.5.10 < 7.0.0
  • Windows
Tasks:
  • get_sql_logins
  • get_sqlagent_jobs
  • set_sql_logins
  • start_sql_agent_job

You'll need Puppet Enterprise to use this module. You may also evaluate this module with Puppet Bolt for up to 90 days.Learn More

Start using this module

Documentation

puppetlabs/sqlserver — version 2.6.2 Jan 21st 2020

Change log

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.

v2.6.2 (2020-01-21)

Full Changelog

Fixed

v2.6.1 (2020-01-16)

Full Changelog

Fixed

v2.6.0 (2019-10-21)

Full Changelog

Added

v2.5.1

Fixed

  • Add DQC to sqlserver_features feature attribute (MODULES-8600)
  • Fix sqlserver_instances fact fails when registry contains uninstalled instances (MODULES-8439)
  • Switch to using PowerShell Restart-Service .. -Force to restart the SQLServer service in sqlserver::sp_configure (MODULES-6904)
  • Fix ERB Template Errors (MODULES-9912)

2.5.0 - 2019-03-26

Added

Fixed

  • Missing type declaration for the get_sqlagent_job.json
  • Make job_name param required for the start_sql_agent_job task (MODULES-8749)

2.4.0 - 2019-03-12

Added

Fixed

2.3.0 - 2019-01-22

Added

  • Add support for installing and managing SQL 2019 instances (MODULES-8438)

Changed

  • License terms updated to allow a Bolt trial period (License)

Fixed

  • .NET 3.5 could be installed in cases where it was not necessary. (MODULES-8438)
  • Features were not detected correctly if the registry keys were stored with a value other than 1. (Thanks GrammatonKlaric) (MODULES-7734)

2.2.0 - 2018-12-3

Added

Changed

[2.1.1] - 2018-03-14

Added

Fixed

  • Fix problem installing sql instance when an array of SQL Admins are specified. (MODULES-6356)
  • Fix AppVeyor OpenSSL bug.(Modsync commit with discussion)
  • During acceptance testing, only execute master provisioning steps if there is a master in the hosts array.
  • Stop running gem update bundler during Travis runs. (MODULES-6339)
  • The sqlserver_tsql resource now returns errors from sql queries properly. (MODULES-6281)

[2.1.0] - 2017-12-8

Added

  • Add support for installing and managing SQL 2017 instances. (MODULES-6168)

Changed

  • Update documentation to reflect change that adds 2017 support. (MODULES-6244)

[2.0.2] - 2017-12-5

Fixed

  • Fix bug where Puppet will not detect existing sql instances properly and attempts to reinstall an instance that already exists (MODULES-6022)

[2.0.1] - 2017-11-15

Changed

  • Allow connections over TLS 1.1+ by replacing OLEDB driver with SQL Native Client (MODULES-5693)
  • Updated documentation to include 2016 as a supported version of SQL Server

Fixed

  • Ensure instances without SQL Engine are discoverable (MODULES-5566)

[2.0.0] - 2017-08-10

Added

  • Added more detailed examples to the README
  • Updated with Puppet 4 data types (MODULES-5126)
  • Added parameters to manage PolyBase (MODULES-5070)
  • Added support for Windows Server 2016
  • Added test tiering and test mode switcher (FM-5062, FM-6141)
  • Make .Net installation errors more obvious (MODULES-5092)

Changed

Deprecated

  • Deprecated the use of Tools and SQL as installation features (MODULES-4257)

Removed

  • Removed unsupported Puppet versions from metadata (MODULES-4842)
  • Removed support for Stdlib on unsupported Puppet versions, (Stdlib versions less than 4.13.0)
  • Removed service_ensure parameter as it had no use (MODULES-5030)

Fixed

  • Using as_sysadmin_accounts without AS feature will error (MODULES-2386)
  • SNAC_SDK shared feature can not be managed by the module (FM-5389)
  • Purge members from SQL Server Role should actually purge (MODULES-2543)
  • Identifiers are properly escaped during database creation (FM-5021)
  • Removed forced TCP connection for SQL management (MODULES-4915)

[1.2.0] - 2017-05-08

Added

  • Added locales directory, config.yaml and POT file for i18n. (MODULES-4334)
  • Puppet-module-gems now implemented

Fixed

  • Replace Puppet.version comparison with Puppet::Util::Package.versioncmp (MODULES-4528)
  • Update beaker tests for Jenkins CI (MODULES-4667)

[1.16] - 2017-03-07

Fixed

  • Fix issue where error was raised when adding or removing features if setup.exe returned 1641 (Reboot initiated) or 3010 (Reboot required) exit codes, only a warning is raised now (MODULES-4468).

[1.1.5] - 2017-02-15

Added

  • Obfuscate passwords in logs if sqlserver_instance raises an error (MODULES-4255).

Fixed

  • Fix issues with installing .Net 3.5 in acceptance tests
  • Fix various issues with test environment in AppVeyor, Travis CI and Jenkins
  • Fix documentation for localizationb

[1.1.4] - 2016-08-31

Added

  • Add windows_feature_source parameter to the sqlserver_instance and sqlserver_features resources. This specifies the location of the Windows Feature source files, which might be needed to install the .NET Framework. See https://support.microsoft.com/en-us/kb/2734782 for more information (MODULES-3202).

Fixed

  • Fix issues when adding multiple SYSADMIN role accounts on instance creation (MODULES-3427).
  • Fix issues when creating and deleting Windows base logins (MODULES-3256).
  • Fix errors when deleting MS SQL Server logins (MODULES-2323) and databases (MODULES-2554).
  • Refactor acceptance tests for sqlserver::login resource (MODULES-3256).
  • Fix issues when modifying server roles for an existing login (MODULES-3083).
  • Fix issues when modifying an existing Windows user login (MODULES-3752).

[1.1.3] - 2016-07-12

Added

  • Update documentation with a more advanced SQL example.
  • Add Windows Based Authentication for sqlserver::config. Modifies the sqlserver::config class with an additional property called login_type which can be either SQL_LOGIN or WINDOWS_LOGIN, with a default of SQL_LOGIN.

Changed

  • Minor refactoring of code which is not used or makes code path more obvious.

Fixed

  • Fix Role Name Collisions. This fix introduces the database name into the title created for the sqlserver_tsql statements so that it is unique.
  • Fix TSQL error propagation. Introduce a minor refactor so that the returns property captures errors properly from TSQL executions.
  • Emit debug output on failed onlyif TSQL. Previously, there was no way of getting the log output from SQL Server when executing TSQL during an onlyif.

[1.1.2] - 2016-04-11

Changed

  • Update supported Puppet version ranges.

[1.1.1] - 2015-12-08

Changed

  • Support newer PE versions.

[1.1.0] - 2015-09-08

Added

  • sqlserver_instance and sqlserver_features have new parameter install_switches, which takes a hash of install switches and writes them to a temporary configuration file for the install process. (FM-2303)
  • Add define for permissions for Users, Roles, and Logins.
  • New sqlserver_tsql provider available to execute custom scripts.

Changed

  • Remove dependency on 'sqlcmd.exe'. (FM-2577)
  • sqlserver::config no longer writes a file to the sytem.
  • Performance discovery improvements.

Removed

  • Remove dependency for ACL modules.

Fixed

  • Munge values for instance names to always be uppercase when comparing.
  • Change the way we look up logins to use sys.server_principals instead of a function that might not report correctly.
  • Fix issue with collation_name and databases where the variable was not named properly, causing it to never be set.

[1.0.0] - 2014-12-08

Initial release.

* This Changelog was automatically generated by github_changelog_generator