无人参与安装MS SQL Server（2008 | 2012）EXPRESS？

我的目标是安装MS SQL Server 2012 R2 Express。

我已经下载了SQLEXPRADV_x64_ENU.exe并使用/ACTION=Install /UIMODE=Normal来生成和修改configuration文件。不pipe我如何摆弄configuration，它将安装标准版的“默认”或“已命名”实例，虽然我没有指定许可证（忽略此图中的红色箭头，我正在select其他选项）。

是什么赋予了？我需要提供或更改哪个设置才能安装Express版本？

更新：我被告知我可能有错误版本的安装程序。（辉煌的命名所有版本相同。）我目前正在下载，不确定是否不是我已经有（如果我右键单击并select“属性”，告诉我这是一个“Microsoft SQL Server 2012快速高级版“）。

我知道在哪里下载Microsoft SQL Server 2008 R2 Express ，而且我知道在哪里下载Microsoft SQL Server 2012 Express ，但是世界上哪里是Microsoft SQL Server 2012 R2 Express ？客户希望在2008年或2012年（甚至到2014年）使用“MS SQL Server R2和高级工具”。

既然你很可能会问这个，我在这里包括我的完整的configuration文件：

 ;SQL Server 2012 Configuration File ; DEVELOPER'S NOTE ; This file was obtained from the installer using the switches "/ACTION=Install /UIMODE=Normal" which yields the FULL set of wizard pages AND the ability to save a new configuration file. ; See also: https://technet.microsoft.com/en-us/library/ms144259%28v=sql.110%29.aspx ; Values that need to be changed before use: ;INSTANCENAME="{INSTANCENAME}" ;INSTANCEID="{INSTANCEID}" ;SQLSVCACCOUNT="NT Service\MSSQL${INSTANCENAME}" ;SQLSVCPASSWORD="{SQLSVCPASSWORD}" ;SQLSYSADMINACCOUNTS="{HOSTNAME}\Administrator" ;SAPWD="{SAPWD}" ;RSSVCACCOUNT="NT Service\ReportServer${INSTANCENAME}" ;FTSVCACCOUNT="NT Service\MSSQLFDLauncher${INSTANCENAME}" ;QUIETSIMPLE="True" -- I recommend you pass "/QS" to the installer rather than editing this value [OPTIONS] ; Required to acknowledge acceptance of the license terms. IACCEPTSQLSERVERLICENSETERMS="True" ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter. ACTION="Install" ; Detailed help for command line argument ROLE has not been defined yet. ;ROLE="AllFeatures_WithDefaults" ; Detailed help for command line argument ENU has not been defined yet. ENU="True" ; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,AutoAdvance for a simplied UI, and EnableUIOnServerCore for bypassing Server Core setup GUI block. ;UIMODE="Normal" ; Setup will not display any user interface. ;QUIET="False" ; Setup will display progress only, without any user interaction. QUIETSIMPLE="False" ; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found. UpdateEnabled="False" ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality Services (DQS) server. The Tools feature will install Management Tools, Books online components, SQL Server Data Tools, and other shared components. FEATURES=SQL,AS,RS,DQC,IS,MDS,Tools,SNAC_SDK ;FEATURES=SQLENGINE,REPLICATION,FULLTEXT,RS,BIDS,BOL,SSMS,SNAC_SDK ; Specify the location where SQL Server Setup will obtain product updates. The valid values are "MU" to search Microsoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default SQL Server Setup will search Microsoft Update or a Windows Update service through the Window Server Update Services. UpdateSource="MU" ; Displays the command line parameters usage HELP="False" ; Specifies that the detailed Setup log should be piped to the console. INDICATEPROGRESS="True" ; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system. X86="False" ; Specify the root installation directory for shared components. This directory remains unchanged after shared components are already installed. INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" ; Specify the root installation directory for the WOW64 shared components. This directory remains unchanged after WOW64 shared components are already installed. INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server" ; Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and SQLExpress for Express editions. This parameter is required when installing the SQL Server Database Engine (SQL), Analysis Services (AS), or Reporting Services (RS). INSTANCENAME="{INSTANCENAME}" ; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will incorporate the instance ID of the SQL Server instance. INSTANCEID="{INSTANCEID}" ; Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to enable and 0 or False to disable this feature. SQMREPORTING="False" ; RSInputSettings_RSInstallMode_Description RSINSTALLMODE="DefaultNativeMode" ; Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to enable and 0 or False to disable this feature. ERRORREPORTING="False" ; Specify the installation directory. INSTANCEDIR="C:\Program Files\Microsoft SQL Server" ; Agent account name AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" ; Auto-start service after installation. AGTSVCSTARTUPTYPE="Automatic" ; CM brick TCP communication port COMMFABRICPORT="0" ; How matrix will use private networks COMMFABRICNETWORKLEVEL="0" ; How inter brick communication will be protected COMMFABRICENCRYPTION="0" ; TCP port used by the CM brick MATRIXCMBRICKCOMMPORT="0" ; Startup type for the SQL Server service. SQLSVCSTARTUPTYPE="Automatic" ; Level to enable FILESTREAM feature at (0, 1, 2 or 3). FILESTREAMLEVEL="0" ; Set to "1" to enable RANU for SQL Server Express. ENABLERANU="True" ; Specifies a Windows collation or an SQL collation to use for the Database Engine. SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" ; Account for SQL Server service: Domain\User or system account. SQLSVCACCOUNT="NT Service\MSSQL${INSTANCENAME}" SQLSVCPASSWORD="{SQLSVCPASSWORD}" ; Windows account(s) to provision as SQL Server system administrators. SQLSYSADMINACCOUNTS="{HOSTNAME}\Administrator" ; The default is Windows Authentication. Use "SQL" for Mixed Mode Authentication. SECURITYMODE="SQL" SAPWD="{SAPWD}" ; Provision current user as a Database Engine system administrator for SQL Server 2012 Express. ADDCURRENTUSERASSQLADMIN="True" ; Specify 0 to disable or 1 to enable the TCP/IP protocol. TCPENABLED="1" ; Specify 0 to disable or 1 to enable the Named Pipes protocol. NPENABLED="1" ; Startup type for Browser Service. BROWSERSVCSTARTUPTYPE="Disabled" ; Specifies which account the report server NT service should execute under. RSSVCACCOUNT="NT Service\ReportServer${INSTANCENAME}" ; Specifies how the startup mode of the report server NT service. RSSVCSTARTUPTYPE="Automatic" ; Add description of input argument FTSVCACCOUNT FTSVCACCOUNT="NT Service\MSSQLFDLauncher${INSTANCENAME}"

错误的安装程序？

我认为这将是错误的安装程序。我从你提到的链接下载了SQL Server 2012 Express高级版安装程序，并能够广泛地遵循你的步骤，但我看到了一个显着的差异。

我的产品密钥屏幕不同于您的屏幕截图。我只列出下拉菜单中的Express，而不是“评估” – 我认为显示的评估表明您已经有了标准（或其他）版本的安装程序。我的sql server 2012 express上的产品密钥配置截图

validation安装程序的一种快速方法是使用不同的文件来比较哈希。我在这个文件上得到的sha1散列是E1F8DEC35422A67E6733E53ED260CCE538E97EDC。 FCIV或Get-FileHash（PowerShell 4.0？）是Windows上的两个示例。

尽pipe如此，我还是没有太多的答案，所以我已经完成了一个完整的无人值守的安装。首先，我创build了一个ConfigurationFile.ini，就像你一样。

无人参与安装

 SQLEXPRADV_x64_ENU.exe /ACTION=Install /UIMode=Normal

我跟着安装程序一直到安装程序的“准备安装”页面，该页面显示了它创build的ConfigurationFile.ini的path。在我的情况下：

 C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\<timestamp>\ConfigurationFile.ini

在closures安装程序之前，将该文件复制或保存到需要的位置，同时复制整个安装目录。如果您正在进行无人参与的安装，则不会每次猜测并复制目录名称。我认为解压缩安装dir + setup.exe是无人参与安装需要的，我没有运气试图直接运行/ CONFIGURATIONFILE SQLEXPRADV_x64_ENU.exe。

configuration文件似乎没有指定任何密码（在我的例子中，只是SAPWD，因为我在我的例子中启用了混合模式身份validation），所以要么以后需要添加到文件中，要么指定为命令行参数。

你将要编辑你的ConfigurationFile.ini来设置Quiet =“True”，并注释掉UIMode = Normal，因为无人看pipe的安装你通常不需要一个GUI，如果没有这个，它只会启动安装程序并等待用户input。

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

或者，可以使用/？调用SQLEXPRADV_x64_ENU.exe。参数来获取完整的参数列表，以及底部的无人参与示例，可以在不使用configuration文件的情况下进行安装，只需手动传递所需的选项即可。它的例子指定了setup.exe，所以我认为上述需要提取的目录。这真的很长，所以我没有把答案保留下来。这些也logging在这里，所以文件可以手动创build。请注意，该链接可能有快捷方式中不可用的选项。

最后，将安装程序和configuration文件复制到目标机器，并对configuration文件进行任何所需的修改：

 setup.exe /CONFIGURATIONFILE=c:\path\to\myConfigurationFile.ini /IAcceptSQLServerLicenseTerms /SAPWD="****************"

值得注意的是/ IAcceptSQLServerLicenseTerms是重要的，如果你省略它，它会告诉你它必须被指定。你可以在.ini中指定它，但是我没有testing。 ***代替我的testingSA密码。如果您不启用混合模式或者将任何PW添加到configuration文件，那么可能不需要该部分。

validationExpress Edition

然后，我发现一个很酷的脚本告诉你在SQL Server服务器（和版本）的版本，因为我不知道如何真正validation我的版本安装后，鉴于原来的问题是由于它出现安装标准版本而不是Express。我承认，如果从MS下载的Express安装程序最终安装另一个版本，我会感到非常惊讶。

这部分当然没有必要，但直接的联系在这里。

这里是我得到的输出：

 --------------------------------------------------------------------------------------------------------- --//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