Adoptable Cookbooks List

Looking for a cookbook to adopt? You can now see a list of cookbooks available for adoption!
List of Adoptable Cookbooks

Supermarket Belongs to the Community

Supermarket belongs to the community. While Chef has the responsibility to keep it running and be stewards of its functionality, what it does and how it works is driven by the community. The chef/supermarket repository will continue to be where development of the Supermarket application takes place. Come be part of shaping the direction of Supermarket by opening issues and pull requests or by joining us on the Chef Mailing List.

Select Badges

Select Supported Platforms

Select Status


sql_server (65) Versions 8.0.1

Installs/Configures Microsoft SQL Server

cookbook 'sql_server', '= 8.0.1', :supermarket
cookbook 'sql_server', '= 8.0.1'
knife supermarket install sql_server
knife supermarket download sql_server
Quality 50%

sql_server Cookbook

Cookbook Version

Provides resources for the installation and configuration of Microsoft SQL Server server and client. Includes several basic recipes that utilize install and configure resources. See the usage section below for more information.


This cookbook is maintained by the Sous Chefs. The Sous Chefs are a community of Chef cookbook maintainers working
together to maintain important cookbooks. If you’d like to know more please visit or come chat with us on the Chef Community Slack in



  • Windows Server 2012 (R1, R2)
  • Windows Server 2016
  • Windows Server 2019

Supported Server Verions

  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2017
  • Microsoft SQL Server 2019
  • Microsoft SQL Server 2022

Supported Client Versions

  • Microsoft SQL Server 2012


  • Chef 15.3+


  • [sql_server_install](documentation/
  • [sql_server_configure](documentation/

Installing SQL Server remotely

SQL Server does not support remote installation over WinRM. For example, the installation fails when you run knife bootstrap windows winrm or knife winrm 'chef-client' with a run-list that includes server.rb. However, you can use a scheduled task or run chef-client as a service.


This project exists thanks to all the people who


Thank you to all our backers!


Support this project by becoming a sponsor. Your logo will show up here with a link to your website.

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.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


  • README updates


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


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


  • 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)


  • sql_server does not support installing SQL 2012

v1.4.1 (2014-02-21)


  • sql_server cookbook uses deprecated windows_registry LWRP


  • sql_server randomly-generated SA password sometimes not strong enough



  • Broken SQLExpress download links...


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


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



  • Allow setting feature_list



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


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


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


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


  • Initial release

Collaborator Number Metric

8.0.1 passed this metric

Contributing File Metric

8.0.1 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, and your repo must contain a file

Cookstyle Metric

8.0.1 passed this metric

No Binaries Metric

8.0.1 passed this metric

Testing File Metric

8.0.1 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, and your repo must contain a file

Version Tag Metric

8.0.1 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, and your repo must include a tag that matches this cookbook version number