Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saurabhsrivastava
Posting Yak Master
216 Posts |
 Posted - 2009-03-18 : 18:42:21
|
| I'm congifuring a Windows 2003 SP2 32-Bit cluster using Virtual server 2005 (virtual server cluster). I can move other resources to Node 2 except MSDTC. When I start move group for MSDTC it moves IP address but fails to move other resources and comes back to Node1. 1) I don't see MSDTC log file in MSDTC folder for Node2. 2) I tried reset log on Node 2, it fails to start MSDTC. 3) Refered several MSDTC KB articles and forums, nothing worked. I don't know WHY this happening. If you have seen similar issue let me know how you fixed it. |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-03-23 : 17:22:04
|
| I fixed it. This post is closed now. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-04-01 : 09:47:31
|
| While configuring MSDTC sequence of steps is very important. 1) Configure MSDTC IP2) Configure MSDTC Network name3) COnfigure MSDTC Disk4) Configure MSDTC resource5)Take offline all the above6) Install "Network DTC access" on all nodes. 7) Reset MSDTC log (if required)Important stuff not related to MSDTC: When one install SQL Server 2008 Cluster on Windows 2003 hotfix KB937444 is required or it throws FILESTREAM error. Its odd because I'm not using it and not going to use it for this application but this hotfix is mandatory no matter what. Fix for mount point is included in this hotfix if one is planning to use mount point they are covered. |
|
|
|
|
|
|
MSDTC resource isn't moving to other node