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

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 (AT) discussions (DOT) 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 (AT) hotmail (DOT) com> 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 (AT) hotmail (DOT) com> wrote: