MSDTC with SQL Server 2000

Hi,
I have a three nodes cluster with Win 2003. On that I have four SQL
intances. MSTDC is installed on the Quorum. When a failover happens, the SQL
groups start before MSDTC and that create a problem with the transactions
after. To assure a good fonctionality I have to restart my SQL Servers (Not
Funny). I can't configure a dependencies betwen groups in Cluster
Administrators.
How can avoid a human intervention so that the services start correctly
while a failover ? I means ... to assure the service MSDTC is up before SQL
instances.
This is a known issue and fixed with Windows Server 2003 SP1. Install SP1 on
both nodes
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Psa555" <Psa555@.discussions.microsoft.com> wrote in message
news:6043A12C-0923-4389-977F-C8DCBAADCC28@.microsoft.com...
> Hi,
> I have a three nodes cluster with Win 2003. On that I have four SQL
> intances. MSTDC is installed on the Quorum. When a failover happens, the
> SQL
> groups start before MSDTC and that create a problem with the transactions
> after. To assure a good fonctionality I have to restart my SQL Servers
> (Not
> Funny). I can't configure a dependencies betwen groups in Cluster
> Administrators.
> How can avoid a human intervention so that the services start correctly
> while a failover ? I means ... to assure the service MSDTC is up before
> SQL
> instances.
>
|||Also, it is recommended to build MS DTC resource in a Cluster Group
independent from the Quorum or SQL Server Groups.
You receive error messages when you perform a distributed transaction when
you have a SQL Server 2000 virtual server in a Windows Server 2003 clustered
environment
http://support.microsoft.com/default...b;en-us;889706
How to configure Microsoft Distributed Transaction Coordinator on a Windows
Server 2003 cluster
http://support.microsoft.com/kb/301600/
Sincerely,
Anthony Thomas

"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:uEdLa7EyFHA.3812@.TK2MSFTNGP09.phx.gbl...
> This is a known issue and fixed with Windows Server 2003 SP1. Install SP1
on[vbcol=seagreen]
> both nodes
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
> "Psa555" <Psa555@.discussions.microsoft.com> wrote in message
> news:6043A12C-0923-4389-977F-C8DCBAADCC28@.microsoft.com...
the[vbcol=seagreen]
transactions
>
|||Thanks ... I read about SP1 for Win2003 and that should fix my problem.
Thanks for the hint ...
Best regard ..
"Rodney R. Fournier [MVP]" a écrit :

> This is a known issue and fixed with Windows Server 2003 SP1. Install SP1 on
> both nodes
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
> "Psa555" <Psa555@.discussions.microsoft.com> wrote in message
> news:6043A12C-0923-4389-977F-C8DCBAADCC28@.microsoft.com...
>
>
|||That's in our plan to move MSDTC on separate group ...
Thanks ...
Best regard ..
"Anthony Thomas" a écrit :

> Also, it is recommended to build MS DTC resource in a Cluster Group
> independent from the Quorum or SQL Server Groups.
> You receive error messages when you perform a distributed transaction when
> you have a SQL Server 2000 virtual server in a Windows Server 2003 clustered
> environment
> http://support.microsoft.com/default...b;en-us;889706
> How to configure Microsoft Distributed Transaction Coordinator on a Windows
> Server 2003 cluster
> http://support.microsoft.com/kb/301600/
> Sincerely,
>
> Anthony Thomas
>
> --
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:uEdLa7EyFHA.3812@.TK2MSFTNGP09.phx.gbl...
> on
> the
> transactions
>
>