Dependent cookbooks

This cookbook has no specified dependencies.

Contingent cookbooks

There are no cookbooks that are contingent upon this one.

sql_server Cookbook CHANGELOG

This file is used to list changes made in each version of the sql_server cookbook.

8.0.2 - 2024-05-01

8.0.1 - 2023-10-31

8.0.0 - 2023-09-28

• Remove recipes and attributes
• Remove duplicate _ConfigurationFile.ini.erb
• Remove specs for recipes
• Move the InSpec test to the correct directory

7.2.6 - 2023-09-28

7.2.5 - 2023-09-04

7.2.4 - 2023-07-10

7.2.3 - 2023-05-17

7.2.2 - 2023-05-10

• Use reusable lint-unit workflow

7.2.1 - 2023-04-07

Standardise files with files in sous-chefs/repo-management

7.2.0 - 2023-04-04

• Added support for SQL 2022 via resource installation method

7.1.13 - 2023-04-01

7.1.12 - 2023-04-01

7.1.11 - 2023-04-01

Standardise files with files in sous-chefs/repo-management

7.1.10 - 2023-03-20

Standardise files with files in sous-chefs/repo-management

7.1.9 - 2023-03-15

Standardise files with files in sous-chefs/repo-management

7.1.8 - 2023-02-27

Standardise files with files in sous-chefs/repo-management

7.1.7 - 2023-02-20

7.1.6 - 2023-02-16

Standardise files with files in sous-chefs/repo-management

7.1.5 - 2023-02-14

Standardise files with files in sous-chefs/repo-management

7.1.4 - 2023-02-14

7.1.3 - 2022-12-13

Standardise files with files in sous-chefs/repo-management

Standardise files with files in sous-chefs/repo-management

7.1.2 - 2022-02-08

• Remove delivery folder

7.1.1 - 2022-02-03

Standardise files with files in sous-chefs/repo-management

7.1.0 - 2021-10-01

• Adds parameter for tempdb data and log file initial size
• Adds parameter for number of tempdb data files to create
• Adds parameter for granting instant file initialization to Sql Server service account.

7.0.0 - 2021-09-08

• Set environment flag to accept chef licence for CI jobs
• Allow unsecure commands in windows CI jobs, needed for chef to install.
• Remove windows cookbook dependency as it is no longer maintained.

6.2.3 - 2021-08-30

• Standardise files with files in sous-chefs/repo-management

6.2.2 - 2021-06-01

• Standardise files with files in sous-chefs/repo-management

6.2.1 - 2021-05-06

• Adding new checksums for Windows 20212 SQL component .msi packages

6.2.0 - 2021-03-02

• Sous Chefs Adoption
• Add proper InSpec tests
• Remove windows_path resource in client recipe as it's not needed anymore
• Set netfx35_install to false by default as it fails currently otherwise

6.1.0 (2020-06-24)

• Cookstyle 6.2.9 Fixes - @xorimabot
• Standardise files with files in chef-cookbooks/repo-management - @xorimabot
• [GH-146] SQL 2019 Support

6.0.0 (2020-02-19)

This release removes support for deprecated SQL Server, Chef Infra Client, and Windows OS releases:

• Require Chef Infra Client 13+
• Remove support for Windows 2008 R2
• Remove support for SQL Server 2008 and 2014

5.6.0 (2020-02-18)

• Resolve multiple Cookstyle warnings - @tas50
• Remove unused long_description metadata - @tas50
• Remove unnecessary foodcritic comments - @tas50
• Remove windows 2008 r2 specs - @tas50
• Fix to install SQL on any custom directory - @bhavya5491
• Require Chef 12.15+ - @tas50
• Updated checksum for 2008R2 - @kenlangdon

5.5.1 (2019-06-05)

• Example resources should not have backticks but single quotes - @gsreynolds
• Added the ability to override ASSVCACCOUNT in the Configuration File - @jcurcio

5.5.0 (2018-02-10)

• Add property to make .Net 3.5 install optional

5.4.1 (2018-01-10)

• Fix .kitchen.yml file for chef 12.7 testing
• Fix typo with sysadmins property
• Fix feature_list property in ConfigurationFile.ini

5.4.0 (2018-01-03)

• Add install custom resource that installs the specified version of SQL Server
• Add configure custom resource that configures SQL ports and services
• Bump minimum chef version to 12.7
• Update readme to support new resources (#92)
• Add support of SQL 2017 to the resource
• Add support to all features to custom resources
• Recommend wrapper cookbook over backwards compatible recipes
• Update licensing for the new year

5.3.2 (2017-10-14)

• Change default version to 2012 in the readme
• Remove maintainer files and add info to the readme
• Clarifies password in the readme
• Clean up broken link in README

5.3.1 (2017-03-27)

• Update windows cookbook dependency to 3.0.0 due to changes to windows_feature resource. (#89)
• Fix reboot post install logic. (#90)

5.3.0 (2017-03-17)

• Update SQL 2016 Express URL to SP1 and update readme to reflect support for 2016. (#88)

5.2.1 (2017-03-08)

• Add appveyer integration testing of the client recipe and remove Travis CI testing (#86)

5.2.0 (2017-03-07)

• Test with Local Delivery instead of Rake
• Fix failures on Windows 2008r2 by installing NetFx3 if necessary

5.1.2 (2017-01-31)

• Fix issue with Deprecation:Some Attribute Methods (CHEF-4) error

5.1.1 (2017-01-16)

• Only start and enable agent if agent_startup is set to automatic

5.1.0 (2016-12-20)

• Move server configuration in a new sql_server::configure recipe
• Add attributes to control network listeners via registry keys.

5.0.0 (2016-11-22)

• Avoid deprecation warnings with windows_package by using package instead. This requires Chef 12.6+ and Windows cookbook 2.0+
• Adding support for SQL Server Version 2014
• Default to SQL Server 2012
• Move a good chunk of the version logic to helpers instead of doing it in the recipes
• Use secure links to download older SQL express releases
• Add basic sql express 2016 support
• Don’t fail if the SQL version specified is an int and not a string
• Avoid blank lines if the optional configs aren’t passed

4.0.0 (2016-11-18)

• Remove relation between client & server recipes. This was not working correctly. You'll want to include both if you want client packages on your server now.
• Added Filestream Support
• Improved password escaping
• Remove SQL Server 2008 R2 / 2008 R2 SP1. You must now be using 2008 R2 SP2+

3.0.0 (2016-09-07)

• Correct attribute to accept eula
• Require Chef 12+
• Testing updates

v2.6.2(2016-05-17)

• README updates

v2.6.1(2016-05-17)

• PR #69 Duplicate service restart
• Clean up rake file, maintainers toml/markdown

v2.6.0(2016-05-17)

• PR #59 Support Named Instances
• PR #61 Restart Command For SQL Server
• PR #67 Updates for Standard Edition
• PR #68 Clarify remote install note

v2.5.0(2016-02-12)

• Enable multiple sysadmin names.
• Removed the logic that auto generated node['sql_server']['server_sa_password'] and saved it to the node. The user will now need to set this to use the server recipe
• Removed the gem install of tiny_tds. This is not directly used by this cookbook. If you require this for the database cookbook you should install it in your own wrapper cookbook.
• Added support for SQL Server Client 2008 R2 SP2/SP2 and 2012 package installation
• Added the ability to specify the directories for system dbs, user dbs, logs, and tempdb in ConfigurationFile.ini
• Removed assumptions that C: is your system drive
• Added support SQL 2014 server in ConfigurationFile.ini
• Added the ability to pass account passwords to the installer vs. placing them in ConfigurationFile.ini
• Added ability to configure tempdb path, sqlbackupdir path, and sqlcollation in ConfigurationFile.ini
• Fixed computation of the reg_version and service_name variables
• Clarified the system and chef requirements in the readme
• Removed the Berksfile.lock
• Added Test Kitchen config with client and server suite
• Added updated contributing and testing docs
• Added Travis config
• Added Rakefile for simplified testing
• Added Rubocop config and resolved all warnings
• Added Gemfile with testing deps
• Added Maintainers files
• Added travis and cookbook version badges to the readme
• Added source_url and issues_url metadata for Supermarket

v2.4.0 (2014-08-13)

• Fixing Checksums
• Changes to attribute interface

v2.2.3 (2014-02-18)

• reverting OpenSSL module namespace change

v2.2.2 (2014-02-17)

• updating to use the latest openssl

v2.2.0 (2014-03-27)

• [COOK-4355] - Fix support for SQL server by using the right registry path

v2.0.0 (2014-02-27)

[COOK-4253] - Make install options configurable

v1.4.4 (2014-02-21)

Improvement

• sql_server does not support installing SQL 2012

v1.4.1 (2014-02-21)

Improvement

• sql_server cookbook uses deprecated windows_registry LWRP

Bug

• sql_server randomly-generated SA password sometimes not strong enough

v1.3.0

Improvement

• Broken SQLExpress download links...

Bug

• SQLEXPRESS on 32 bits systems does not support INSTALLSHAREDWOWDIR
• Mixlib::ShellOut::CommandTimeout: command timed out error

v1.2.2

• See (v1.2.1), made a mistake with DevOdd releases

v1.2.1

Improvement

• Allow setting feature_list

v1.2.0

Bug

• Sql server configuration is incorrect when trying to install non-express version

v1.1.0

• remove unneeded external restart script from sql_server::server recipe

v1.0.4

• bump windows cookbook dependency version to pick up Ruby 1.9 compat fixes

v1.0.2

• win_friendly_path is no longer a module_function
• rename accept_license_terms attribute to accept_eula for consistency with other cookbooks like iis

v1.0.0

• Initial release

Collaborator Number Metric

            
8.0.2 passed this metric

Contributing File Metric

            
8.0.2 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md file

Cookstyle Metric

            
8.0.2 passed this metric

No Binaries Metric

            
8.0.2 passed this metric

Testing File Metric

            
8.0.2 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file

Version Tag Metric

            
8.0.2 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number