# 安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 3 篇 (完) 暨【[安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 1 篇](/post/2010/01/17/SQL-Server-2008-Failover-Cluster-Installation-Notes-Part-1)】與【[安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 2 篇](/post/2010/01/18/SQL-Server-2008-Failover-Cluster-Installation-Notes-Part-2)】之後，今天將是完結篇的時候，我們要把**第二台** SQL Server 2008 叢集主機設定完成，以達成 **高可用性**(High Availability; HA) 的目的。 **安裝設定第二台叢集主機 SQL-2** 跟[昨天的文章](/post/2010/01/18/SQL-Server-2008-Failover-Cluster-Installation-Notes-Part-2)一樣需修正 SQL Server 2008 RTM 的安裝程式支援檔案到 Service Pack 1 的版本，然後執行 setup.exe /PCUSource=C:\\SP1 進行安裝。 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/d77ad1c4f6accee5a553-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/7db8212533b0cd70b77b-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c26c771bc8d6549adb75-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/2b01e80da9a14b89c10b-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/65226e4c9e1ce5733f02-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/f14e53e31665a864be3f-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/fd103c3a07d65acca0df-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/4e01d103dc20a2641ad8-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/95a2cd6744142467dadb-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/630ffe1e833b7ae086db-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/61d4c6da4279bf0dbb78-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/9caa19aabeccf5fd2523-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/fd089835a2717ffdd994-image.png) 確認這時設定的帳戶名稱與你第一台叢集電腦安裝的帳戶權限是否一致，像我就發現我的 **SQL Server Integration Service 10.0** 的帳戶被改變了，但是並無法手動修改，另外兩個帳戶名稱也無法修改，這時你必須輸入相同的密碼才行： [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/256d137a31c357c1f2ca-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/ca0483ff27b2fad9f08f-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/f8cbd95b36f1b17c4980-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/ad8c8e63050a1e49df6c-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/2eb44f33104aa4b9c144-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/d2129742d01dc183bb94-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/9307579a4b4687d3ed2c-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/d0ef59c2c857c4b2a390-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/15c103bbfa110274d50d-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/78e840fbbd99b130365d-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/e382113d041903f18bf0-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/3993b315a10bdafd3286-image.png) 大功告成啦！我們可以看一下第二台叢集節點的 “**SQL Server (MSSQLSERVER)**” 服務的狀態是否一切正常： [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/81c1a780c7d795b98864-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c4b66681eb6e15a9285d-image.png) 我想我這一系列安裝步驟是目前中文語系最完整的逐步安裝指南，我大概裝了 4 次才完全安裝成功，真不是普通的複雜，當中還有許多 Know How 等著被釐清與建立，但光是安裝經驗就讓我多學到很多東西，正所謂「失敗為成功之母」，第一次就安裝成功是學不到東西的，在此僅向用心良苦的微軟至上深深的一鞠躬。XD **相關連結** - [Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 1](http://www.mssqltips.com/tip.asp?tip=1687) - [Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2](http://www.mssqltips.com/tip.asp?tip=1698) - [Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 3](http://www.mssqltips.com/tip.asp?tip=1709) - [Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4](http://www.mssqltips.com/tip.asp?tip=1721) - [Understanding why there is still downtime with Microsoft Clustering](http://www.mssqltips.com/tip.asp?tip=1882) - [SQL Server 2008 容錯移轉叢集使用者入門](http://msdn.microsoft.com/zh-tw/library/ms189134.aspx) - [You receive a warning about the network binding order on the Setup Support Rules page when you install SQL Server 2008 in a failover cluster](http://support.microsoft.com/kb/955963/en-us) - [The MS DTC resource does not come online on a Windows Server 2008-based computer](https://web.archive.org/web/20130512170027/http://support.microsoft.com/kb/947297/en-us) - [How to use Kerberos authentication in SQL Server](https://web.archive.org/web/20091130210017/http://support.microsoft.com:80/kb/319723) **之前遇到安裝失敗的問題與解答相關連結** - [How to resolve RequireKerberos value problem in sql 2008 failover cluster...](http://www.sqlservercentral.com/Forums/Topic723728-391-1.aspx) - [Failover Cluster installation fails (SQLServer 2008)](http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/6ccf9380-852d-4b59-b128-97e0e870452c) - [How to update or slipstream an installation of SQL Server 2008](http://support.microsoft.com/kb/955392/en-us) - [SQL Server 2008 Slipstream Frequently Asked Questions](http://blogs.msdn.com/petersad/archive/2009/04/24/sql-server-2008-slipstream-frequently-asked-questions.aspx) - [SQL Server 2008, basic slipstream steps](http://blogs.msdn.com/petersad/archive/2009/03/02/sql-server-2008-basic-slipstream-steps.aspx) - [Creating a merged (slipstreamed) drop containing SQL Server 2008 RTM + Service Pack 1](http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx) - [SQL Server 2008 failover cluster rolling patch and service pack process](http://support.microsoft.com/kb/958734/en-us) **完整安裝 SQL Server 2008 容錯轉移叢集的步驟文章** - [安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 1 篇](/post/2010/01/17/SQL-Server-2008-Failover-Cluster-Installation-Notes-Part-1) - [安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 2 篇](/post/2010/01/18/SQL-Server-2008-Failover-Cluster-Installation-Notes-Part-2) - [安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 3 篇 (完)](/post/2010/01/19/SQL-Server-2008-Failover-Cluster-Installation-Notes-Part-3) **其他相關連結** - [Setting up a Two-node SQL Server 2008 Cluster from the Command Prompt – Preparation](http://www.databasejournal.com/features/mssql/article.php/3771296/Setting-up-a-Two-node-SQL-Server-2008-Cluster-from-the-Command-Prompt---Preparation.htm) - [Setting up a Two-NODE SQL Server 2008 Cluster from the Command Prompt - Integrated Installation](http://www.databasejournal.com/features/mssql/article.php/3772826/Setting-up-a-Two-NODE-SQL-Server-2008-Cluster-from-the-Command-Prompt---Integrated-Installation.htm) - [Installing a Two-node SQL Server 2008 Cluster - Advanced option](http://www.databasejournal.com/features/mssql/article.php/3783326/Installing-a-Two-node-SQL-Server-2008-Cluster---Advanced-option.htm) - Windows 2008 Failover Clustering: Configuring SQL 2008 for Failover Clustering - Part 1 of 3