MSDTC/SQL Server 2000/Windows Server 2003 cluster

Hi
I have to machines (SKADB01 and SKADB02) which are in a Windows 2003
Cluster. The cluster has two groups - one for Microsoft BizTalk Server
2002 and one for SQL Server 2000. The cluster is an actice/passive
cluster, and the SQL Server Group runs on one of the machines and the
BizTalk group runs on the other machine per default. If one machine
should fail, the other will take over for it.
My problem is, that BizTalk only runs if the SQL Server is running on
SKADB02. If I fail SQL Server over to SKADB01, I get errors with DTC.
"Enable Network DTC Access" is enabled on both machines, and in the
BizTalk group, there has been created an MSDTC ressource.
I do not know that much about clustering and DTC. It just seems to me,
that the errormessages point to DTC.
Does anyone have any idea?
Thanks
Jan Eliasen, representing himself and not the company he works for.
If your message is "MSDTC on server [..] is unavailable. Error 5" (access
denied) your problem may be that the MSDTC cluster resource has started after
the SQL Server Instance. This is a known problem.
"Jan Eliasen" wrote:

> Hi
> I have to machines (SKADB01 and SKADB02) which are in a Windows 2003
> Cluster. The cluster has two groups - one for Microsoft BizTalk Server
> 2002 and one for SQL Server 2000. The cluster is an actice/passive
> cluster, and the SQL Server Group runs on one of the machines and the
> BizTalk group runs on the other machine per default. If one machine
> should fail, the other will take over for it.
> My problem is, that BizTalk only runs if the SQL Server is running on
> SKADB02. If I fail SQL Server over to SKADB01, I get errors with DTC.
> "Enable Network DTC Access" is enabled on both machines, and in the
> BizTalk group, there has been created an MSDTC ressource.
> I do not know that much about clustering and DTC. It just seems to me,
> that the errormessages point to DTC.
> Does anyone have any idea?
> Thanks
> --
> Jan Eliasen, representing himself and not the company he works for.
>
|||Hi
That is not the problem I get. All my errormessages come from BizTalk,
which can not get to SQL Server sometimes.
If My BizTalk group is running on one SKADB01 and the SQL SErver group
is running on SKADB02, where should the MSDTC ressource be running?
Does it make a difference?
Jan Eliasen
On Thu, 26 Aug 2004 18:43:04 -0700, "Stephen Strong"
<StephenStrong@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>If your message is "MSDTC on server [..] is unavailable. Error 5" (access
>denied) your problem may be that the MSDTC cluster resource has started after
>the SQL Server Instance. This is a known problem.
>
>"Jan Eliasen" wrote:
Jan Eliasen, representing himself and not the company he works for.
|||MSDTC can run on any node. But Biztalk2002 is not a cluster aware
application and it is a bad idea to use Biztalk in an active/active cluster
with SQL. Biztalk is more of a group aware application. Look in to creating
a server group and addind two servers into the group if you are looking into
scaling biztalk.
"Jan Eliasen" wrote:

> Hi
> That is not the problem I get. All my errormessages come from BizTalk,
> which can not get to SQL Server sometimes.
> If My BizTalk group is running on one SKADB01 and the SQL SErver group
> is running on SKADB02, where should the MSDTC ressource be running?
> Does it make a difference?
> Jan Eliasen
>
> On Thu, 26 Aug 2004 18:43:04 -0700, "Stephen Strong"
> <StephenStrong@.discussions.microsoft.com> wrote:
>
> --
> Jan Eliasen, representing himself and not the company he works for.
>
|||Hi.
Thanks for you answer. We are running BizTalk in an active/passive
cluster - not an active/active cluster.
Jan Eliasen
On Tue, 31 Aug 2004 09:07:04 -0700, "Rony Thomas"
<rony_p_thomas@.hotmail.com> wrote:
[vbcol=seagreen]
>MSDTC can run on any node. But Biztalk2002 is not a cluster aware
>application and it is a bad idea to use Biztalk in an active/active cluster
>with SQL. Biztalk is more of a group aware application. Look in to creating
>a server group and addind two servers into the group if you are looking into
>scaling biztalk.
>"Jan Eliasen" wrote:
Jan Eliasen, representing himself and not the company he works for.
|||i just built on active-active sql cluster for biztalk servers. we have
2 biztalk servers and i plan to use each node for each biztalk server.
in case, one node is down and it can switch to another node. i set up
the DTC and move biztalks' db to the cluster. i always got error of
biztalk for the node which does have DTC.
based on your theory, it looks that my plan does not work. we don't
want group biztalk servers because one is used internally and the
other externally.
how about biztalk 2004?
thanks,
jj
On Tue, 31 Aug 2004 09:07:04 -0700, "Rony Thomas"
<rony_p_thomas@.hotmail.com> wrote:
[vbcol=seagreen]
>MSDTC can run on any node. But Biztalk2002 is not a cluster aware
>application and it is a bad idea to use Biztalk in an active/active cluster
>with SQL. Biztalk is more of a group aware application. Look in to creating
>a server group and addind two servers into the group if you are looking into
>scaling biztalk.
>"Jan Eliasen" wrote: