cookbook 'sql_server', '= 8.0.1'
sql_server
(65) Versions
8.0.1
-
-
8.0.3
-
8.0.2
-
8.0.1
-
8.0.0
-
7.2.6
-
7.2.5
-
7.2.4
-
7.2.3
-
7.2.2
-
7.2.1
-
7.2.0
-
7.1.13
-
7.1.12
-
7.1.11
-
7.1.10
-
7.1.9
-
7.1.8
-
7.1.7
-
7.1.6
-
7.1.5
-
7.1.4
-
7.1.3
-
7.1.2
-
7.1.1
-
7.1.0
-
7.0.0
-
6.2.3
-
6.2.2
-
6.2.1
-
6.2.0
-
6.1.0
-
6.0.0
-
5.6.0
-
5.5.1
-
5.5.0
-
5.4.1
-
5.4.0
-
5.3.2
-
5.3.1
-
5.3.0
-
5.2.1
-
5.1.2
-
5.1.1
-
5.1.0
-
4.0.0
-
3.0.0
-
2.6.2
-
2.6.1
-
2.6.0
-
2.5.0
-
2.4.0
-
2.2.3
-
2.2.2
-
2.2.0
-
2.0.0
-
1.4.4
-
1.4.1
-
1.3.0
-
1.2.2
-
1.2.1
-
1.2.0
-
1.1.0
-
1.0.4
-
1.0.2
-
1.0.0
Follow122
- 8.0.3
- 8.0.2
- 8.0.1
- 8.0.0
- 7.2.6
- 7.2.5
- 7.2.4
- 7.2.3
- 7.2.2
- 7.2.1
- 7.2.0
- 7.1.13
- 7.1.12
- 7.1.11
- 7.1.10
- 7.1.9
- 7.1.8
- 7.1.7
- 7.1.6
- 7.1.5
- 7.1.4
- 7.1.3
- 7.1.2
- 7.1.1
- 7.1.0
- 7.0.0
- 6.2.3
- 6.2.2
- 6.2.1
- 6.2.0
- 6.1.0
- 6.0.0
- 5.6.0
- 5.5.1
- 5.5.0
- 5.4.1
- 5.4.0
- 5.3.2
- 5.3.1
- 5.3.0
- 5.2.1
- 5.1.2
- 5.1.1
- 5.1.0
- 4.0.0
- 3.0.0
- 2.6.2
- 2.6.1
- 2.6.0
- 2.5.0
- 2.4.0
- 2.2.3
- 2.2.2
- 2.2.0
- 2.0.0
- 1.4.4
- 1.4.1
- 1.3.0
- 1.2.2
- 1.2.1
- 1.2.0
- 1.1.0
- 1.0.4
- 1.0.2
- 1.0.0
Installs/Configures Microsoft SQL Server
cookbook 'sql_server', '= 8.0.1', :supermarket
knife supermarket install sql_server
knife supermarket download sql_server
sql_server Cookbook
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.
Maintainers
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
sous-chefs.org or come chat with us on the Chef Community Slack in
#sous-chefs.
Requirements
Platforms
- 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
- Chef 15.3+
Resources
- [sql_server_install](documentation/sql_server_install.md)
- [sql_server_configure](documentation/sql_server_configure.md)
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.
Contributors
This project exists thanks to all the people who
contribute.
Backers
Thank you to all our backers!
Sponsors
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
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.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 https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md 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 https://github.com/user/repo, and your repo must contain a TESTING.md 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 https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number
8.0.1 passed this 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 https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md 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 https://github.com/user/repo, and your repo must contain a TESTING.md 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 https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number
8.0.1 passed this 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 https://github.com/user/repo, and your repo must contain a TESTING.md 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 https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number
8.0.1 failed this 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 https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number