March 29, 2011 at 12:46 pm
Thanks, Perry, but MSDTC is running as a clustered resource (I thought I mentioned that in my first post, but upon re-reading, I apparently phrased the sentence in vague terms). It's just started failing in the past month and not coming back up properly.
We're not sure if something external is triggering the failure or if it's the MSDTC failure that's triggering the cluster failover. That's what we're trying to determine.
March 29, 2011 at 12:49 pm
Brandie Tarvin (3/29/2011)
but MSDTC is running as a clustered resource
yes but the MSDTC group is only active on the one node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 1:36 pm
Did you try dtcping and dtctester?
Did someone alter DNS settings, firewall stuff ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 30, 2011 at 5:47 am
ALZDBA (3/29/2011)
Did you try dtcping and dtctester?
Hadn't heard of those tools until you told me about them. I'll check into them. Thanks for the link.
Did someone alter DNS settings, firewall stuff ?
I doubt it. If they had, would the cluster even work after failover? I know our local admin haven't done anything. I'll check with our corporate office to see if they did something without telling us.
Given some interesting information that came to light last night, though, the cluster issue might not be the MSDTC service after all. But until we verify, I'm still considering MSDTC suspect.
March 30, 2011 at 6:03 am
Perry,
I appreciate the help you're trying to give me, but you're giving advice based on incorrect assumptions about my setup. This might be because I'm not stating it correctly. So, because you're working from a SQL (and possibly Windows) 2008 perspective, let me give you this quote and article link from MRDenny which explains my setup much better than I am able to.
MRDenny's Article
When configuring DTC on a cluster you only need to configure one node. This is because DTC is a cluster aware service so when you install DTC after setup clustering (or you setup clustering after installing DTC) the DTC service will already be setup as a clustered resource within the first cluster resource group created.
The bold and underline is my emphasis, not his.
Link: http://itknowledgeexchange.techtarget.com/sql-server/how-to-configure-dtc-on-windows-2003/%5B/url%5D
March 30, 2011 at 11:09 am
good feedback.
I ran across mrdennys article last night, but had quit a busy day today.
It's good you posted the ref for later forum users.
mrdenny is very frequent on Twitter ( @mrdenny ), so that may be one way to call on him for assistance. 😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 31, 2011 at 11:27 am
Brandie Tarvin (3/30/2011)
Perry,I appreciate the help you're trying to give me, but you're giving advice based on incorrect assumptions about my setup. This might be because I'm not stating it correctly. So, because you're working from a SQL (and possibly Windows) 2008 perspective, let me give you this quote and article link from MRDenny which explains my setup much better than I am able to.
MRDenny's Article
When configuring DTC on a cluster you only need to configure one node. This is because DTC is a cluster aware service so when you install DTC after setup clustering (or you setup clustering after installing DTC) the DTC service will already be setup as a clustered resource within the first cluster resource group created.The bold and underline is my emphasis, not his.
Link: http://itknowledgeexchange.techtarget.com/sql-server/how-to-configure-dtc-on-windows-2003/%5B/url%5D
I know exactly what you mean and i have read that article before. The attached pic shows my example
SQL Server cluster node 1
Active named sql server instance SQLCLUST01\INST1
Active instance of clustered MSDTC
SQL Server cluster node 2
Active default sql server instance SQLCLUST00
SQLCLUST00 has no active clustered MSDTC resource on the same node (shown in the image attached) as you can only have 1 clustered MSDTC application within a Windows 2003 cluster. SQLCLUST00 shows distributed transaction coordinator stopped.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply