我的目标是安装MS sql Server 2012 R2 Express.
我已下载sqlEXPRADV_x64_ENU.exe并使用/ ACTION = Install / UIMODE = Normal来生成和修改配置文件.无论我如何摆弄配置,它都会安装标准版的“默认”或“命名”实例,虽然我没有指定许可证(忽略this image中的红色箭头,我选择其他选项) ).
是什么赋予了？为了安装Express版本,我需要提供或更改哪个设置？
更新：我被告知我可能有错误的安装程序版本. (他们很高兴为所有版本命名相同.)我正在再次下载,不确定它是否不是我已经拥有的(如果我右键单击并选择“属性”,则告诉我它是“Microsoft sql Server” 2012年高级版“).
我知道在哪里下载Microsoft SQL Server 2008 R2 Express,我知道在哪里下载Microsoft SQL Server 2012 Express,但在世界上哪里是Microsoft sql Server 2012 R2 Express？客户希望使用“MS sql Server R2 with Advanced Tools”,无论是2008年还是2012年(最终甚至是2014年).
;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,DQC,Tools,SNAC_SDK ;FEATURES=sqlENGINE,REPLICATION,FULLTEXT,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,而不是“评估” – 我认为评估显示完全表明您已获得标准(或其他)版本安装程序.
验证安装程序的快速方法是使用不同的文件来比较哈希值.我在这个文件上得到的sha1哈希是E1F8DEC35422A67E6733E53ED260CCE538E97EDC. FCIV或Get-FileHash(PowerShell 4.0？)是Windows上的两个示例.
仅此一点并不是一个答案,所以我已经完成了无人值守的安装.首先,我像你一样创建了一个ConfigurationFile.ini.
无人值守安装
sqlEXPRADV_x64_ENU.exe /ACTION=Install /UIMode=Normal
我跟着安装程序一直到安装程序的“准备安装”页面,它显示了它创建的ConfigurationFile.ini的路径.就我而言：
C:\Program Files\Microsoft sql Server\110\Setup Bootstrap\Log\<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:\path\to\myConfigurationFile.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
