在 Server Core 上安裝 SQL Server 2014Install SQL Server 2014 on Server Core

您可以在 [SQL Server]SQL Server SP1 或 Windows Server 2008 R2Windows Server 2008 R2 的 Server Core 安裝上安裝 Windows Server 2012Windows Server 2012You can install [SQL Server]SQL Server on a Server Core installation of Windows Server 2008 R2Windows Server 2008 R2 SP1 or Windows Server 2012Windows Server 2012. 本主題提供在 Server Core 上安裝 SQL Server 2014SQL Server 2014 的安裝程式特定詳細資料。This topic provides setup-specific details for installing SQL Server 2014SQL Server 2014 on Server Core.

Windows Server 2008 R2Windows Server 2008 R2Windows Server 2012Windows Server 2012 作業系統的 Server Core 安裝選項提供執行特定伺服器角色的基本環境,The Server Core installation option for the Windows Server 2008 R2Windows Server 2008 R2 or Windows Server 2012Windows Server 2012 operating system provides a minimal environment for running specific server roles. 可協助降低這些伺服器角色的維護和管理需求,以及減少其攻擊面。This helps to reduce maintenance and management requirements and the attack surface for those server roles. 如需有關上實作之 Server Core Windows Server 2008 R2Windows Server 2008 R2,請參閱 < Server Core for Windows Server 2008 R2 (https://go.microsoft.com/fwlink/?LinkId=202439) 。For more information on Server Core as implemented on Windows Server 2008 R2Windows Server 2008 R2, see Server Core for Windows Server 2008 R2 (https://go.microsoft.com/fwlink/?LinkId=202439). 如需在 Windows Server 2012Windows Server 2012 上實作之 Server Core 的詳細資訊,請參閱 Server Core for Windows Server 2012 (https://msdn.microsoft.com/library/hh846323(VS.85).aspx) 。For more information on Server Core as implemented on Windows Server 2012Windows Server 2012, see Server Core for Windows Server 2012 (https://msdn.microsoft.com/library/hh846323(VS.85).aspx).

先決條件Prerequisites

需求Requirement 安裝方式How to install
.NET Framework.NET Framework 2.0 SP22.0 SP2 包含在 Windows Server 2008 R2Windows Server 2008 R2 SP1 和 Windows Server 2012Windows Server 2012的 Server Core 安裝中。Included in Server Core installation of Windows Server 2008 R2Windows Server 2008 R2 SP1 and Windows Server 2012Windows Server 2012. 如果未啟用,安裝程式預設會予以啟用。If it is not enabled, Setup enables it by default.

2.0、3.0 和 3.5 無法在同一部電腦上並行執行。It is not possible to run versions 2.0, 3.0, and 3.5 side by side on a computer. 當您安裝 .NET Framework 3.5 SP1 時,會自動取得 2.0 和 3.0 層。When you install the .NET Framework 3.5 SP1, you get the 2.0 and 3.0 layers automatically.
.NET Framework.NET Framework 3.5 SP1 Full Profile3.5 SP1 Full Profile 包含在 Windows Server 2008 R2Windows Server 2008 R2 SP1 的 Server Core 安裝中。Included in Server Core installation of Windows Server 2008 R2Windows Server 2008 R2 SP1. 如果未啟用,安裝程式預設會予以啟用。If it is not enabled, Setup enables it by default.

在 Windows 伺服器作業系統的電腦上,您必須先下載及安裝 .NET Framework 3.5 SP1,才能執行安裝程式以安裝相依於 .NET 3.5 SP1 的元件。On a computer with Windows server operating system you must download and install .NET Framework 3.5 SP1 before you run Setup, to install components dependent on .NET 3.5 SP1.

如需有關建議和指導如何取得和啟用中的.NET Framework 3.5 Windows Server 2012Windows Server 2012,請參閱 < MICROSOFT.NET Framework 3.5 部署考量(https://msdn.microsoft.com/library/windows/hardware/hh975396) 。For more information about the recommendations and guidance on how to acquire and enable .NET Framework 3.5 in Windows Server 2012Windows Server 2012, see Microsoft .NET Framework 3.5 Deployment Considerations (https://msdn.microsoft.com/library/windows/hardware/hh975396).
.NET Framework.NET Framework 4 Server Core Profile4 Server Core Profile 若是 SQL Server 2014SQL Server 2014 以外的所有 SQL Server ExpressSQL Server Express版本,安裝程式會將 .NET Framework.NET Framework 4 Server Core Profile 安裝為必要元件。For all editions of SQL Server 2014SQL Server 2014 except SQL Server ExpressSQL Server Express, Setup installs the .NET Framework.NET Framework 4 Server Core Profile as a prerequisite.

針對SQL Server 2012 ExpressSQL Server 2012 Express,下載.NET Framework.NET Framework4 Server Core Profile,從適用於 Server Core 的 Microsoft.NET Framework 4 (Standalone Installer) (https://go.microsoft.com/fwlink/?LinkId=220467) ,並將它安裝在您繼續進行安裝程式之前。For SQL Server 2012 ExpressSQL Server 2012 Express, download the .NET Framework.NET Framework 4 Server Core Profile from Microsoft .NET Framework 4 (Standalone Installer) for Server Core (https://go.microsoft.com/fwlink/?LinkId=220467), and install it before you proceed with the setup.
Windows Installer 4.5Windows Installer 4.5 隨附於 Windows Server 2008 R2Windows Server 2008 R2 SP1 和 Windows Server 2012Windows Server 2012的 Server Core 安裝。Shipped with Server Core installation of Windows Server 2008 R2Windows Server 2008 R2 SP1 and Windows Server 2012Windows Server 2012.
Windows PowerShell 2.0Windows PowerShell 2.0 隨附於 Windows Server 2008 R2Windows Server 2008 R2 SP1 和 Windows Server 2012Windows Server 2012的 Server Core 安裝。Shipped with Server Core installation of Windows Server 2008 R2Windows Server 2008 R2 SP1 and Windows Server 2012Windows Server 2012.

Supported FeaturesSupported Features

您可以使用下表來尋找 SQL Server 2014SQL Server 2014 SP1 和 Windows Server 2008 R2Windows Server 2008 R2 的 Server Core 安裝上 Windows Server 2012Windows Server 2012中支援的功能。Use the following table to find which features are supported in SQL Server 2014SQL Server 2014 on a Server Core installation of Windows Server 2008 R2Windows Server 2008 R2 SP1 and Windows Server 2012Windows Server 2012.

功能Feature 支援Supported
Database EngineDatabase Engine 服務Services Yes
[SQL Server]SQL Server 複寫Replication Yes
全文檢索搜尋Full Text Search Yes
Analysis ServicesAnalysis Services Yes
Reporting ServicesReporting Services No
[SQL Server]SQL Server Data Tools (SSDT)Data Tools (SSDT) No
用戶端工具連接性Client Tools Connectivity Yes
Integration Services Server[1]Integration Services Server[1] Yes
用戶端工具回溯相容性Client Tools Backward Compatibility No
用戶端工具 SDKClient Tools SDK No
[SQL Server]SQL Server 線上叢書Books Online No
管理工具 - 基本Management Tools - Basic 僅限遠端[2]Remote Only[2]
管理工具 - 完整Management Tools - Complete 僅限遠端[2]Remote Only[2]
Distributed Replay ControllerDistributed Replay Controller No
Distributed Replay ClientDistributed Replay Client 僅限遠端[2]Remote Only[2]
SQL 用戶端連接性 SDKSQL Client Connectivity SDK Yes
Microsoft Sync FrameworkMicrosoft Sync Framework [3]Yes[3]
Master Data ServicesMaster Data Services No
Data Quality ServicesData Quality Services No

[1]如需有關新的 Integration Services 伺服器和它的功能,在SQL Server 2014SQL Server 2014,請參閱Integration Services (SSIS)伺服器[1]For more information about the new Integration Services Server and its features in SQL Server 2014SQL Server 2014, see Integration Services (SSIS) Server.

[2]不支援安裝在 Server Core 上的這些功能。[2]Installation of these features on Server Core is not supported. 這些元件可以安裝在與 Windows Server 2008 R2Windows Server 2008 R2 Server Core SP1 或 Windows Server 2012Windows Server 2012 Server Core 不同的伺服器上,並連接至安裝在 Server Core 上的 Database EngineDatabase Engine Services。These components can be installed on a different server that is not Windows Server 2008 R2Windows Server 2008 R2 Server Core SP1 or Windows Server 2012Windows Server 2012 Server Core, and connected to the Database EngineDatabase Engine services installed on Server Core.

[3]Microsoft Sync Framework 未包含在SQL Server 2014SQL Server 2014安裝套件。[3]Microsoft Sync Framework is not included in the SQL Server 2014SQL Server 2014 installation package. 您可以從這個下載適當的 Sync Framework 版本Microsoft 下載中心(https://go.microsoft.com/fwlink/?LinkId=221788) 頁面上,並將它安裝在執行 Server Core 安裝的電腦上Windows Server 2008 R2Windows Server 2008 R2 SP1 或Windows Server 2012Windows Server 2012You can download the appropriate version of Sync Framework from this Microsoft Download Center (https://go.microsoft.com/fwlink/?LinkId=221788) page and install it on a computer that is running Server Core installation of Windows Server 2008 R2Windows Server 2008 R2 SP1 or Windows Server 2012Windows Server 2012.

支援的案例矩陣Supported Scenario Matrix

下表顯示在 SQL Server 2014SQL Server 2014 SP1 和 Windows Server 2008 R2Windows Server 2008 R2 的 Server Core 安裝上安裝 Windows Server 2012Windows Server 2012的支援案例矩陣。The following table shows the supported scenario matrix for installing SQL Server 2014SQL Server 2014 on a Server Core installation of Windows Server 2008 R2Windows Server 2008 R2 SP1 and Windows Server 2012Windows Server 2012.

[SQL Server]SQL Server 版本editions 所有SQL Server 2014SQL Server 201464 位元版本[1]All SQL Server 2014SQL Server 2014 64-bit editions[1]
[SQL Server]SQL Server 語言language 所有語言All languages
作業系統語言/地區設定上的[SQL Server]SQL Server 語言 (組合)[SQL Server]SQL Server language on OS language/locale (combination) JPN (日文) Windows 上的 ENG [SQL Server]SQL ServerENG [SQL Server]SQL Server on JPN (Japanese) Windows

GER (德文) Windows 上的 ENG [SQL Server]SQL ServerENG [SQL Server]SQL Server on GER (German) Windows

CHS (簡體中文) Windows 上的 ENG [SQL Server]SQL ServerENG [SQL Server]SQL Server on CHS (Chinese-China) Windows

ARA (阿拉伯文 (SA)) Windows 上的 ENG [SQL Server]SQL ServerENG [SQL Server]SQL Server on ARA (Arabic (SA)) Windows

THA (泰文) Windows 上的 ENG [SQL Server]SQL ServerENG [SQL Server]SQL Server on THA (Thai) Windows

TRK (土耳其文) Windows 上的 ENG [SQL Server]SQL ServerENG [SQL Server]SQL Server on TRK (Turkish) Windows

pt-PT (葡萄牙文 - 葡萄牙) Windows 上的 ENG [SQL Server]SQL ServerENG [SQL Server]SQL Server on pt-PT (Portuguese Portugal) Windows

ENG (英文) Windows 上的 ENG [SQL Server]SQL ServerENG [SQL Server]SQL Server on ENG (English) Windows
Windows 版本Windows edition Windows Server 2012Windows Server 2012 64 位元 x64 Datacenter64-bit x64 Datacenter

Windows Server 2012Windows Server 2012 64 位元 x64 Standard64-bit x64 Standard

Windows Server 2008 R2Windows Server 2008 R2 SP1 64 位元 x64 Data Center Server CoreSP1 64-bit x64 Data Center Server Core

Windows Server 2008 R2Windows Server 2008 R2 SP1 64 位元 x64 Enterprise Server CoreSP1 64-bit x64 Enterprise Server Core

Windows Server 2008 R2Windows Server 2008 R2 SP1 64 位元 x64 Standard Server CoreSP1 64-bit x64 Standard Server Core

Windows Server 2008 R2Windows Server 2008 R2 SP1 64 位元 x64 Web Server CoreSP1 64-bit x64 Web Server Core

[1]安裝 32 位元版本的SQL Server 2014SQL Server 2014版本不支援在 Server Core 上。[1]Installing the 32-bit version of SQL Server 2014SQL Server 2014 editions is not supported on Server Core.

升級Upgrading

在 Server Core 安裝中,可支援從 SQL Server 2012SQL Server 2012 升級至 SQL Server 2014SQL Server 2014On Server Core installations, upgrading from SQL Server 2012SQL Server 2012 to SQL Server 2014SQL Server 2014 is supported.

安裝Installation

SQL Server 2014SQL Server 2014 不支援在 Server Core 作業系統上使用 [安裝精靈] 進行安裝。does not support setup by using the installation wizard on the Server Core operating system. 在 Server Core 上安裝時, [SQL Server]SQL Server 安裝程式支援使用 /Q 參數的完整無訊息模式或使用 /QS 參數的簡單無訊息模式。When installing on Server Core, [SQL Server]SQL Server Setup supports full quiet mode by using the /Q parameter, or Quiet Simple mode by using the /QS parameter. 如需詳細資訊,請參閱從命令提示字元安裝 SQL Server 2014For more information, see Install SQL Server 2014 from the Command Prompt.

重要

在執行 Windows Server 2008 R2Windows Server 2008 R2 Server Core SP1 或 Windows Server 2012Windows Server 2012 Server Core 的電腦上,無法將 SQL Server 2014SQL Server 2014 與舊版 [SQL Server]SQL Server 並行安裝。SQL Server 2014SQL Server 2014 cannot be installed side-by-side with earlier versions of [SQL Server]SQL Server on a computer that is running Windows Server 2008 R2Windows Server 2008 R2 Server Core SP1 or Windows Server 2012Windows Server 2012 Server Core.

除非軟體的使用方式受到個別的合約 (例如 MicrosoftMicrosoft 大量授權合約或與 ISV 或 OEM 簽訂的協力廠商合約) 所管制,否則不論安裝方法為何,您都必須確認以個人身分或代表實體接受軟體授權條款。Regardless of the installation method, you are required to confirm acceptance of the software license terms as an individual or on behalf of an entity, unless your use of the software is governed by a separate agreement such as a MicrosoftMicrosoft volume licensing agreement or a third-party agreement with an ISV or OEM.

這些授權條款會顯示在安裝程式使用者介面中,供您檢閱和接受。The license terms are displayed for review and acceptance in the Setup user interface. 自動安裝 (使用 /Q 或 /QS 參數) 必須包括 /IACCEPTSQLSERVERLICENSETERMS 參數。Unattended installations (using the /Q or /QS parameters) must include the /IACCEPTSQLSERVERLICENSETERMS parameter. 您可以另外在 Microsoft 軟體授權合約檢閱授權條款。You can review the license terms separately at Microsoft Software License Terms.

注意

根據您收到本軟體的方式 (例如,透過 MicrosoftMicrosoft 大量授權),軟體的使用方式可能會受到其他條款與條件的限制。Depending on how you received the software (for example, through MicrosoftMicrosoft volume licensing), your use of the software may be subject to additional terms and conditions.

若要安裝特定功能,請使用 /FEATURES 參數,然後指定父功能或功能值。To install specific features, use the /FEATURES parameter and specify the parent feature or feature values. 如需有關功能參數及其用法的詳細資訊,請參閱下列章節。For more information about feature parameters and their use, see the following sections.

功能參數Feature Parameters

功能參數Feature parameter 描述Description
SQLENGINESQLENGINE 只安裝 Database EngineDatabase EngineInstalls only the Database EngineDatabase Engine.
複寫REPLICATION 安裝 Database EngineDatabase Engine時一併安裝複寫元件。Installs the Replication component along with Database EngineDatabase Engine.
FULLTEXTFULLTEXT 安裝 Database EngineDatabase Engine時一併安裝全文檢索元件。Installs the FullText component along with Database EngineDatabase Engine.
ASAS 安裝所有 Analysis ServicesAnalysis Services 元件。Installs all Analysis ServicesAnalysis Services components.
ISIS 安裝所有 Integration ServicesIntegration Services 元件。Installs all Integration ServicesIntegration Services components.
CONNCONN 安裝連接元件。Installs the connectivity components.

請參閱下列功能參數用法的範例:See the following examples of the usage of feature parameters:

參數和值Parameter and values 描述Description
/FEATURES=SQLEngine/FEATURES=SQLEngine 只安裝 Database EngineDatabase EngineInstalls only the Database EngineDatabase Engine.
/FEATURES=SQLEngine,FullText/FEATURES=SQLEngine,FullText 安裝 Database EngineDatabase Engine 和全文檢索。Installs the Database EngineDatabase Engine and full-text.
/FEATURES=SQLEngine,Conn/FEATURES=SQLEngine,Conn 安裝 Database EngineDatabase Engine 和連接元件。Installs the Database EngineDatabase Engine and the connectivity components.
/FEATURES=SQLEngine,AS,IS,Conn/FEATURES=SQLEngine,AS,IS,Conn 安裝 Database EngineDatabase EngineAnalysis ServicesAnalysis ServicesIntegration ServicesIntegration Services 及連接元件。Installs the Database EngineDatabase Engine, Analysis ServicesAnalysis Services, Integration ServicesIntegration Services, and the connectivity components.

安裝選項Installation Options

在 Server Core 作業系統上安裝 SQL Server 2014SQL Server 2014 時,安裝程式支援下列安裝選項:The Setup supports the following installation options while installing SQL Server 2014SQL Server 2014 on a Server Core operating system:

  1. 從命令列安裝Installation from Command Line

    若要使用命令提示字元安裝選項安裝特定功能,請使用 /FEATURES 參數,然後指定父功能或功能值。To install specific features using the command prompt installation option, use the /FEATURES parameter and specify the parent feature or feature values. 下面是有關從命令列使用參數的範例:The following is an example of using the parameters from the command line:

    Setup.exe /qs /ACTION=Install /FEATURES=SQLEngine,Replication /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /TCPENABLED=1 /IACCEPTSQLSERVERLICENSETERMS  
    
  2. 使用組態檔安裝Installation using Configuration File

    安裝程式僅支援透過命令提示字元使用組態檔。Setup supports the use of the configuration file only through the command prompt. 組態檔是包含參數 (名稱/值組) 和描述性註解基本結構的文字檔。The configuration file is a text file with the basic structure of a parameter (name/value pair) and a descriptive comment. 在命令提示字元指定的組態檔副檔名應該是 .INI。The configuration file specified at the command prompt should have an .INI file name extension. 請參閱下列 ConfigurationFile.INI 的範例:See the following examples of ConfigurationFile.INI:

    • 安裝 Database EngineDatabase EngineInstalling Database EngineDatabase Engine

      下列範例示範如何安裝包含 [SQL Server]SQL ServerDatabase EngineDatabase Engine的新獨立執行個體:The following example shows how to install a new stand-alone instance that includes the [SQL Server]SQL ServerDatabase EngineDatabase Engine:

      ; ssNoVersion Configuration File  
      [OPTIONS]  
      
      ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.   
      
      ACTION="Install"  
      
      ; Specifies features to install, uninstall, or upgrade. The lists of features include SQLEngine, FullText, Replication, AS, IS, and Conn.   
      
      FEATURES=SQLENGINE  
      
      ; 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 ssNoVersion Database Engine, and Analysis Services (AS).  
      
      INSTANCENAME="MSSQLSERVER"  
      
      ; Specify the Instance ID for the ssNoVersion features you have specified. ssNoVersion directory structure, registry structure, and service names will incorporate the instance ID of the ssNoVersion instance.   
      
      INSTANCEID="MSSQLSERVER"  
      
      ; Account for ssNoVersion service: Domain\User or system account.   
      
      SQLSVCACCOUNT="NT Service\MSSQLSERVER"  
      
      ; Windows account(s) to provision as ssNoVersion system administrators.   
      
      SQLSYSADMINACCOUNTS="<DomainName\UserName>"  
      
      ; Accept the License agreement to continue with Installation  
      
      IAcceptSQLServerLicenseTerms="True"  
      
      
    • 安裝連接元件Installing connectivity components

      下列範例示範如何安裝連接元件:The following example shows how to install the connectivity components:

      ; ssNoVersion Configuration File  
      [OPTIONS]  
      
      ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.   
      
      ACTION="Install"  
      
      ; Specifies features to install, uninstall, or upgrade. The lists of features include SQLEngine, FullText, Replication, AS, IS, and Conn.   
      
      FEATURES=Conn  
      
      ; Specifies acceptance of License Terms  
      
      IAcceptSQLServerLicenseTerms="True  
      
      
    • 安裝所有支援的功能Installing all supported features

      下列範例示範如何在 Server Core 上安裝 SQL Server 2014SQL Server 2014 支援的所有功能:The following example shows how to install all supported features of SQL Server 2014SQL Server 2014 on Server Core:

      ; ssNoVersion Configuration File  
      [OPTIONS]  
      ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.   
      
      ACTION="Install"  
      
      ; Specifies features to install, uninstall, or upgrade. The lists of features include SQLEngine, FullText, Replication, AS, IS, and Conn.   
      
      FEATURES=SQLENGINE,FullText,Replication,AS,IS,Conn  
      
      ; 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 ssNoVersion Database Engine (SQL), or Analysis Services (AS).  
      
      INSTANCENAME="MSSQLSERVER"  
      
      ; Specify the Instance ID for the ssNoVersion features you have specified. ssNoVersion directory structure, registry structure, and service names will incorporate the instance ID of the ssNoVersion instance.   
      
      INSTANCEID="MSSQLSERVER"  
      
      ; Account for ssNoVersion service: Domain\User or system account.   
      
      SQLSVCACCOUNT="NT Service\MSSQLSERVER"  
      
      ; Windows account(s) to provision as ssNoVersion system administrators.   
      
      SQLSYSADMINACCOUNTS="<DomainName\UserName>"  
      
      ; The name of the account that the Analysis Services service runs under.   
      
      ASSVCACCOUNT= "NT Service\MSSQLServerOLAPService"  
      
      ; Specifies the list of administrator accounts that need to be provisioned.   
      
      ASSYSADMINACCOUNTS="<DomainName\UserName>"  
      
      ; Specifies the server mode of the Analysis Services instance. Valid values are MULTIDIMENSIONAL, POWERPIVOT or TABULAR. ASSERVERMODE is case-sensitive. All values must be expressed in upper case.   
      
      ASSERVERMODE="MULTIDIMENSIONAL"  
      
      ; Optional value, which specifies the state of the TCP protocol for the ssNoVersion service. Supported values are: 0 to disable the TCP protocol, and 1 to enable the TCP protocol.  
      
      TCPENABLED=1  
      
      ;Specifies acceptance of License Terms  
      
      IAcceptSQLServerLicenseTerms="True"  
      

    下列範例顯示如何使用組態檔啟動安裝程式。The following examples show how you can launch the Setup using a configuration file.

    • 組態檔Configuration file

      以下是有關如何使用組態檔的部分範例:Following are some examples of how to use the configuration file:

      • 若要在命令提示字元中指定組態檔:To specify the configuration file at the command prompt:
      Setup.exe /QS /ConfigurationFile=MyConfigurationFile.INI  
      
      • 若要在命令提示字元而非組態檔中指定密碼:To specify passwords at the command prompt instead of in the configuration file:
      Setup.exe /QS /SQLSVCPASSWORD="************" /ASSVCPASSWORD="************"  /ConfigurationFile=MyConfigurationFile.INI  
      
    • DefaultSetup.iniDefaultSetup.ini

      如果您在 [SQL Server]SQL Server 來源媒體根層級的 \x86 和 \x64 資料夾中具有 DefaultSetup.ini 檔案,請開啟 DefaultSetup.ini 檔案,然後將 Features 參數加入檔案。If you have the DefaultSetup.ini file in the \x86 and \x64 folders at the root level of the [SQL Server]SQL Server source media, open the DefaultSetup.ini file, and then add the Features parameter to the file.

      如果 DefaultSetup.ini 檔案不存在,請建立檔案並將其複製到 [SQL Server]SQL Server 來源媒體根層級的 \x86 和 \x64 資料夾中。If the DefaultSetup.ini file does not exist, you can create it and copy it to the \x86 and \x64 folders at the root level of the [SQL Server]SQL Server source media.

設定在 Server Core 上執行之 [SQL Server]SQL Server 的遠端存取Configuring Remote Access of [SQL Server]SQL Server Running on Server Core

執行下面描述的動作,以設定在 SQL Server 2014SQL Server 2014 SP1 或 Windows Server 2008 R2Windows Server 2008 R2 的 Server Core 安裝上執行之 Windows Server 2012Windows Server 2012 執行個體的遠端存取。Perform the actions described below to configure remote access of a SQL Server 2014SQL Server 2014 instance that is running on a Server Core installation of Windows Server 2008 R2Windows Server 2008 R2 SP1 or Windows Server 2012Windows Server 2012.

[SQL Server]SQL Server的執行個體上啟用遠端連接Enable remote connections on the instance of [SQL Server]SQL Server

若要啟用遠端連接,請在本機使用 SQLCMD.exe,然後針對 Server Core 執行個體執行下列陳述式:To enable remote connections, use SQLCMD.exe locally and execute the following statements against the Server Core instance:

  • EXEC sys.sp_configure N'remote access', N'1'

    GO

  • RECONFIGURE WITH OVERRIDE

    GO

啟用及啟動 [SQL Server]SQL Server Browser 服務Enable and start the [SQL Server]SQL Server Browser service

根據預設,Browser 服務是停用的。By default, the Browser service is disabled. 如果在 Server Core 上執行的 [SQL Server]SQL Server 執行個體已停用此服務,請從命令提示字元執行下列命令,以啟用服務:If it is disabled on an instance of [SQL Server]SQL Server running on Server Core, run the following command from the command prompt to enable it:

sc config SQLBROWSER start= auto

啟用後,請從命令提示字元執行下列命令,以啟動服務:After it is enabled, run the following command from the command prompt to start the service:

net start SQLBROWSER

在 Windows 防火牆中建立例外狀況Create exceptions in Windows Firewall

若要在 Windows 防火牆中建立 [SQL Server]SQL Server 存取的例外狀況,請遵循 設定 Windows 防火牆以允許 SQL Server 存取中指定的步驟。To create exceptions for [SQL Server]SQL Server access in Windows Firewall, follow the steps specified in Configure the Windows Firewall to Allow SQL Server Access.

[SQL Server]SQL Server的執行個體上啟用 TCP/IPEnable TCP/IP on the instance of [SQL Server]SQL Server

您可以針對 Server Core 上的 [SQL Server]SQL Server 執行個體,透過 Windows PowerShell 啟用 TCP/IP 通訊協定。The TCP/IP protocol can be enabled through Windows PowerShell for an instance of [SQL Server]SQL Server on Server Core. 請遵循下列步驟:Follow these steps:

  1. 在執行 Windows Server 2008 R2Windows Server 2008 R2 Server Core SP1 或 Windows Server 2012Windows Server 2012 Server Core 的電腦上,啟動 [工作管理員]。On the computer that is running Windows Server 2008 R2Windows Server 2008 R2 Server Core SP1 or Windows Server 2012Windows Server 2012 Server Core, launch Task Manager.

  2. 在 [應用程式] 索引標籤上,按一下 [新工作] 。On the Applications tab, click New Task.

  3. 在 [建立新工作] 對話方塊的 [開啟] 欄位中輸入 sqlps.exe,然後按一下 [確定] 。In the Create New Task dialog box, type sqlps.exe in the Open field and then click OK. 隨即開啟 [MicrosoftMicrosoft[SQL Server]SQL Server Powershell] 視窗。This opens the MicrosoftMicrosoft[SQL Server]SQL Server Powershell window.

  4. 在 [Microsoft [SQL Server]SQL Server Powershell] 視窗中,執行下列指令碼以啟用 TCP/IP 通訊協定:In the Microsoft [SQL Server]SQL Server Powershell window, run the following script to enable the TCP/IP protocol:

$smo = 'Microsoft.SqlServer.Management.Smo.'  
$wmi = new-object ($smo + 'Wmi.ManagedComputer')  
# Enable the TCP protocol on the default instance.  If the instance is named, replace MSSQLSERVER with the instance name in the following line.  
$uri = "ManagedComputer[@Name='" + (get-item env:\computername).Value + "']/ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Tcp']"  
$Tcp = $wmi.GetSmoObject($uri)  
$Tcp.IsEnabled = $true  
$Tcp.Alter()  
$Tcp  

解除安裝Uninstallation

在登入執行 Windows Server 2008 R2Windows Server 2008 R2 Server Core SP1 或 Windows Server 2012Windows Server 2012 Server Core 的電腦之後,即可透過系統管理員命令提示字元使用有限的桌面環境。After you log on to a computer that is running Windows Server 2008 R2Windows Server 2008 R2 Server Core SP1 or Windows Server 2012Windows Server 2012 Server Core, you have a limited desktop environment with an Administrator command prompt. 您可以使用此命令提示字元啟動 SQL Server 2014SQL Server 2014執行個體的解除安裝。You can use this command prompt to initiate uninstallation of an instance of SQL Server 2014SQL Server 2014. 若要解除安裝 SQL Server 2014SQL Server 2014的執行個體,請在使用 /Q 參數的完整無訊息模式或使用 /QS 參數的簡單無訊息模式中,從命令提示字元啟動解除安裝。To uninstall an instance of SQL Server 2014SQL Server 2014, launch the uninstallation from the command prompt in full quiet mode by using the /Q parameter, or quiet simple mode by using the /QS parameter. /QS 參數透過 UI 顯示進度,但是不接受任何輸入。The /QS parameter shows progress through the UI, but does not accept any input. /Q 會在不含任何使用者介面的無訊息模式中執行。/Q runs in a quiet mode without any user interface.

解除安裝現有的 [SQL Server]SQL Server 執行個體:To uninstall an existing instance of [SQL Server]SQL Server:

Setup.exe /Q /Action=Uninstall /FEATURES=SQLEngine,AS,IS /INSTANCENAME=MSSQLSERVER  

若要移除具名執行個體,請在上述範例中指定執行個體的名稱,而非 "MSSQLSERVER"。To remove a named instance, specify the name of the instance instead of "MSSQLSERVER" in the preceding example.

警告

如果您不小心關閉命令提示字元,您可以遵循下列步驟啟動新的命令提示字元:If you accidentally close the command prompt, you can start a new command prompt by following these steps:

  1. 按 Ctrl+Shift+Esc 鍵顯示 [工作管理員]。Press Ctrl+Shift+Esc to display Task Manager.
  2. 在 [應用程式] 索引標籤上,按一下 [新工作] 。On the Applications tab, click New Task.
  3. 在 [建立新工作] 對話方塊的 [開啟] 欄位中,輸入 cmd,然後按一下 [確定] 。Click OK.In the Create New Task dialog box, type cmd in the Open field and then 按一下 [確定] 。Click OK..

另請參閱See Also

安裝 SQL Server 2014 使用組態檔 Install SQL Server 2014 Using a Configuration File
從命令提示字元安裝 SQL Server 2014 Install SQL Server 2014 from the Command Prompt
SQL Server 2014 各版本所支援的功能 Features Supported by the Editions of SQL Server 2014
Server Core 安裝選項快速入門指南 Server Core Installation Option Getting Started Guide
設定 Server Core 安裝:概觀 Configuring a Server Core installation: Overview
Windows PowerShell 中由工作焦點列出的容錯移轉叢集 Cmdlet Failover Cluster Cmdlets in Windows PowerShell Listed by Task Focus
針對容錯移轉叢集將 Cluster.exe 命令對應到 Windows PowerShell CmdletMapping Cluster.exe Commands to Windows PowerShell Cmdlets for Failover Clusters