配置 – 无人参与安装MS SQL Server(2008 | 2012)EXPRESS？

我跟着安装程序一直到安装程序的“准备安装”页面,它显示了它创建的ConfigurationFile.ini的路径.就我而言：

C:Program FilesMicrosoft SQL Server110Setup BootstrapLog&;timestamp>ConfigurationFile.ini

将此文件复制或保存到所需位置,并在关闭安装程序之前复制整个安装目录.如果您正在进行无人值守安装,则每次都不想猜测并复制目录名称.我确实认为无人参与安装需要解压缩的安装目录setup.exe,我没有运气直接尝试使用/ CONFIGURATIONFILE运行SQLEXPRADV_x64_ENU.exe.

配置文件似乎没有指定任何密码(在我的情况下只是SAPWD,因为我在我的示例中启用了混合模式auth),因此需要将其添加到文件中或指定为命令行参数.

您将需要编辑ConfigurationFile.ini以设置Quiet =“True”并注释掉UIMode = Normal,对于无人参与安装,您通常不需要GUI,如果没有这个,它只会启动安装程序并等待用户输入.

;UIMODE="Normal"

; Setup will not display any user interface. 
QUIET="True"

或者,您可以使用/？调用SQLEXPRADV_x64_ENU.exe.获取完整参数列表的参数,以及底部的无人参与示例,用于在不使用配置文件的情况下进行安装,只需手动传递所需选项.它的例子指定了setup.exe,所以我认为以上是关于需要提取的目录.这真的很长,所以我的答案就是这样.这些也是documented here,因此可以手动创建文件.请注意,链接可能包含Express中不可用的选项.

最后,将安装程序和配置文件复制到目标计算机,并对配置文件进行任何所需的修改：

setup.exe /CONFIGURATIONFILE=c:pathtomyConfigurationFile.ini /IAcceptSQLServerLicenseTerms /SAPWD="****************"

值得注意的是/ IAcceptSQLServerLicenseTerms很重要,如果省略它,它会告诉你必须指定它.您可以在.ini中指定它,但我没有对此进行测试. ***代替我的测试SA密码.如果未启用混合模式或将任何PW添加到配置文件,则可能不需要该部分.

验证Express Edition

然后我找到一个很酷的脚本来告诉你SQL Server服务器(和版本)here on technet的版本,因为我不知道如何在安装后真正验证我的版本,因为原来的问题是因为它似乎安装了标准版而不是快递我承认,如果MS下载的Express安装程序最终安装了另一个版本,我会非常惊讶.

这部分当然不是必需的,而是direct link is here.

这是我在我的案例中得到的输出：

---------------------------------------------------------------------------------------------------------
--//Your current Microsoft SQL Server information:
---------------------------------------------------------------------------------------------------------
Product Version:          11.0.2100.60
Product Name:             SQL Server 2012
Product Level:            RTM 
Product Edition:          Express Edition (64-bit)
---------------------------------------------------------------------------------------------------------
Note,if you want to know information about CU,please read this KB below.
KB321185,<https://support.microsoft.com/en-us/kb/321185>
---------------------------------------------------------------------------------------------------------
Support Lifecycle stage: Mainstream Support Phase,however security/non-security updates are not available for
current 2012 baseline. Upgrade to SP2 for security/Non-security updates. For additional information refer to:
https://support.microsoft.com/en-us/lifecycle/search?sort=PN&alpha=SQL%20Server&Filter=FilterNO,and Q6,Q18
in the FAQ section of Support Lifecycle page at: https://support.microsoft.com/en-us/lifecycle#gp/lifePolicy
---------------------------------------------------------------------------------------------------------
Full information:
Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
    Feb 10 2012 19:39:15 
    Copyright (c) Microsoft Corporation
    Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

---------------------------------------------------------------------------------------------------------
--//Recommended updates: 
--### RTM -> QFE or GDR
--### SP  -> QFE or GDR
--### QFE -> QFE
--### GDR -> GDR or QFE
---------------------------------------------------------------------------------------------------------
Install the latest service pack:              SP3,<https://support.microsoft.com/en-us/kb/3072779>

---------------------------------------------------------------------------------------------------------
###### QFE branch updates
---------------------------------------------------------------------------------------------------------
11.0.2376 (SQL Server 2012 RTM QFE) http://support.microsoft.com/en-us/kb/2716441
11.0.3513 (SQL Server 2012 SP1 QFE) https://support.microsoft.com/en-us/kb/3045317
11.0.5613 (SQL Server 2012 SP2 QFE) https://support.microsoft.com/en-us/kb/3045319
---------------------------------------------------------------------------------------------------------
###### GDR branch updates
---------------------------------------------------------------------------------------------------------
11.0.2218 (SQL Server 2012 RTM GDR) https://support.microsoft.com/en-us/kb/2716442
11.0.3153 (SQL Server 2012 SP1 GDR) http://support.microsoft.com/kb/2977326/en-us
11.0.3156 (SQL Server 2012 SP1 GDR) https://support.microsoft.com/en-us/kb/3045318
11.0.5343 (SQL Server 2012 SP2 GDR) https://support.microsoft.com/en-us/kb/3045321
---------------------------------------------------------------------------------------------------------
Note,if you don’t want to upgrade to latest service pack right now,we recommend you install the latest
Cumulative Update CU11 of SQL Server 2012 RTM.
Install the latest Cumulative Update (CU) of RTM: CU11,<https://support.microsoft.com/en-us/kb/2908007>


---------------------------------------------------------------------------------------------------------
--//You can upgrade to any of the following product(s):
---------------------------------------------------------------------------------------------------------
If you want to upgrade to higher edition,please intall service pack.


For additional information about supported version and edition upgrades refer to:
https://technet.microsoft.com/en-us/library/ms143393(v=sql.120).aspx

（编辑：源码网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!