# 安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 2 篇 昨天的【[安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 1 篇](/post/2010/01/17/SQL-Server-2008-Failover-Cluster-Installation-Notes-Part-1)】已經將叢集所需的基本環境建立完成，今天就要開始開始設定 Windows 叢集與架設 SQL Server 2008 容錯轉移的重頭戲了，好戲即將上場，敬請專心備戰。 **安裝與設定 Microsoft 分散式交易調節器(MSDTC)** 分散式交易調節器(DTC)是個**交易管理員**，負責處理多個不同資料來源的資料進行交易處理(ATOM)，確保跨伺服器間的各種複雜操作，像 SQL Server 就是透過 MSDTC 服務進行跨伺服器的分散式交易作業。 ![伺服器管理員 - 叢集 SQLCluster 的摘要](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/cfbe0f87adab504d1b30-image.png "伺服器管理員 - 叢集 SQLCluster 的摘要")  [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/818a06443c166bd7d3bf-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/5b2768fb213fa5b19a1f-image.png) 在安裝分散式交易協調器時必須設定另一組「**DTC 專用的電腦名稱**」以及「**DTC 專用的 IP 位址**」 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/bc72acba35da7826ec37-image.png) 昨天的文章有預先準備過一個 **MSDTC (分散式交易) 專用磁碟**給 1GB 大小的磁碟，你可以依據叢集磁碟的大小判斷出是哪一個硬碟，並選取給 MSDTC 使用。 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/5b2c0c31271004a3ca5c-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0d5faa74fd1fd687f111-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/111febca29e0483fce3c-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/a3cf3626dc7f25e2e66f-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/8adfaff3bc8ade3f013b-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/b1a4f8bcbbe65657ab39-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/3f85e6bc5c5e07eb7134-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/4cb5d8b35e48a8390550-image.png) 安裝完成之後可以點選 **SQLClusterDtc** 服務，並確認所有項目都是 **線上**(**Online**) 的狀態 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/8b85cbd134c2b4281395-image.png) 終於要正式開始安裝 SQL Server 2008 容錯轉移叢集了，但可千萬別急著開始安裝，因為 SQL Server 2008 RTM 的安裝程式有雷，直接安裝會讓你很受傷！另外，如果你是安裝在 Windows Server 2008 必須額外安裝 [Windows Installer 4.5](https://web.archive.org/web/20100503211657/http://www.microsoft.com:80/downloads/details.aspx?FamilyID=5a58b56f-60b6-4412-95b9-54d056d6f9f4&displaylang=en) 與 [.NET Framework 3.5 with Service Pack 1](http://www.microsoft.com/downloads/details.aspx?familyid=ab99342f-5d1a-413d-8319-81da479ab0d7&displaylang=en)，若是 Windows Server 2008 R2 則不用特別安裝。 **修正 SQL Server 2008 安裝程式** 由於 SQL Server 2008 RTM 版本根本無法成功架設叢集，所以必須在 **安裝之前** 完成以下步驟： 1\. [下載 SQL Server 2008 Service Pack 1 繁體中文版](https://support.microsoft.com/help/968369) 2\. 解壓縮至 **C:\\SP1** 目錄下 ``` SQLServer2008SP1-KB968369-x64-CHT /x:C:\SP1 ``` 3\. 安裝 SP1 版本的 **Microsoft SQL Server 2008 安裝程式支援檔案** ``` C:\SP1\x64\setup\1028\sqlsupport.msi ``` 4\. 從指令列啟動 SQL Server 2008 安裝程式，並加上 **/PCUSource=C:\\SP1** 參數 ``` setup.exe /PCUSource=C:\SP1 ``` 詳細步驟請參考 [How to update or slipstream an installation of SQL Server 2008](http://support.microsoft.com/kb/955392/en-us) 的說明，安裝過程如下: ![SQLServer2008SP1-KB968369-x64-CHT /x:C:\\SP1](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/ebcd705bd514fc523201-image.png "SQLServer2008SP1-KB968369-x64-CHT /x:C:\SP1") ![C:\\SP1\\x64\\setup\\1028\\sqlsupport.msi](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/6c9ef79b72cc607bfbdc-image.png "C:\SP1\x64\setup\1028\sqlsupport.msi") ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c30de25b4e4157f5fbd8-image.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/8236bd4cbf310bfb340f-image.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/a5d5daa782c27da35d47-image.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/f9caf05f442888cd68c1-image.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c4062d6b9cbf28382bab-image.png) **開始以 SQL Server 2008 with Service Pack 1 安裝 SQL Server 容錯轉移叢集服務** *備註：我的光碟機設定在 Z:\\* ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/69b4765afa587dbc7cc6-image.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/80da854608bc802f5f44-image168.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/b73cc7690fd3c0ba83e9-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/be2be62bc2840e5edf1c-image.png)  [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/b1eb2cc436e15e4a1f7f-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/a89ad009e98c787b298d-image.png)  [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/cde7b9496115ab7b20bb-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/2590840aa310bf870f93-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/6738642aa5ef32839730-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/14cb456e03cc81d126ea-image.png) 安裝的結果會出現兩個警告畫面 (就算沒問題也會出現警告，請不用太過於緊張)，但建議還是搞清楚狀況會比較好。 關於第一個警告可參考以下連結： - [當您在容錯移轉叢集中安裝 SQL Server 2008 時，您會接收**網路連結順序**，在 \[安裝程式支援的規則\] 頁面上的相關警告](http://support.microsoft.com/kb/955963) \[ [英文原文](http://support.microsoft.com/kb/955963/en-us) \] [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/cd74aa85ed4e87c2d718-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/e55d39f484ead96bda5c-image.png) 另一個 **Windows 防火牆**警告是提醒你「如果有自行修改過防火牆設定」者，可能會因為無法連接的關係而導致安裝失敗，但預設的情況下不會有防火牆阻擋的問題。若要瞭解需要設定哪些防火牆規則，可以參照此連結：[將 Windows 防火牆設定成允許 SQL Server 存取](http://msdn.microsoft.com/zh-tw/library/cc646023.aspx) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0b9572cf56968a434d23-image.png)](http://go.microsoft.com/fwlink/?LinkId=94001) 接下來請選取你要安裝的功能，以及「共用功能目錄」，這裡的目錄必須設定「本機磁碟」的路徑，不能選用「叢集磁碟」，而在之後的步驟會有機會讓你選擇「資料庫存放的路徑」，到時才會讓你選擇「叢集磁碟」。 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/2a6cdcdb7932df591b6b-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/6f244402d0e84a53a150-image.png) 接下來要設定這個 SQL Server 2008 容錯轉移叢集的主要網路名稱，日後所有 SQL 用戶端 (SQL Client) 都會以這個網路名稱連接 SQL 叢集。 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/e0cb5cef85744faea1e4-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/54a451d3e28cbce21e83-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/4f561bbb5aa4b08e2a77-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/3343b8b6d57300e9e14b-image.png) 在設定「叢集資源群組」步驟時，你可以直接使用預設的「**SQL Server (MSSQLSERVER)**」當做 **SQL Server 叢集資源群組名稱**，或可以直接手動輸入修改掉這個名稱，但唯讀下方這三個「限定」的名稱不能使用，請不要看到紅色圖示就開始害怕，只是提示你罷了。 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0244a20b9166c37a365b-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/d729e56dddaa78ba3b5f-image.png) 接下來就要選取要再 SQL Server 資源叢集群組中的共用磁碟，我們將目前剩下的兩個叢集磁碟都選取起來，這些設定在日後還是可以變更。 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/4dc325a59912cf2369b8-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/ab3a0220e3dc716d23cb-image.png) 設定「叢集網路」所需的組態設定，包括 **SQL 叢集** 對外的固定 IP ( 記得將DHCP欄位的勾選先移除 )，然後設定固定的 **IP 位址**以及**子網路遮罩**(Netmask)。 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/e03adaabc4bbdff04ee7-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/2da84a2a84384e566939-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/865664ef59f40c77a8fb-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/dfd01d8dfb376b4aadd8-image.png) 在「伺服器組態」的地方我們要將所有服務設定成一個 AD 使用者帳號，讓兩台叢集伺服器都擁有一樣的權限，所以我們先在 AD 中建立一個 **SQLService** 使用者： ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/e7366fb9ce4aba0b39d2-image.png) 然後將新增的使用者帳戶密碼輸入此頁 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/3191899b8a4c309fb921-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/fb8988869c2ee9382f7c-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/46751af783eadb3e337a-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/92b7191e2fb2dd54d7ba-image.png) 由於我們已經在先前幾步指派了「叢集磁碟」，所以在這個步驟的「資料目錄」頁籤可以讓你設定預設的**資料資料庫**所在目錄，預設路徑會以剛剛選取的「第一顆叢集磁碟」作為儲存路徑。 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/060af267718ee6fb9cba-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/2a955eee41a22f12c287-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/8e3fd9d143a51125739c-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/1d85ed9f03df9319e234-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0034b56b7353b00e5e79-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/5e4cb43987f2fb656d0e-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/881f17829088cc492383-image.png) 如果你**安裝程式**沒有事先修改以 Service Pack 1 的版本安裝的話就會遇到以下這個錯誤畫面： ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/183533461c88f7fddbd4-image.png) 如果你乖乖的一步一步走應該可以順利安裝成功 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/b6d2f3d205a34e431581-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/af62b3709e38f83ac6e1-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/dfd48e5bd2496a0c6334-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/041989355a9669ffa28c-image.png) 安裝成功後，可以進入**伺服器管理員**查看叢集服務是否運作正常，但我發現我昨天安裝的 MSDTC 服務竟然失敗了： ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/1c670fa226ba2112b631-image.png) 再進一步查看發現 MSDTC 服務的「目前擁有者」變成 SQL-2 了，而且也無法將該服務上線，這時我先手動將此服務移動到 SQL-1 節點，然後就可以上線了。 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/85ae9f141576247e4d35-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/ad14fadcd8eb4e37d42d-image.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/bae1776b0c6f8b1638a5-image.png) 接著我們也再次檢查 “**SQL Server (MSSQLSERVER)**” 服務的狀態是否一且正常：  ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/1457f05931518ca7050e-image.png) 呼～ 費勁千辛萬苦終於才把**第一台** SQL Server 2008 容錯轉移叢集主機架設好了，但由於篇幅已經很大了，所以剩下的步驟還是留個第 3 篇明日在述！ **相關連結** - [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) **之前遇到安裝失敗的問題與解答相關連結** - [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 with SP1 整合光碟；匯集(Slipstreaming)安裝](http://sharedderrick.blogspot.com/2010/01/sql-server-2008-with-sp1-slipstreaming.html) **完整安裝 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)