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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment