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 |
|
haroldchen1999
Starting Member
7 Posts |
 Posted - 2009-03-26 : 21:07:25
|
| Installed SQL Server 2005 with cluster. And one of the node of MSDTC can be started, the other one can not be started. Check with the microsoft site, this issue fixed in the Windows 2003 SP2. Any suggestion or idea for it? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
haroldchen1999
Starting Member
7 Posts |
Posted - 2009-03-27 : 10:29:51
|
| Sorry, forgot to post the error. Here it is from the log:Could not Start DTC service on local computerError 1067:The process terminted unexpextedly. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-03-31 : 13:01:24
|
| BTW- In a clustered enviornment only one Node can own MSDTC resources/service. So you see it running it on one node. Are you talking about failover of MSDTC is not occuring on another node. |
|
|
|
haroldchen1999
Starting Member
7 Posts |
Posted - 2009-04-02 : 17:41:47
|
| Got it, only one MSDTC can be started at one time. Thank you |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-04-03 : 09:18:12
|
| Yes. Sir |
|
|
|
|
|
|
MSDTC not start in the cluster node