加入收藏 | 设为首页 | 会员中心 | 我要投稿 湖南网 (https://www.hunanwang.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 编程 > 正文

设置 – 无人参加安装MS SQL Server(2008 | 2012)EXPRESS?

发布时间:2020-12-24 20:42:44 所属栏目:编程 来源:网络整理
导读:我的方针是安装MS SQL Server 2012 R2 Express. 我已下载SQLEXPRADV_x64_ENU.exe并行使/ ACTION = Install / UIMODE = Normal来天生和修改设置文件.无论我怎样摆弄设置,它城市安装尺度版的“默认”或“定名”实例,固然我没有指定容许证(忽略this image中的红
副问题[/!--empirenews.page--]

我的方针是安装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 ServiceMSSQL${INSTANCENAME}"
;SQLSVCPASSWORD="{SQLSVCPASSWORD}"
;SQLSYSADMINACCOUNTS="{HOSTNAME}Administrator"
;SAPWD="{SAPWD}"
;RSSVCACCOUNT="NT ServiceReportServer${INSTANCENAME}"
;FTSVCACCOUNT="NT ServiceMSSQLFDLauncher${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 FilesMicrosoft 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 FilesMicrosoft SQL Server"
; Agent account name
AGTSVCACCOUNT="NT AUTHORITYNETWORK 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: DomainUser or system account.
SQLSVCACCOUNT="NT ServiceMSSQL${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 ServiceReportServer${INSTANCENAME}"
; Specifies how the startup mode of the report server NT service.
RSSVCSTARTUPTYPE="Automatic"
; Add description of input argument FTSVCACCOUNT
FTSVCACCOUNT="NT ServiceMSSQLFDLauncher${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

(编辑:湖南网)

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

热点阅读