Overview
My favorite articles on clustering mention setting up the MSDTC resource but not in detail. If you have requested the resources, I recommend using a separate Group for MSDTC (and with 2008 clustering you will not be able to add it to the quorum group). Make sure you set this up before launching the SQL Server Installation for your Windows 2003 and SQL 2005 Cluster. I expect this will be one of the last view blog entries I have about clustering that concern these old outdated versions ;) but we will see.
(http://www.sql-server-performance.com/articles/clustering/cluster_server_2003_p1.aspx – To setup the Windows 2003 Cluster and http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx – To setup the SQL 2005 Cluster)
MSDTC Steps:
Before installing SQL you need to setup a clustered instance of MSDTC. To do this you will need to:
1. Create a new Group called MSDTC (and the name doesn’t matter, you could call it Bob)
2. Add Resources to the Group. For MSDTC you will need a Disk Resource, a Network Name, a Network IP address. Once these are added you can setup the Distributed Transaction Coordinator resource.
The end result should look like this:
0 comments:
Post a Comment