加入收藏 | 设为首页 | 会员中心 | 我要投稿 湖南网 (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中的红

我随着安装措施一向到安装措施的“筹备安装”页面,它表现了它建设的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

(编辑:湖南网)

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

热点阅读