cookbook 'sql_server', '= 1.0.0'
sql_server
(66) Versions
1.0.0
-
-
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', '= 1.0.0', :supermarket
knife supermarket install sql_server
knife supermarket download sql_server
Description
Installs and configures Microsoft SQL Server 2008 R2 server and client. By default the Express edition is installed, but the sql_server::server
recipe supports installation of other editions (see Usage below).
Requirements
Platform
Tested on
- Windows Server 2008 R2
May work on other versions of Windows.
Attributes
default
The following attributes are used by both client and server recipes.
-
node['sql_server']['accept_license_terms']
- 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 2008 R2 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']['port']
- static TCP port server should listen on for client connections, default is1433
-
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
This file also contains download url, checksum and package name for the server installation package.
Usage
default
Includes the sql_server::client
recipe.
client
Installs required the SQL Server Native Client and all required dependancies. These include:
- Microsoft SQL Server 2008 R2 Native Client
- Microsoft SQL Server 2008 R2 Command Line Utilities (ie
sqlcmd
) - Microsoft SQL Server System CLR Types
- Microsoft SQL Server 2008 R2 Management Objects
- Windows PowerShell Extensions for SQL Server 2008 R2
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.
The TinyTDS gem is also installed as this is used in the SQL Server providers for the database
and database_user
resources (see the database
cookbook for more details).
server
Installs SQL Server 2008 R2 Express. The installation is done using the windows_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
- Auto-generates and sets a strong password for the 'sa' account
- sets a static TCP port which is configurable via an attribute.
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_license_terms']
attribute to 'true'. For example:
% cat roles/sql_server.rb
name "sql_server"
description "SQL Server database master"
run_list(
"recipe[sql_server::server]"
)
default_attributes(
"sql_server" => {
"accept_license_terms" => true
}
)
Out of the box this recipe installs the Express edition of SQL Server 2008 R2. If you would like to install the Standard edition create a role as follows:
% cat roles/sql_server.rb
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_license_terms" => 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] # *sigh* cmd.exe return codes are wonky
not_if { SqlServer::Helper.firewall_rule_enabled?(firewall_rule_name) }
end
Changes/Roadmap
Future
- license distribution and management
- multi instance support (via an LWRP)
- clustering support
1.0.0:
- [COOK-681] initial release
License and Author
Author:: Seth Chisamore (schisamo@opscode.com)
Copyright:: 2011, Opscode, Inc.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
Dependent cookbooks
openssl >= 0.0.0 |
windows >= 1.0.6 |
Contingent cookbooks
There are no cookbooks that are contingent upon this one.