December 14, 2009 at 11:54 am
Hi,
We have Monitoring A/A/P clustered SQL Server instances. I have noticed that DTC is running on only one Active node1. It's NOT running on Active node2 and Passive node3. Is this Normal behavior ?
Thanks
December 14, 2009 at 12:39 pm
What version of SQL and OS are you running?
When you installed DTC, what was your procedure?
Where do you see that DTC is running/not running (Service control panel or Cluster Administrator)?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2009 at 12:49 pm
What version of SQL and OS are you running?
SQL server 2005 EE x64 with SP4 on Windows 2003 R2 EE x64 with SP2
When you installed DTC, what was your procedure?
The system admin installed DTC, when he configured Windows cluster setup, 3 node. I have just enabled all remote connection from Administrative Tools-> Component Services->My computer->Right Click-> MSDTC->Secutiry->Enable remote connections
Where do you see that DTC is running/not running (Service control panel or Cluster Administrator)?
In Service control panel.
In cluster Administrator, the MSDTC group is running on Active node1. I can move this MSDTC group in cluster administrator to any node and it's running from whatever node I move.
Many thanks
December 14, 2009 at 1:14 pm
It seems similar to this other thread.
Specifically look into xp_servicecontrol
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply