安裝容錯移轉叢集之前Before Installing Failover Clustering

安裝 [SQL Server]SQL Server 容錯移轉叢集之前,您必須先選取硬體以及要執行 [SQL Server]SQL Server 的作業系統。Before you install a [SQL Server]SQL Server failover cluster, you must select the hardware and the operating system on which [SQL Server]SQL Server will run. 您也必須設定 Windows Server 容錯移轉叢集 (WSFC),並檢閱要在容錯移轉叢集上執行之其他軟體的網路、安全性及考量。You must also configure Windows Server Failover Clustering (WSFC), and review network, security, and considerations for other software that will run on your failover cluster.

如果 Windows 叢集有本機磁碟機,而且同一個磁碟機代號在一個或多個叢集節點上也做為共用磁碟機使用時,您無法將 [SQL Server]SQL Server 安裝在該磁碟機上。If a Windows cluster has a local disk drive and the same drive letter is also used on one or more cluster nodes as a shared drive, you cannot install [SQL Server]SQL Server on that drive.

您可能也想要檢閱下列主題,以進一步了解 [SQL Server]SQL Server 容錯移轉叢集概念、功能及工作。You may also want to review the following topics to learn more about [SQL Server]SQL Server failover clustering concepts, features and tasks.

主題說明Topic Description 主題Topic
說明 [SQL Server]SQL Server Windows 容錯移轉叢集概念,並提供連結至相關的內容及工作。Describes [SQL Server]SQL Server failover clustering concepts, and provides links to associated content and tasks. AlwaysOn 容錯移轉叢集執行個體 (SQL Server)AlwaysOn Failover Cluster Instances (SQL Server)
說明 [SQL Server]SQL Server 容錯移轉原則概念,並提供連結設定容錯移轉原則,以符合您組織的需求。Describes [SQL Server]SQL Server failover policy concepts, and provides links to configuring the failover policy to suit your organizational requirements. Failover Policy for Failover Cluster InstancesFailover Policy for Failover Cluster Instances
說明如何維護以及您現有的 [SQL Server]SQL Server 容錯移轉叢集。Describes how to maintain and your existing [SQL Server]SQL Server failover cluster. 容錯移轉叢集執行個體管理及維護Failover Cluster Instance Administration and Maintenance
說明如何在 Windows Server 容錯移轉叢集 (WSFC) 上安裝 Analysis ServicesAnalysis ServicesExplains how to install Analysis ServicesAnalysis Services on a Windows Server Failover Cluster (WSFC). 如何將 SQL Server Analysis Services 叢集化How to Cluster SQL Server Analysis Services

最佳作法Best Practices

  • 檢閱 SQL Server 2014SQL Server 2014版本資訊Review SQL Server 2014SQL Server 2014Release Notes

  • 安裝必要元件軟體。Install prerequisite software. 執行安裝程式來安裝或升級至 SQL Server 2014SQL Server 2014之前,請先安裝下列必要元件以縮短安裝時間。Before running Setup to install or upgrade to SQL Server 2014SQL Server 2014, install the following prerequisites to reduce installation time. 您可以在執行安裝程式之前,於每個容錯移轉叢集節點上安裝必要元件軟體,然後重新啟動節點一次。You can install prerequisite software on each failover cluster node and then restart nodes once before running Setup.

    • [SQL Server]SQL Server 安裝程式將不再安裝 Windows PowerShell。Windows PowerShell is no longer installed by [SQL Server]SQL Server Setup. Windows PowerShell 2.0 是安裝 SQL Server 2014SQL Server 2014Database EngineDatabase Engine 元件和 SQL Server Management StudioSQL Server Management Studio 的必要條件。Windows PowerShell 2.0 is a prerequisite for installing SQL Server 2014SQL Server 2014Database EngineDatabase Engine components and SQL Server Management StudioSQL Server Management Studio. 如果您的電腦沒有 Windows PowerShell 2.0,可以遵循 Windows Management Framework 頁面上的指示啟用此元件。If Windows PowerShell 2.0 is not present on your computer, you can enable it by following the instructions on the Windows Management Framework page.

    • [SQL Server]SQL Server 安裝程式不再安裝 .NET Framework 3.5 SP1,但是在較舊的 Windows 作業系統上安裝 [SQL Server]SQL Server 時,可能需要 .NET Framework 3.5 SP1。.NET Framework 3.5 SP1 is no longer installed by [SQL Server]SQL Server Setup, but may be required while installing [SQL Server]SQL Server on older Windows operating systems. 如需詳細資訊,請參閱 SQL Server 2014SQL Server 2014版本資訊For more information, see SQL Server 2014SQL Server 2014Release Notes.

    • MicrosoftMicrosoft 更新封裝: 為避免在安裝程期間電腦因安裝 .NET Framework 4 而重新啟動,SQL Server 2014SQL Server 2014 安裝程式要求電腦上必須已安裝 MicrosoftMicrosoft 更新。MicrosoftMicrosoft Update package: To avoid computer restart due to .NET Framework 4 installation during setup, SQL Server 2014SQL Server 2014 setup requires a MicrosoftMicrosoft update to be installed on the computer. 如果您是在 Windows 7 SP1 或 SQL Server 2014SQL Server 2014 SP2 上安裝 Windows Server 2008Windows Server 2008 ,則會包含這項更新。If you are installing SQL Server 2014SQL Server 2014 on Windows 7 SP1 or Windows Server 2008Windows Server 2008 SP2 this update is included. 如果您是在較舊的 Windows 作業系統上安裝,請從 Windows Vista 和 Windows Server 2008 上之 .NET Framework 4.0 適用的 Microsoft Update下載此更新。If you are installing on an older Windows operating system, download it from Microsoft Update for .NET Framework 4.0 on Windows Vista and Windows Server 2008.

    • .NET Framework 4:安裝程式會在叢集作業系統上安裝 .NET Framework 4。.NET Framework 4: Setup installs .NET Framework 4 on a clustered operating system. 若要縮短安裝時間,您可以考慮在執行安裝程式前先安裝 .NET Framework 4。To reduce installation time, you may consider installing .NET Framework 4 before you run Setup.

    • [SQL Server]SQL Server 安裝程式支援檔案。Setup support files. 您可以執行位於 SQL Server 2014SQL Server 2014 安裝媒體上的 SqlSupport.msi 以安裝這些檔案。You can install these files by running SqlSupport.msi located on your SQL Server 2014SQL Server 2014 installation media.

  • 確認在 WSFC 叢集上未安裝防毒軟體。Verify that antivirus software is not installed on your WSFC cluster. 如需詳細資訊,請參閱 MicrosoftMicrosoft 知識庫文件: 防毒軟體可能會導致叢集服務發生問題For more information, see the MicrosoftMicrosoft Knowledge Base article, Antivirus software may cause problems with cluster services.

  • 安裝容錯移轉叢集期間為叢集群組命名時,不可以在叢集群組名稱中使用下列任何字元:When naming a cluster group for your failover cluster installation, you must not use any of the following characters in the cluster group name:

    • 小於運算子 (<)Less than operator (<)

    • 大於運算子 (>)Greater than operator (>)

    • 雙引號 (")Double quote (")

    • 單引號 (')Single quote (')

    • 連字號 (&)Ampersand (&)

    此外,請確認現有的叢集群組名稱沒有包含不支援的字元。Also verify that existing cluster group names do not contain unsupported characters.

  • 確定所有叢集節點已設定相同,包括 COM+、磁碟機代號,以及管理員群組中的使用者。Ensure that all cluster nodes are configured identically, including COM+, disk drive letters, and users in the administrators group.

  • 驗證您已經清除了所有節點上的系統記錄檔,並已經再次檢視過系統記錄檔。Verify that you have cleared the system logs in all nodes and viewed the system logs again. 請在繼續下個步驟之前,確認記錄檔完全沒有任何錯誤訊息。Ensure that the logs are free of any error messages before continuing.

  • 在安裝或更新 [SQL Server]SQL Server 容錯移轉叢集之前,請停用所有可能在安裝期間使用 [SQL Server]SQL Server 元件的應用程式和服務,但請將磁碟資源保持為線上的狀態。Before you install or update a [SQL Server]SQL Server failover cluster, disable all applications and services that might use [SQL Server]SQL Server components during installation, but leave the disk resources online.

  • [SQL Server]SQL Server 安裝程式會自動設定 [SQL Server]SQL Server 叢集群組與位於容錯移轉叢集中之磁碟之間的相依性。Setup automatically sets dependencies between the [SQL Server]SQL Server cluster group and the disks that will be in the failover cluster. 請勿在安裝之前設定磁碟的相依性。Do not set dependencies for disks before Setup.

    • [SQL Server]SQL Server 容錯移轉叢集安裝期間,將會建立 [SQL Server]SQL Server 網路資源名稱的電腦物件 (Active Directory 電腦帳戶)。During [SQL Server]SQL Server Failover Cluster installation, computer object (Active Directory computer accounts) for the [SQL Server]SQL Server Network Resource Name is created. Windows Server 2008Windows Server 2008 叢集中,叢集名稱帳戶 (叢集本身的電腦帳戶) 需要擁有建立電腦物件的權限。In a Windows Server 2008Windows Server 2008 cluster, the cluster name account (computer account of the cluster itself) needs to have permissions to create computer objects. 如需詳細資訊,請參閱< 容錯移轉叢集逐步指南:設定 Active Directory 中的帳戶>。For more information, see Configuring Accounts in Active Directory.

    • 如果您使用 SMB 檔案共用做為儲存選項, [SQL Server]SQL Server 安裝帳戶必須具有檔案伺服器的 SeSecurityPrivilege。If you are using SMB File share as a storage option, the [SQL Server]SQL Server Setup account must have SeSecurityPrivilege on the file server. 若要執行這項操作,請使用檔案伺服器上的 [本機安全性原則] 主控台,將 [SQL Server]SQL Server 安裝帳戶加入 [管理稽核及安全性記錄] 權限。To do this, using the Local Security Policy console on the file server, add the [SQL Server]SQL Server setup account to Manage auditing and security log rights.

驗證硬體方案Verify Your Hardware Solution

  • 如果叢集方案包括位於不同地點的叢集節點,則必須驗證如網路延遲及共用磁碟支援等其他項目。If the cluster solution includes geographically dispersed cluster nodes, additional items like network latency and shared disk support must be verified.

  • 確認要安裝 [SQL Server]SQL Server 的磁碟未壓縮或加密。Verify that the disk where [SQL Server]SQL Server will be installed is not compressed or encrypted. 如果您嘗試將 [SQL Server]SQL Server 安裝到壓縮的磁碟機或加密的磁碟機,則 [SQL Server]SQL Server 安裝程式會失敗。If you attempt to install [SQL Server]SQL Server to a compressed drive or an encrypted drive, [SQL Server]SQL Server Setup fails.

  • Windows Server 2008Windows Server 2008Windows Server 2008 R2Windows Server 2008 R2 Advanced Server 及 Datacenter Server Edition 也支援 SAN 組態。SAN configurations are also supported on Windows Server 2008Windows Server 2008 and Windows Server 2008 R2Windows Server 2008 R2 Advanced Server and Datacenter Server editions. 「Windows Catalog 與硬體相容性清單」的類別目錄 "Cluster/Multi-cluster Device" 會列出一組具有 SAN 功能的儲存裝置,這些裝置已通過測試,並支援可附加多個 WSFC 叢集的 SAN 儲存單位。The Windows Catalog and Hardware Compatibility List category "Cluster/Multi-cluster Device" lists the set of SAN-capable storage devices that have been tested and are supported as SAN storage units with multiple WSFC clusters attached. 尋找認證的元件後,請執行叢集驗證。Run cluster validation after finding the certified components.

  • 另外也支援用於安裝資料檔案的 SMB 檔案共用。SMB File Share is also supported for installing data files. 如需詳細資訊,請參閱 資料檔案的儲存類型For more information, see Storage Types for Data Files.

    警告

    如果您使用 Windows 檔案伺服器做為 SMB 檔案共用儲存,則 [SQL Server]SQL Server 安裝帳戶必須具有檔案伺服器的 SeSecurityPrivilege。If you are using Windows File Server as a SMB File Share storage, the [SQL Server]SQL Server Setup account must have SeSecurityPrivilege on the file server. 若要執行這項操作,請使用檔案伺服器上的 [本機安全性原則] 主控台,將 [SQL Server]SQL Server 安裝帳戶加入 [管理稽核及安全性記錄] 權限。To do this, using the Local Security Policy console on the file server, add the [SQL Server]SQL Server setup account to Manage auditing and security log rights.

    如果您要使用 Windows 檔案伺服器以外的 SMB 檔案共用儲存,請洽詢儲存廠商,了解檔案伺服器端的對等設定。If you are using SMB file share storage other than Windows File server, please consult the storage vendor for an equivalent setting on the file server side.

  • [SQL Server]SQL Server 支持掛接點。supports mount points.

    掛接的磁碟區 (或掛接點) 可讓您使用單一磁碟機代號來代表許多磁碟或磁碟區。A mounted volume, or mount point, allows you to use a single drive letter to refer to many disks or volumes. 如果您以磁碟機代號 D: 來代表一般的磁碟或磁碟區,則您可以連接或「掛載」額外的磁碟或磁碟區為磁碟機代號 D: 下的目錄,而不需每一個磁碟或磁碟區都有自己的磁碟機代號。If you have a drive letter D: that refers to a regular disk or volume, you can connect or "mount" additional disks or volumes as directories under drive letter D: without the additional disks or volumes requiring drive letters of their own.

    [SQL Server]SQL Server 容錯移轉叢集的其他掛載點考量:Additional mount point considerations for [SQL Server]SQL Server failover clustering:

    • [SQL Server]SQL Server 安裝程式需要已掛載磁碟機的基底磁碟機具有連接的磁碟機代號。Setup requires that the base drive of a mounted drive has an associated drive letter. 若為容錯移轉叢集安裝,這個基底磁碟機必須是叢集磁碟機。For failover cluster installations, this base drive must be a clustered drive. 這個版本不支援磁碟區 GUID。Volume GUIDs are not supported in this release.

    • 含磁碟機代號的基底磁碟機不能在容錯移轉叢集執行個體之間共用。The base drive, the one with the drive letter, cannot be shared among failover cluster instances. 這是容錯移轉叢集的正常限制,但不會限制獨立和多執行個體的伺服器。This is a normal restriction for failover clusters, but is not a restriction on stand-alone, multi-instance servers.

    • [SQL Server]SQL Server 的叢集安裝乃受限於可用的磁碟機代號。The clustered installations of [SQL Server]SQL Server are limited to the number of available drive letters. 假設您針對作業系統只使用一個磁碟機代號,而且其他所有磁碟機代號都可做為正常叢集磁碟機或主控掛載點的叢集磁碟機,則限制為每一容錯移轉叢集最多可有 25 個 [SQL Server]SQL Server 執行個體。Assuming that you use only one drive letter for the operating system, and all other drive letters are available as normal cluster drives or cluster drives hosting mount points, you are limited to a maximum of 25 instances of [SQL Server]SQL Server per failover cluster.

      提示

      可藉由使用 SMB 檔案共享選項來克服 25 個執行個體的限制。The 25 instance limit can be overcome by using SMB file share option. 如果您使用 SMB 檔案共用來當成儲存選項,您可以安裝高達 50 個 [SQL Server]SQL Server 容錯移轉叢集執行個體。If you use SMB file share as the storage option, you can install up to 50 [SQL Server]SQL Server failover cluster instances.

    • 不支援在裝載其他磁碟機之後格式化磁碟機。Formatting a drive after mounting additional drives is not supported.

  • [SQL Server]SQL Server 容錯移轉叢集安裝只有在安裝 tempdb 檔時支援本機磁碟。failover cluster installation supports Local Disk only for installing the tempdb files. 務必確定在所有叢集節點上為 tempdb 資料和記錄檔指定的路徑都是有效的。Ensure that the path specified for the tempdb data and log files is valid on all the cluster nodes. 在容錯移轉期間,如果容錯移轉目標節點上的 tempdb 目錄無法使用,則 [SQL Server]SQL Server 資源將無法上線。During failover, if the tempdb directories are not available on the failover target node, the [SQL Server]SQL Server resource will fail to come online. 如需詳細資訊,請參閱 資料檔案的儲存類型Database Engine 組態 - 資料目錄For more information, see Storage Types for Data Files and Database Engine Configuration - Data Directories.

  • 如果您在 iSCSI 技術元件上部署 [SQL Server]SQL Server 容錯移轉叢集,我們建議您小心進行。If you deploy a [SQL Server]SQL Server failover cluster on iSCSI technology components, we recommend that you use appropriate caution. 如需詳細資訊,請參閱< iSCSI 技術元件對於 SQL Server 的支援>(機器翻譯)。For more information, see Support for SQL Server on iSCSI technology components.

  • 如需詳細資訊,請參閱< Microsoft 叢集的 SQL Server 支援原則>(機器翻譯)。For more information, see SQL Server support policy for Microsoft Clustering.

  • 如需有關適當仲裁磁碟機組態的詳細資訊,請參閱< 仲裁磁碟機組態資訊>(機器翻譯)。For more information about proper quorum drive configuration, see Quorum Drive Configuration Information.

  • 若要在 [SQL Server]SQL Server 來源安裝檔案與叢集位於不同網域時安裝 [SQL Server]SQL Server 容錯移轉叢集,請將安裝檔案複製到可供 [SQL Server]SQL Server 容錯移轉叢集使用的目前網域。To install a [SQL Server]SQL Server failover cluster when the [SQL Server]SQL Server source installation files and the cluster exist on different domains, copy the installation files to the current domain available to the [SQL Server]SQL Server failover cluster.

預覽安全考量Review Security Considerations

  • 若要使用加密,請利用 WSFC 叢集的完整 DNS 名稱,在 [SQL Server]SQL Server 容錯移轉叢集中的所有節點上安裝伺服器憑證。To use encryption, install the server certificate with the fully qualified DNS name of the WSFC cluster on all nodes in the [SQL Server]SQL Server failover cluster. 例如,如果您具有兩個節點的叢集 (節點名稱為 "Test1.DomainName.com" 及 "Test2.DomainName.com"),以及 [SQL Server]SQL Server 容錯移轉叢集執行個體 (名稱為 "Virtsql"),則您必須取得 "Virtsql.DomainName.com" 的憑證,並將憑證安裝在 test1 及 test2 節點上。For example, if you have a two-node cluster, with nodes named "Test1.DomainName.com" and "Test2.DomainName.com" and a [SQL Server]SQL Server failover cluster instance named "Virtsql", you must get a certificate for "Virtsql.DomainName.com" and install the certificate on the test1 and test2 nodes. 接著,您可以選取「 組態管理員」中的 [強制通訊協定加密] [SQL Server]SQL Server 核取方塊,為您的容錯移轉叢集設定加密。Then you can select the Force protocol encryption check box on the [SQL Server]SQL Server Configuration Manager to configure your failover cluster for encryption.

    重要

    除非您已將憑證安裝在容錯移轉叢集執行個體的所有參與節點上,否則請勿選取 [強制通訊協定加密] 核取方塊。Do not select the Force protocol encryption check box until you have certificates installed on all participating nodes in your failover cluster instance.

  • 對於與舊版並存組態的 [SQL Server]SQL Server 安裝而言, [SQL Server]SQL Server 服務必須使用只存在於全域網域群組中的帳戶。For [SQL Server]SQL Server installations in side-by-side configurations with previous versions, [SQL Server]SQL Server services must use accounts found only in the global domains group. 此外, [SQL Server]SQL Server 服務所使用的帳戶不能出現在本機的管理員群組中。Additionally, accounts used by [SQL Server]SQL Server services must not appear in the local Administrators group. 如果沒有遵照這項指導方針進行,將會導致非預期的安全性行為。Failure to comply with this guideline will result in unexpected security behavior.

  • 若要建立容錯移轉叢集,您必須是擁有下列權限的本機管理員:能夠以服務登入,而且能夠做為容錯移轉叢集執行個體之所有節點上的作業系統的一部分。To create a failover cluster, you must be a local administrator with permissions to log on as a service, and to act as part of the operating system on all nodes of the failover cluster instance.

  • Windows Server 2008Windows Server 2008上,系統會自動產生可搭配 SQL Server 2014SQL Server 2014 服務使用的服務 SID。On Windows Server 2008Windows Server 2008, service SIDs are generated automatically for use with SQL Server 2014SQL Server 2014 services. 如果是從舊版 SQL Server 2014SQL Server 2014 升級的 [SQL Server]SQL Server容錯移轉叢集執行個體,就會保留現有的網域群組和 ACL 組態。For SQL Server 2014SQL Server 2014 failover cluster instances upgraded from previous versions of [SQL Server]SQL Server, existing domain groups and ACL configurations will be preserved.

  • 網域群組必須與電腦帳戶位在相同的網域內。Domain groups must be within the same domain as the machine accounts. 例如,如果安裝 [SQL Server]SQL Server 的電腦是在屬於 MYDOMAIN 子系的 SQLSVR 網域內,則必須指定 SQLSVR 網域中的群組。For example, if the machine where [SQL Server]SQL Server will be installed is in the SQLSVR domain which is a child of MYDOMAIN, you must specify a group in the SQLSVR domain. SQLSVR 網域可能會包含 MYDOMAIN 中的使用者帳戶。The SQLSVR domain may contain user accounts from MYDOMAIN.

  • [SQL Server]SQL Server 容錯移轉叢集。failover clustering cannot be installed where cluster nodes are domain controllers.

  • 檢閱 Security Considerations for a SQL Server Installation中的內容。Review content in Security Considerations for a SQL Server Installation.

  • 若要以 [SQL Server]SQL Server啟用 Kerberos 驗證,請參閱 知識庫中的 如何使用 SQL Server Kerberos 驗證 MicrosoftMicrosoft (機器翻譯)。To enable Kerberos authentication with [SQL Server]SQL Server, see How to use Kerberos authentication in SQL Server in the MicrosoftMicrosoft Knowledge Base.

預覽網絡、通訊埠和防火牆的考量Review Network, Port, and Firewall Considerations

  • 開始 [SQL Server]SQL Server 安裝程式之前,請確認您已停用所有私人網路卡的 NetBIOS。Verify that you have disabled NetBIOS for all private network cards before beginning [SQL Server]SQL Server Setup.

  • 您的 [SQL Server]SQL Server 的網路名稱及 IP 位址不應該用於任何其他目的,如檔案共用。The network name and IP address of your [SQL Server]SQL Server should not be used for any other purpose, such as file sharing. 如果您想要建立檔案共用資源,請對資源使用不同且唯一網路名稱及 IP 位址。If you want to create a file share resource, use a different, unique network name and IP address for the resource.

    重要

    建議您不要在資料磁碟機上使用檔案共用,因為它們可能影響 [SQL Server]SQL Server 的行為及效能。We recommend that you do not use file shares on data drives, because they can affect [SQL Server]SQL Server behavior and performance.

  • 即使 [SQL Server]SQL Server 可透過叢集內的 TCP/IP 同時支援具名管道及 TCP/IP 通訊端,但仍然建議您在叢集組態中使用 TCP/IP 通訊端。Even though [SQL Server]SQL Server supports both Named Pipes and TCP/IP Sockets over TCP/IP within a cluster, we recommend that you use TCP/IP Sockets in a clustered configuration.

  • 請注意,Windows 叢集不支援 ISA 伺服器,因此 [SQL Server]SQL Server 容錯移轉叢集也不支援它。Note that ISA server is not supported on Windows Clustering and consequently is also not supported on [SQL Server]SQL Server failover clusters.

  • 遠端登錄服務必須正常執行。The Remote Registry service must be up and running.

  • 遠端管理必須已啟用。Remote Administration must be enabled.

  • 針對 [SQL Server]SQL Server 通訊埠,請使用 [SQL Server]SQL Server 組態管理員來檢查您想要解除封鎖之執行個體 TCP/IP 通訊協定的 [SQL Server]SQL Server 網路組態。For the [SQL Server]SQL Server port, use [SQL Server]SQL Server Configuration Manager to check the [SQL Server]SQL Server network configuration for the TCP/IP protocol for the instance you want to unblock. 如果您想要在安裝之後使用 TCP 來連接至 [SQL Server]SQL Server ,就必須啟用 IPALL 的 TCP 通訊埠。You must enable the TCP port for IPALL if you want to connect to [SQL Server]SQL Server using TCP after installation. 根據預設,SQL Browser 會接聽 UDP 通訊埠 1434。By default, SQL Browser listens on UDP port 1434.

  • 容錯移轉叢集安裝程式作業包括檢查網路連結順序的規則。Failover cluster Setup operations include a rule that checks network binding order. 雖然連結順序看起來可能是正確的,但是您可能已停用或「準刪除」系統上的 NIC 組態。Although binding orders might seem correct, you might have disabled or "ghosted" NIC configurations on the system. 「準刪除」NIC 組態可能會影響連結順序,而且會導致連結順序規則發出警告。"Ghosted" NIC configurations can affect the binding order and cause the binding order rule to issue a warning. 若要避免這種情況,請使用下列步驟來識別並移除已停用的網路介面卡:To avoid this situation, use the following steps to identify and remove disabled network adapters:

    1. 在命令提示字元中,輸入:set devmgr_Show_Nonpersistent_Devices=1。At a command prompt, type: set devmgr_Show_Nonpersistent_Devices=1.

    2. 輸入並執行:start Devmgmt.msc。Type and run: start Devmgmt.msc.

    3. 展開網路介面卡的清單。Expand the list of network adapters. 只有實體介面卡才應該位於此清單中。Only the physical adapters should be in the list. 如果您擁有已停用的網路介面卡,安裝程式就會針對網路連結順序規則報告失敗。If you have a disabled network adapter, Setup will report a failure for the network binding order rule. [控制台]/[網路連線] 也會顯示此介面卡已停用。Control Panel/Network Connections will also show that adapter was disabled. 確認 [控制台] 中的 [網路設定] 與 devmgmt.msc 顯示相同的已啟用實體配接器清單。Confirm that Network Settings in Control Panel shows the same list of enabled physical adapters that devmgmt.msc shows.

    4. 在您執行 [SQL Server]SQL Server 安裝程式之前,請移除已停用的網路配接器。Remove disabled network adapters before you run [SQL Server]SQL Server Setup.

    5. 在安裝程式完成之後,請返回 [控制台] 中的 [網路連線] 並停用目前非使用中的任何網路介面卡。After Setup finishes, return to Network Connections in Control Panel and disable any network adapters that are not currently in use.

驗證您的作業系統Verify Your Operating System

確定您已正確安裝作業系統,而且其設計可支援容錯移轉叢集。Make sure that your operating system is installed properly and is designed to support failover clustering. 下表是 [SQL Server]SQL Server 版本及支援這些版本之作業系統的清單。The following table is a list of [SQL Server]SQL Server editions and the operating systems that support them.

[SQL Server]SQL Server 版本edition Windows Server 2008Windows Server 2008 EnterpriseEnterprise Windows Server 2008Windows Server 2008 Datacenter ServerDatacenter Server Windows Server 2008 R2Windows Server 2008 R2 EnterpriseEnterprise Windows Server 2008 R2Windows Server 2008 R2 Datacenter ServerDatacenter Server
SQL Server 2014SQL Server 2014 Enterprise (64 位元) x641Enterprise (64-bit) x641 Yes Yes 2Yes2 2Yes2
SQL Server 2014SQL Server 2014 Enterprise (32 位元)Enterprise (32-bit) Yes Yes
SQL Server 2014SQL Server 2014 Developer (64 位元)-bit) Developer (64 Yes Yes 2Yes 2 2Yes 2
SQL Server 2014SQL Server 2014 Developer (32 位元)Developer (32-bit) Yes Yes
SQL Server 2014SQL Server 2014 Standard (64 位元)Standard (64-bit) Yes Yes Yes Yes
SQL Server 2014SQL Server 2014 Standard (32 位元)Standard (32-bit) Yes Yes

1 [SQL Server]SQL Server在 WOW 模式下不支援叢集。1 [SQL Server]SQL Server clusters are not supported in WOW mode. 其中包括來自原先安裝在 WOW 中之舊版 [SQL Server]SQL Server 容錯移轉叢集的升級。That includes upgrades from previous versions of [SQL Server]SQL Server failover clusters that were originally installed in WOW. 對於這些版本而言,唯一的升級選項就是並存安裝新的版本並進行移轉。For those the only upgrade option is to install the new version side by side and migrate.

2支援[SQL Server]SQL Server多重子網路容錯移轉叢集。2 Supported for [SQL Server]SQL Server multi-subnet failover clustering.

多重子網路組態的其他考量Additional Considerations for Multi-Subnet Configurations

安裝 [SQL Server]SQL Server 多重子網路容錯移轉叢集時,請將下列章節描述的需求謹記在心。The sections below describe the requirements to keep in mind when installing a [SQL Server]SQL Server multi-subnet failover cluster. 一個多重子網路設定涉及了多重子網路間的叢集,因此涉及使用多重 IP 位址,及改變 IP 位址資源的相依性。A multi-subnet configuration involves clustering across multiple subnets, therefore involves using multiple IP addresses and changes to IP address resource dependencies.

[SQL Server]SQL Server 版本與作業系統考量Edition and Operating System Considerations

  • 如需支援 [SQL Server]SQL Server 多重子網路容錯移轉叢集之 [SQL Server]SQL Server 版本的相關資訊,請參閱 SQL Server 2014 版本支援的功能For information about the editions of [SQL Server]SQL Server that support a [SQL Server]SQL Server multi-subnet failover cluster, see Features Supported by the Editions of SQL Server 2014.

  • 若要建立 [SQL Server]SQL Server 多重子網路容錯移轉叢集,您必須先在多重子網路上建立 Windows Server 2008 R2Windows Server 2008 R2 多站台容錯移轉叢集。To create a [SQL Server]SQL Server multi-subnet failover cluster, you must first create the Windows Server 2008 R2Windows Server 2008 R2 multi-site failover cluster on multiple subnets.

  • [SQL Server]SQL Server 容錯移轉叢集相依於 Windows 伺服器容錯移轉叢集,因此如果有容錯移轉時,請確定 IP 相依性條件是有效的。failover cluster depends on the Windows Server failover cluster to make sure that the IP dependency conditions are valid if there is a failover.

  • Windows Server 2008 R2Windows Server 2008 R2 需要所有的叢集伺服器都要在相同的 Active Directory 網域。requires that all the cluster servers must be in the same Active Directory domain. 因此, [SQL Server]SQL Server 即使叢集節點存在於不同的子網路中,多重子網路容錯移轉叢集仍需要所有的叢集節點都位於相同的 Active Directory 網域。Therefore, [SQL Server]SQL Server multi-subnet failover cluster requires that all the cluster nodes be in the same Active Directory domain even if they are in different subnets.

IP 位址和 IP 位址資源相依性IP Address and IP Address Resource Dependencies

  1. 在一個多重子網路設定中,IP 位址資源相依性乃設為 OR。The IP Address resource dependency is set to OR in a multi-subnet configuration. 如需詳細資訊,請參閱建立新的 SQL Server 容錯移轉叢集 (安裝程式)For more information, see Create a New SQL Server Failover Cluster (Setup)

  2. 不支援混合的 AND-OR IP 位址相依性。Mixed AND-OR IP address dependencies are not supported. 例如,不支援 <IP1> AND <IP2> OR <IP3>。For example, <IP1> AND <IP2> OR <IP3> is not supported.

  3. 不支援每個子網路有多個 IP 位址。More than one IP address per subnet is not supported.

    如果您決定為相同的子網路設定超過一個 IP 位址,您可能會在 [SQL Server]SQL Server 啟動時,遇到用戶端連接失敗。If you decide to use more than one IP address configured for the same subnet, you may experience client connection failures during [SQL Server]SQL Server startup.

如需 Windows Server 2008 R2Windows Server 2008 R2 多站台容錯移轉的詳細資訊,請參閱 Failover Clusters in Windows Server 2008 R2 (Windows Server 2008 R2 的容錯移轉叢集) 和 Design for a Clustered Service or Application in a Multi-Site Failover Cluster(針對多站台容錯移轉叢集中的叢集服務或應用程式進行設計)。For more information about Windows Server 2008 R2Windows Server 2008 R2 multi-site failover, see Windows Server 2008 R2 Failover Clustering Site and Design for a Clustered Service or Application in a Multi-Site Failover Cluster.

設定 Windows Server 容錯移轉叢集Configure Windows Server Failover Cluster

  • MicrosoftMicrosoft 您至少必須在伺服器叢集的一個節點上設定 Cluster Service (WSFC)。Cluster Service (WSFC) must be configured on at least one node of your server cluster. 您也必須結合 WSFC 一併執行 [SQL Server]SQL Server Enterprise、 [SQL Server]SQL Server Business Intelligence 或 [SQL Server]SQL Server Standard。You must also run [SQL Server]SQL Server Enterprise, [SQL Server]SQL Server Business Intelligence, or [SQL Server]SQL Server Standard in conjunction with WSFC. [SQL Server]SQL Server Enterprise 最多支援含有 16 個節點的容錯移轉叢集。Enterprise support failover clusters with up to 16 nodes. [SQL Server]SQL Server Business Intelligence 和 [SQL Server]SQL Server Standard 支援兩個節點的容錯移轉叢集。Business Intelligence and [SQL Server]SQL Server Standard supports two-node failover clusters.

  • [SQL Server]SQL Server 服務的資源 DLL 會匯出兩個函數,可讓 WSFC 叢集管理員用來檢查 [SQL Server]SQL Server 資源的可用性。The resource DLL for the [SQL Server]SQL Server service exports two functions used by WSFC Cluster Manager to check for availability of the [SQL Server]SQL Server resource. 如需詳細資訊,請參閱 容錯移轉叢集執行個體的容錯移轉原則For more information, see Failover Policy for Failover Cluster Instances.

  • WSFC 必須能夠使用 IsAlive 檢查,驗證容錯移轉叢集執行個體是否正在執行中。WSFC must be able to verify that the failover clustered instance is running by using the IsAlive check. 這需要使用信任連接來連接到伺服器。This requires connecting to the server by using a trusted connection. 根據預設,系統不會將執行叢集服務的帳戶設定為叢集中節點上的管理員,而且 BUILTIN\Administrators 群組沒有登入 [SQL Server]SQL Server的權限。By default, the account that runs the cluster service is not configured as an administrator on nodes in the cluster, and the BUILTIN\Administrators group does not have permission to log into [SQL Server]SQL Server. 只有當您變更叢集節點上的權限時,這些設定才會變更。These settings change only if you change permissions on the cluster nodes.

  • 設定網域名稱服務 (DNS) 或 Windows 網際網路名稱服務 (WINS)。Configure Domain Name Service (DNS) or Windows Internet Name Service (WINS). DNS 伺服器或 WINS 伺服器必須要在安裝 [SQL Server]SQL Server 容錯移轉叢集的環境中執行。A DNS server or WINS server must be running in the environment where your [SQL Server]SQL Server failover cluster will be installed. [SQL Server]SQL Server 安裝程式需要 [SQL Server]SQL Server IP 介面虛擬參考的動態網域名稱服務註冊。Setup requires dynamic domain name service registration of the [SQL Server]SQL Server IP interface virtual reference. DNS 伺服器組態應該要允許叢集節點動態登錄對應至網路名稱的線上 IP 位址。DNS server configuration should allow cluster nodes to dynamically register an online IP address map to Network Name. 如果無法完成動態註冊,安裝程式會失敗,而且會回復安裝。If the dynamic registration cannot be completed, Setup fails and the installation is rolled back. 如需詳細資訊,請參閱< 此知識庫文件>(機器翻譯)。For more information, see this knowledgebase article

安裝 MicrosoftMicrosoft 分散式交易協調器Install MicrosoftMicrosoft Distributed Transaction Coordinator

在容錯移轉叢集上安裝 [SQL Server]SQL Server 之前,請判斷是否必須建立 MicrosoftMicrosoft 分散式交易協調器 (MSDTC) 叢集資源。Before installing [SQL Server]SQL Server on a failover cluster, determine whether the MicrosoftMicrosoft Distributed Transaction Coordinator (MSDTC) cluster resource must be created. 如果您只要安裝 Database EngineDatabase Engine,則不需要 MSDTC 叢集資源。If you are installing only the Database EngineDatabase Engine, the MSDTC cluster resource is not required. 如果您要安裝 Database EngineDatabase Engine 和 SSIS 或工作站元件,或是將要使用分散式交易,則必須安裝 MSDTC。If you are installing the Database EngineDatabase Engine and SSIS, Workstation Components, or if you will use distributed transactions, you must install MSDTC. 請注意,MSDTC 並非僅限 Analysis ServicesAnalysis Services執行個體的必要項目。Note that MSDTC is not required for Analysis ServicesAnalysis Services-only instances.

Windows Server 2008Windows Server 2008Windows Server 2008 R2Windows Server 2008 R2中,您可以在單一的容錯移轉叢集上安裝 MSDTC 的多個執行個體。On Windows Server 2008Windows Server 2008 and Windows Server 2008 R2Windows Server 2008 R2, you can install multiple instances of MSDTC on a single failover cluster. 第一個安裝的 MSDTC 執行個體將會是 MSDTC 的叢集預設執行個體。The first instance of MSDTC that is installed will be the cluster default instance of MSDTC. [SQL Server]SQL Server 將會透過自動使用 MSDTC 執行個體的方式,利用已安裝到 [SQL Server]SQL Server 本機叢集資源群組的 MSDTC 執行個體。will take advantage of an instance of MSDTC installed to the [SQL Server]SQL Server local cluster resource group by automatically using the instance of MSDTC. 但是,個別的應用程式可以對應到叢集上的任何 MSDTC 執行個體。However, individual applications can be mapped to any instance of MSDTC on the cluster.

下列規則會套用至由 [SQL Server]SQL Server選擇的 MSDTC 執行個體:The following rules are applied for an instance of MSDTC to be chosen by [SQL Server]SQL Server:

  • 使用已安裝到本機群組的 MSDTC,或Use MSDTC installed to the local group, else

  • 使用對應的 MSDTC 執行個體,或Use the mapped instance of MSDTC, else

  • 使用叢集的預設 MSDTC 執行個體,或Use the cluster's default instance of MSDTC, else

  • 使用安裝在本機電腦的 MSDTC 執行個體Use the local machine's installed instance of MSDTC

重要

如果已安裝至 [SQL Server]SQL Server 本機叢集群組的 MSDTC 執行個體失敗, [SQL Server]SQL Server 並不會自動嘗試使用預設叢集執行個體或本機電腦的 MSDTC 執行個體。If the MSDTC instance that is installed to the local cluster group of [SQL Server]SQL Server fails, [SQL Server]SQL Server does not automatically attempt to use the default cluster instance or the local machine instance of MSDTC. 您需要從 [SQL Server]SQL Server 群組完全移除失敗的 MSDTC 執行個體,才能使用其他的 MSDTC 執行個體。You would need to completely remove the failed instance of MSDTC from the [SQL Server]SQL Server group to use another instance of MSDTC. 同樣地,如果您建立 [SQL Server]SQL Server 的對應,而對應的 MSDTC 執行個體失敗,您的分散式交易也將失敗。Likewise, if you create a mapping for [SQL Server]SQL Server and the mapped instance of MSDTC fails, your distributed transactions will also fail. 如果您希望 [SQL Server]SQL Server 使用不同的 MSDTC 執行個體,就必須將 MSDTC 執行個體加入到 [SQL Server]SQL Server 的本機叢集群組或刪除對應。If you want [SQL Server]SQL Server to use a different instance of MSDTC, you must either add an instance of MSDTC to the local cluster group of the [SQL Server]SQL Server or delete the mapping.

設定 MicrosoftMicrosoft 分散式交易協調器Configure MicrosoftMicrosoft Distributed Transaction Coordinator

安裝作業系統並設定叢集之後,您必須使用「叢集管理員」來設定 MSDTC 以搭配叢集使用。After you install the operating system and configure your cluster, you must configure MSDTC to work in a cluster by using the Cluster Administrator. 如果無法將 MSDTC 設定為搭配叢集使用,也不會封鎖 [SQL Server]SQL Server 安裝程式,但如果沒有正確設定 MSDTC,則 [SQL Server]SQL Server 應用程式功能可能會受到影響。Failure to cluster MSDTC will not block [SQL Server]SQL Server Setup, but [SQL Server]SQL Server application functionality may be affected if MSDTC is not properly configured.

另請參閱See Also

硬體和 Software Requirements for Installing SQL Server 2014 Hardware and Software Requirements for Installing SQL Server 2014
檢查 System Configuration Checker 的參數 Check Parameters for the System Configuration Checker
容錯移轉叢集執行個體管理及維護Failover Cluster Instance Administration and Maintenance