使用Chef社区食谱（sql_server）安装SQL Server 2014 [英] Installing SQL Server 2014 using chef community cookbook (sql_server)

问题描述

我看过有关安装sql server的Chef社区食谱，看来它是为安装SQL Express而量身定制的，但是我似乎无法弄清楚如何安装标准版或开发人员版。

I've had a look at the chef community cookbook for installing sql server and it appears that it's tailored for installing SQL express, but I can't seem to work out how to install a standard or developer edition.

GitHub页面上的自述文件（ https：/ /github.com/chef-cookbooks/sql_server ）表示您可以将其指向任何安装包，但是我看不到如何对ISO（甚至是ISO的提取内容）进行安装

The README on the GitHub page (https://github.com/chef-cookbooks/sql_server) says you can just point it to any installation package, however I can't see how you would do this for an ISO (or even the extracted contents of an ISO) given that there's no single EXE package on the ISO media.

我遗漏了一些明显的东西，或者我需要滚动自己的食谱来从ISO安装SQL（或ISO的内容）？理想情况下，我希望将安装媒体托管在防火墙后面的中央软件包存储库中。

Am I missing something obvious, or will I need to roll my own recipe for installing SQL from an ISO (or contents of ISO)? Ideally I would like to host the installation media on a central package repository behind my firewall.

推荐答案

选项1：

自定义菜谱是您使用案例的最佳选择。就像您说的那样，将.ISO托管在中央存储库上，并创建一个挂载.ISO驱动器的菜谱以运行安装。您应该利用该菜谱模板并在 server.rb 中重写该 windows_package 块，以使用关键字 源'，其中包含安装的安装文件的路径。但是，这将是一项重大的工作（根据过去的经验...），因此，如果只有一个或两个节点需要运行该菜谱，请使用选项2。

Customized cookbook is the best option for you use case. Like you said, host .ISO on central repo and create a cookbook that mounts the .ISO drive to run the installation. You should leverage that cookbook template and re-write that windows_package block in the server.rb to install using keyword 'source' with path to the mounted installation files. However, this will be a major work (from past experience...) so if you have only one or two nodes that need to run the cookbook, go with Option 2.

选项2：

如果您只有一个或两个需要运行菜谱的节点，建议您运行基本的' sql_server :: server ，然后使用带有PID产品密钥的GUI升级到所需的版本。

If you have only one or two nodes that need to run the cookbook, I would suggest you to run the basic 'sql_server::server' then upgrade to the version you want using the GUI with the PID product key.

请注意，使用Powershell脚本也可以自动执行此过程。如果您熟悉Powershell，则可以使用 powershell_script 块将其自动化。

Note that this process can be automated as well using Powershell script. If you are familiar with Powershell, you can automate it using powershell_script block.

这篇关于使用Chef社区食谱（sql_server）安装SQL Server 2014的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！