HISTORY.md

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

• Bolt task to start SQL agent jobs (MODULES-8610).

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

• Get agent jobs Bolt task (MODULES-8692)
• Get sql logins Bolt task (MODULES-8606)
• Set sql logins Bolt task (MODULES-8606)

Fixed

• Cannot manage a role with the same name on two instances or two databases (MODULES-8677) (Thanks Dylan Ratcliffe)
• Removing a SQL Login via ensure => absent in a sqlserver::login resource is not idempotent. (MODULES-8685) (Thanks Dylan Ratcliffe)

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

• Convert module for PDK (MODULES-7406)

Changed

• Update support for Puppet version 6. (MODULES-7833)
• Update README_ja_JP.md
• Update stdlib version to 6. (MODULES-7705)

[2.1.1] - 2018-03-14

Added

• Add CONTRIBUTING.md (FM-6605)

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 server provisioning steps if there is a server 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

• Updated metadata for Puppet 5 (MODULES-5144)

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.