DTC in multiple instance cluster

WE have a 2 node win 2k3 x64 cluster (also x86 clusters with same problem)
with 2 instanses of SQL 2005 x64 and the MSDTC resource in the admin.
cluster group (quorum group).
This is a active/passive cluster, all 3 groups/vir. servers on same node.
The problem appears when one of the SQL servers fail over to the other node.
Then the MSDTC transactions fail on this sql server.
Result = we have to manually fail over the MSDTC resource/group also.
I have read about a DTC proxy but how do I get this to work ?
Bj?rn
Some say that this shouldn't happen, but we experienced this often as well.
The fix is to place the MS DTC in its own cluster resource group, which will
require another set of dedicated IP Addresses, physical disk, and network
name resources.
http://support.microsoft.com/kb/301600/en-us
Sincerely,
Anthony Thomas

"Bjrn" <Bjrn@.discussions.microsoft.com> wrote in message
news:251D1C52-C076-40A0-BE2B-2B5EF4031146@.microsoft.com...
> WE have a 2 node win 2k3 x64 cluster (also x86 clusters with same problem)
> with 2 instanses of SQL 2005 x64 and the MSDTC resource in the admin.
> cluster group (quorum group).
> This is a active/passive cluster, all 3 groups/vir. servers on same node.
> The problem appears when one of the SQL servers fail over to the other
node.
> Then the MSDTC transactions fail on this sql server.
> Result = we have to manually fail over the MSDTC resource/group also.
> I have read about a DTC proxy but how do I get this to work ?
> Bjrn
>

DTC & SQL Server in cluster

Hi friends,
One simple and maybe silly question. Is DTC cluster resource a necessary
prerequisite for SQL Server to operate in cluster environment? If so, why?
And it'd be great if anyone can direct me to any resource about DTC
internals. Not just setup & configuration but how it works on low level.
Thanks in advance.
Falconer
Hi
"Falconer" wrote:

> Hi friends,
> One simple and maybe silly question. Is DTC cluster resource a necessary
> prerequisite for SQL Server to operate in cluster environment? If so, why?
> And it'd be great if anyone can direct me to any resource about DTC
> internals. Not just setup & configuration but how it works on low level.
> Thanks in advance.
> Falconer
If you are using distributed transactions on the virtual server you are
required to install a clustered resource.
http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best links
seem to be at
http://msdn2.microsoft.com/en-us/library/ms687102.aspx
John
|||Thanks a lot John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5011A242-9AAD-4663-B1B5-2DF8EC6C5F84@.microsoft.com...
> Hi
> "Falconer" wrote:
>
> If you are using distributed transactions on the virtual server you are
> required to install a clustered resource.
> http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best
> links
> seem to be at
> http://msdn2.microsoft.com/en-us/library/ms687102.aspx
> John

DTC & SQL Server in cluster

Hi friends,
One simple and maybe silly question. Is DTC cluster resource a necessary
prerequisite for SQL Server to operate in cluster environment? If so, why?
And it'd be great if anyone can direct me to any resource about DTC
internals. Not just setup & configuration but how it works on low level.
Thanks in advance.
FalconerHi
"Falconer" wrote:
> Hi friends,
> One simple and maybe silly question. Is DTC cluster resource a necessary
> prerequisite for SQL Server to operate in cluster environment? If so, why?
> And it'd be great if anyone can direct me to any resource about DTC
> internals. Not just setup & configuration but how it works on low level.
> Thanks in advance.
> Falconer
If you are using distributed transactions on the virtual server you are
required to install a clustered resource.
http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best links
seem to be at
http://msdn2.microsoft.com/en-us/library/ms687102.aspx
John|||Thanks a lot John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5011A242-9AAD-4663-B1B5-2DF8EC6C5F84@.microsoft.com...
> Hi
> "Falconer" wrote:
>> Hi friends,
>> One simple and maybe silly question. Is DTC cluster resource a necessary
>> prerequisite for SQL Server to operate in cluster environment? If so,
>> why?
>> And it'd be great if anyone can direct me to any resource about DTC
>> internals. Not just setup & configuration but how it works on low level.
>> Thanks in advance.
>> Falconer
> If you are using distributed transactions on the virtual server you are
> required to install a clustered resource.
> http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best
> links
> seem to be at
> http://msdn2.microsoft.com/en-us/library/ms687102.aspx
> John

DTC & SQL Server in cluster

Hi friends,
One simple and maybe silly question. Is DTC cluster resource a necessary
prerequisite for SQL Server to operate in cluster environment? If so, why?
And it'd be great if anyone can direct me to any resource about DTC
internals. Not just setup & configuration but how it works on low level.
Thanks in advance.
FalconerHi
"Falconer" wrote:

> Hi friends,
> One simple and maybe silly question. Is DTC cluster resource a necessary
> prerequisite for SQL Server to operate in cluster environment? If so, why?
> And it'd be great if anyone can direct me to any resource about DTC
> internals. Not just setup & configuration but how it works on low level.
> Thanks in advance.
> Falconer
If you are using distributed transactions on the virtual server you are
required to install a clustered resource.
http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best link
s
seem to be at
http://msdn2.microsoft.com/en-us/library/ms687102.aspx
John|||Thanks a lot John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5011A242-9AAD-4663-B1B5-2DF8EC6C5F84@.microsoft.com...
> Hi
> "Falconer" wrote:
>
> If you are using distributed transactions on the virtual server you are
> required to install a clustered resource.
> http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best
> links
> seem to be at
> http://msdn2.microsoft.com/en-us/library/ms687102.aspx
> John