cookbook 'sql_server', '= 7.1.11'
sql_server
(66) Versions
7.1.11
-
-
8.0.4
-
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.4
- 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', '= 7.1.11', :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
Supported Client Versions
- Microsoft SQL Server 2012
Chef
- Chef 13+
Cookbooks
- windows
Resources
sql_server_install
Actions
-
:install
- Installs the version of Microsoft SQL server specified. Default install is SQL 2012 Express.
Properties
-
feature
- An Array of the SQL Instance or Server features that are going to be enabled / installed.- SQL 2012 Available Features list
- Instance Features
-
SQLENGINE
= Database Engine -
REPLICATION
= Replication -
FULLTEXT
= Full-Text and Semantic Extractions for search -
DQ
= Data Quality Services -
AS
= Analysis Services -
RS
= Reporting Services - Native
-
- Shared Features
-
RS_SHP
= Reporting Services - SharePoint -
RS_SHPWFE
= Reporting Services Add-in for SharePoint Products -
DQC
= Data Quality Client -
BIDS
= SQL Server data tools -
CONN
= Client tools connectivity -
IS
= Integration Services -
BC
= Client tools backwards compatibility -
SDK
= Client tools SDK -
BOL
= Documentation components -
SSMS
= Management tools -
SSMS_ADV
= Management tools - Advanced -
DREPLAY_CTLR
= Distributed replay controller -
DREPLAY_CLT
= Distributed replay client -
SNAC_SDK
= SQL client connectivity SDK
-
- SQL 2016 Available Features list
- Instance Features
-
ADVANCEDANALYTICS
= R Services (In-Database) -
POLYBASE
= PolyBase Query Service for External Data Note: This Feature Requires Java Runtime Environment greater than 7 update 51. Only the standalone Polybase-enabled Instance is currently support by this cookbook.
-
- Shared Features
-
SQL_SHARED_MR
= R Server (Standalone) -
MDS
= Master Data Services - REMOVED for standalone install
-
SSMS
= Management tools -
SSMS_ADV
= Management tools - Advanced
-
- SQL 2017 Available Features list
- Instance Features
-
ADVANCEDANALYTICS
= Machine Learning services (In-Database) -
SQL_INST_MPY
= Machine Learning services (In-Database) with Python -
SQL_INST_MR
= Machine Learning services (In-Database) with R
-
- Shared Features
-
SQL_SHARED_AA
= Machine Learning Services (Standalone) -
SQL_SHARED_MR
= Machine Learning services (In-Database) with R -
SQL_SHARED_MPY
= Machine Learning services (In-Database) with Python -
IS
= Integrated Services -
IS_MASTER
- Scale Out Master -
IS_WORKER
- Scale Out Worker
-
version
- Version of SQL to be installed. Valid otpions are2012
,2016
, or2017
. Default is2012
source_url
- Source of the SQL setup.exe install file. Default is built from the helper libraries.package_name
- Package name for the SQL install. If you specify a version this property is not necessary. Default is built from the helper libraries.package_checksum
- Package checksum in SHA256 format for the setup.exe file. Default is built from the helper libraries.sql_reboot
- Determines whether the node will be rebooted after the SQL Server installation. Default setting is truesecurity_mode
- The Autentication mode for SQL. Valid options areWindows Athentication
orMixed Mode Authentication
. Default value isWindows Authentication
sa_password
- The SQL Administrator password whenMixed Mode Authentication
is being used. SQL enforces a strong passwords for this value.sysadmins
- The list of Systems Administrators who can access the SQL Instance. This can either be a String or an Array.agent_account
- The Service Account that will be used to run the SQL Agent Service. Default isNT AUTHORITY\SYSTEM
.agent_startup
- The Agent Service startup type. Valid options areAutomatic
,Manual
,Disabled
, orAutomatic (Delayed Start)
. Default isDisabled
.agent_account_pwd
- Agent Service Account password.sql_account
- Service Account used to run the SQL service. Default isNT AUTHORITY\NETWORK SERVICE
sql_account_pwd
- Service Account password for the SQL service account.browser_startup
- Service startup type for the SQL Browser Service. Valid options areAutomatic
,Manual
,Disabled
, orAutomatic (Delayed Start)
. Default isDisabled
.installer_timeout
- Time out for the SQL installation. Default is1500
accept_eula
- Whether or not to accept the end user license agreement. Default isfalse
Note: For SQL 2016 if this will also accept the license for using R ifADVANCEDANALYTICS
orSQL_SHARED_MR
is listed in the feature property array.product_key
- Product key for not Express or Evaluation versions.update_enabled
- Whether or not to download updates during install. Default is true.update_source
- The Source Location of Windows Update or WSUS. Default isMU
. Example =c:/path/to/update
instance_name
- Name for the instance to be installed. Default isSQLEXPRESS
. For non-express installs that want the default install it should be set toMSSQLSERVER
.install_dir
- Directory SQL binaries will be installed to. Default isC:\Program Files\Microsoft SQL Server
instance_dir
- Directory the Instance will be stored. Default isC:\Program Files\Microsoft SQL Server
sql_data_dir
- Directory for SQL datasql_backup_dir
- Directory for backupssql_instant_file_init
- Enable instant file initialization for SQL Server service account. Default isfalse
sql_user_db_dir
- Directory for the user databasesql_user_db_log_dir
- Directory for the user database logssql_temp_db_dir
- Directory for the temporary databasesql_temp_db_log_dir
- Directory for the temporary database logssql_temp_db_file_count
- Number of TempDB data files. Default is 8 or number of cores, whichever is lower.sql_temp_db_file_size
- Initial size of each TempDB data file in MB. Default is 8.sql_temp_db_file_growth
- Automatic growth increment for each TempDB data file in MB. Default is 64.sql_temp_db_log_file_size
- Initial size of the TempDB log file in MB. Default is 8.sql_temp_db_log_file_growth
- Automatic growth increment for the TempDB log file in MB. Default is 64.filestream_level
- Level to enable the filestream feature, Valid values are 0, 1, 2 or 3. Default is 0filestream_share_name
- Share name for the filestream feature. Default isMSSQLSERVER
sql_collation
- SQL Collation type for the instancenetfx35_install
- If the .Net 3.5 Windows Feature is installed. This is required to successfully install SQL 2012. Default is true.netfx35_source
- Source location for the .Net 3.5 Windows Features install. Only required for offline installs
Distributed Replay
-
dreplay_ctlr_admins
- List of admins for the Distributed Replay Controller. Default isAdministrator
. TheDREPLAY_CTLR
feature needs to be included in the feature Array for this property to work. -
dreplay_client_name
- Host name of the Distributed Replay Controller that the Client will point to. If theDREPLAY_CLT
is in the feature list this property needs to be set.
Reporting Services
-
rs_account
- Service Account name used to run SQL Reporting Services. To have reporting services it needs to be listed in thefeature
property array. -
rs_account_pwd
- Service Account password for the Reporting Services Service -
rs_startup
- Reporting Services service startup type. Valid options areAutomatic
,Manual
,Disabled
, orAutomatic (Delayed Start)
. Default isAutomatic
. -
rs_mode
- Mode the Reporting Services is installed in. Default isFilesOnlyMode
Analysis Services
-
as_sysadmins
- Analysis Services Systems Administrator list. Default isAdministrator
-
as_svc_account
- Service Account used by Analysis Services. Default isNT Service\MSSQLServerOLAPService
PolyBase Query Services
-
polybase_port_range
- Port Range for the PolyBase Query Service. Default is16450-16460
.
Integrated Services
-
is_master_port
- Port for the Integrated Services Scale out Master. Default is 8391. -
is_master_ssl_cert
- The CNs in the certificate used to protect communications between the integration services scale out worker and scale out master. -
is_master_cert_thumbprint
- The certificate thumbprint for the scale out master ssl certificate. -
is_worker_master_url
- The url of the scale out master when installing a scale out worker.
Examples
Install SQL 2012 Express with all the defaults
sql_server_install 'Install SQL 2012 Express'
Install SQL 2016 Express
sql_server_install 'Install SQL 2016 Express' do version '2016' end
Install SQL 2012 Evaluation from a local source with default instance name, Integrated Services, Reporting Services, and the SQL Management Tools.
sql_server_install 'Install SQL Server 2012 Evaluation' do source_url 'C:\\Sources\\SQL 2012 Eval\\setup.exe' version '2012' package_checksum '0FE903...420E8F' accept_eula true instance_name 'MSSQLSERVER' feature %w(SQLENGINE IS RS SSMS ADV_SSMS) end
sql_server_configure
Actions
-
:service
- Configures the ports that SQL be listening on and starts and enables the SQL Service.
Properties
-
version
- SQL Version of the instance to be configured. Valid otpions are2012
,2016
,2017
or2019
. Default is2012
-
tcp_enabled
- If TCP is enabled for the instance. Default is true -
sql_port
- Port SQL will listen on. Default is 1433 -
tcp_dynamic_ports
- Sets the Dynamic port SQL will listen on. Default is an empty string -
np_enabled
- Whether named pipes is enabled. Default is false -
sm_enabled
- Whether shared memory is enabled for the instance -
via_default_port
- Configures the Virtual Interface Adapter default port. Default is0:1433
-
via_enabled
- Whether Virtual Interface Adapter is enabled. Default is false -
via_listen_info
- Configures the Virtual interface listening information. Default is0:1433
-
agent_startup
- Configures the SQL Agent Service startup type. Valid options areAutomatic
,Manual
,Disabled
, orAutomatic (Delayed Start)
. Default isDisabled
Examples
Configure a SQL 2012 Express install with all the defaults
sql_server_configure 'SQLEXPRESS'
Configure a SQL 2016 Express install
sql_server_configure 'SQLEXPRESS' do version '2016' end
Configure a SQL 2019 Express install
sql_server_configure 'SQLEXPRESS' do version '2019' end
Configure a SQL 2012 Evaluation install with a different port
sql_server_configure 'MSSQLSERVER' do version '2012' sql_port '1434' end
Attributes
default
The following attributes are used by both client and server recipes.
-
node['sql_server']['accept_eula']
- indicate that you accept the terms of the end user license, default is 'false' -
node['sql_server']['product_key']
- Specifies the product key for the edition of SQL Server, default isnil
(not needed for SQL Server Express installs)
client
This file also contains download url, checksum and package name for all client installation packages. See the Usage section below for more details.
server
-
node['sql_server']['install_dir']
- main directory for installation, default isC:\Program Files\Microsoft SQL Server
-
node['sql_server']['instance_name']
- name of the default instance, default isSQLEXPRESS
-
node['sql_server']['instance_dir']
- root directory of the default instance, default isC:\Program Files\Microsoft SQL Server
-
node['sql_server']['shared_wow_dir']
- root directory of the shared WOW directory, default isC:\Program Files (x86)\Microsoft SQL Server
-
node['sql_server']['agent_account']
- Agent account name, default isNT AUTHORITY\NETWORK SERVICE
-
node['sql_server']['agent_startup']
- Agent service startup mode, default isDisabled
-
node['sql_server']['rs_mode']
- Reporting Services install mode, default isFilesOnlyMode
-
node['sql_server']['rs_account']
- Reporting Services account name, default isNT AUTHORITY\NETWORK SERVICE
-
node['sql_server']['rs_startup']
- Reporting Services startup mode, default isAutomatic
-
node['sql_server']['browser_startup']
- Browser Service startup mode, default isDisabled
-
node['sql_server']['sysadmins']
- Windows accounts that are SQL administrators, default isAdministrator
-
node['sql_server']['sql_account']
- SQL service account name, default isNT AUTHORITY\NETWORK SERVICE
This file also contains download url, checksum and package name for the server installation package.
configure
-
node['sql_server']['tcp_enabled']
- Enables TCP listener, default istrue
-
node['sql_server']['port']
- Static TCP port server should listen on for client connections, default is1433
-
node['sql_server']['tcp_dynamic_ports']
- Dynamic TCP ports server should listen on for client connections, default is''
-
node['sql_server']['np_enabled']
- Enables Named pipes listener, default isfalse
-
node['sql_server']['sm_enabled']
- Enables Shared Memory listener, default istrue
-
node['sql_server']['via_default_port']
- VIA default listener port, default is0:1433
-
node['sql_server']['via_enabled']
- Enables VIA listener, default isfalse
-
node['sql_server']['via_listen_info']
- VIA listener info, default is0:1433
Recipe Usage
We highly recommend writing your own wrapper cookbook utilizing the above resources, but this cookbook also ships with legacy recipes that can be used to install sql_server using recipes/attributes.
default
Includes the sql_server::client
recipe.
client
Installs required the SQL Server Native Client and all required dependencies. The SQL Server Native Client contains the SQL Server ODBC driver and the SQL Server OLE DB provider in one native dynamic link library (DLL) supporting applications using native-code APIs (ODBC, OLE DB and ADO) to Microsoft SQL Server. In simple terms these packages should allow any other node to act as a client of a SQL Server instance.
configure
Configures SQL Server registry keys via attributes, and restart the Engine service if required.
Current supported settings are mostly connection listeners:
- TCP or VIA listener ports
- TCP, Named Pipes, Shared Memory or VIA listener activation.
NOTE: It could be very dangerous to change these settings on a production server!
This recipe is included by the sql_server::server
recipe, but can be included independently if you setup SQL Server by yourself.
server
Installs SQL Server 2012 Express, SQL Server 2016 Express, or SQL Server 2019 Express.
By default, the cookbook installs SQL Server 2012 Express. There are two options to install a different version.
NOTE: For this recipe to run you must set the following attributes in an environment, role, or wrapper cookbook.
node['sql_server']['agent_account_pwd'] node['sql_server']['rs_account_pwd'] node['sql_server']['sql_account_pwd']
NOTE: This recipe will request a reboot at the end of the Chef Client run if SQL Server was installed.. If you do not want to reboot after the installation, use the reboot
resource to cancel the pending reboot.
Option 1: From a role, environment, or wrapper cookbook, set node['sql_server']['version']
to '2012' to install SQL Server 2012 Express, or '2016' to install SQL Server 2016 Express.
Option 2: From a role, environment, or wrapper cookbook, set these node attributes to specify the URL, checksum, and name of the package (as it appears in the Windows Registry).
node['sql_server']['server']['url']
node['sql_server']['server']['checksum']
node['sql_server']['server']['package_name']
The installation is done using the package
resource and ConfigurationFile generated from a template
resource. The installation is slightly opinionated and does the following:
- Enables Mixed Mode (Windows Authentication and SQL Server Authentication) authentication
- sets a static TCP port which is configurable via an attribute, using the
sql_server::configure
recipe.
Installing any of the SQL Server server or client packages in an unattended/automated way requires you to explicitly indicate that you accept the terms of the end user license. The hooks have been added to all recipes to do this via an attribute. Create a role to set the node['sql_server']['accept_eula']
attribute to 'true'. For example:
name "sql_server" description "SQL Server database master" run_list( "recipe[sql_server::server]" ) default_attributes( "sql_server" => { "accept_eula" => true } )
Out of the box this recipe installs the Express edition of SQL Server 2012. If you would like to install the Standard edition create a role as follows:
name "sql_server_standard" description "SQL Server Stadard edition database master" run_list( "recipe[sql_server::server]" ) default_attributes( "sql_server" => { "instance_name" => "MSSQLSERVER", "product_key" => "YOUR_PRODUCT_KEY_HERE", "accept_eula" => true, "server" => { "url" => "DOWNLOAD_LOCATION_OF_INSTALLATION_PACKAGE", "checksum" => "SHA256_OF_INSTALLATION_PACKAGE" } } )
Depending on your base Windows installation you may also need to open the configured static port in the Windows Firewall. In the name of security we do not do this by default but the follow code should get the job done:
# unlock port in firewall # this should leverage firewall_rule resource # once COOK-689 is completed firewall_rule_name = "#{node['sql_server']['instance_name']} Static Port" execute "open-static-port" do command "netsh advfirewall firewall add rule name=\"#{firewall_rule_name}\" dir=in action=allow protocol=TCP localport=#{node['sql_server']['port']}" returns [0,1,42] # *sigh* cmd.exe return codes are wonky not_if { SqlServer::Helper.firewall_rule_enabled?(firewall_rule_name) } end
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.
Learn more in this Learn Chef tutorial.
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.
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
- COOK-4268 - sql_server does not support installing SQL 2012
v1.4.1 (2014-02-21)
Improvement
- COOK-3892 - sql_server cookbook uses deprecated windows_registry LWRP
Bug
- COOK-3725 - sql_server randomly-generated SA password sometimes not strong enough
v1.3.0
Improvement
- COOK-3507 - Broken SQLExpress download links...
Bug
- COOK-3506 - SQLEXPRESS on 32 bits systems does not support INSTALLSHAREDWOWDIR
- COOK-3388 - Mixlib::ShellOut::CommandTimeout: command timed out error
v1.2.2
- See (v1.2.1), made a mistake with DevOdd releases
v1.2.1
Improvement
- COOK-3088 - Allow setting feature_list
v1.2.0
Bug
- [COOK-3085]: Sql server configuration is incorrect when trying to install non-express version
v1.1.0
- [COOK-1049] - 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
- [COOK-773] 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
- [COOK-681] initial release
Collaborator Number Metric
7.1.11 passed this metric
Contributing File Metric
7.1.11 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
7.1.11 passed this metric
No Binaries Metric
7.1.11 passed this metric
Testing File Metric
7.1.11 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
7.1.11 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
7.1.11 passed this metric
7.1.11 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
7.1.11 passed this metric
No Binaries Metric
7.1.11 passed this metric
Testing File Metric
7.1.11 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
7.1.11 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
7.1.11 passed this metric
7.1.11 passed this metric
Testing File Metric
7.1.11 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
7.1.11 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
7.1.11 failed this metric
7.1.11 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