MsDtsSrvr.ini.xml

Does anyone have a copy of this file from a clustered SQL2005 box with SSIS running? I would to see what you have. I cannot seem to get mine to work.

Thanks David

Hi, you probably already have read this, but just to make sure, the following article on clustering, steps 9-14 deal with the config file.

http://msdn2.microsoft.com/en-us/library/ms345193.aspx

If that does not help the some more info is likely needed such as, are you getting any errors? If so, then what? If not then perhaps posting the acutal contents might be good.

Hope that helps.

|||Thanks to all that replied. I have resolved this issue. I had set the registry entry (that tells SSIS where config file resides) one of my nodes on the cluster and not the other..

MSDTC on a SQL2005 failover cluster

Does MSDTC always need to be installed on a SQL failover cluster? the dev
team writing the app which will reside on the cluster say MSDTC isnt needed
as they dont use 2 phase commit or replication but I cant find anything
definitive which says the SQL failover cluster will be fine without MSDTC.
I'm coming to the conclusion it isnt needed for this install but I have to
be sure because installing MSDTC after SQL isnt recommended. I'm also
pondering on installing it anyway to be on the safe side so any advice
appreciatted
MSDTC is not required in a SQL cluster if you don't use it. But the problem
is that your app may start to use it a few months down the road without
informing you of the change in advance.
I'd always install it anyway as part of the standard. If they use it, it's
there. if they don't use it, no much is wasted.
Linchi
"Enghps1" wrote:

> Does MSDTC always need to be installed on a SQL failover cluster? the dev
> team writing the app which will reside on the cluster say MSDTC isnt needed
> as they dont use 2 phase commit or replication but I cant find anything
> definitive which says the SQL failover cluster will be fine without MSDTC.
> I'm coming to the conclusion it isnt needed for this install but I have to
> be sure because installing MSDTC after SQL isnt recommended. I'm also
> pondering on installing it anyway to be on the safe side so any advice
> appreciatted
>
>