Biztalk 2006 MSDTC Possible Issue

[Hajin Studio Group]

OS Windows 2003 64bit SP1, SQL Server 2005 SP1, BizTalk 2006

Over the past few days an error occurs which requires me to restart the
database server which sits on a separate host to allow BizTalk Components to
function correctly.

In error state:
From within the Biztalk Administrator if you refresh the group hub, it
errors out with a SQL connection error
From within the Biztalk Configuration Tool if you select Group you get a
data not available error.

This all seems to point to the DB connectivity issue as the error log below
details. My question is the closets thing I can track this do is possible
problems with MSDTC, and I have gone over the stpes in a article I found -
http://msdn2.microsoft.com/en-us/library/aa561924.aspx

Looking for a root cause. Does anyone have any experience with this type of
problem?

A failure occurred when executing a Windows service request.

Service request: Start

BizTalk host name: BizTalkServerApplication
Windows service name: BTSSvc$BizTalkServerApplication

Additional error information:
Error code: 0xc0c0153f
Error source: BizTalk Server 2006
Error description: A failure occurred when connecting to the BizTalk
management database BizTalkMgmtDb.
Please verify the Windows account used by the BizTalk host instance belongs
to a Windows group configured for the host BizTalk Group.

Additional error information:
Error code: 0xc0c01b3d
Error source:
Error description: A database failure occurred due to database connectivity
problems.

[Jan Eliasen]

On Wed, 10 Oct 2007 13:49:04 -0700, Hajin Studio Group
<HajinStu...@discussions.microsoft.com> wrote:

>This all seems to point to the DB connectivity issue as the error log below
>details. My question is the closets thing I can track this do is possible
>problems with MSDTC, and I have gone over the stpes in a article I found -
>http://msdn2.microsoft.com/en-us/library/aa561924.aspx

Did you also run the dtctester tool that is mentioned in the article?

--
eliasen, representing himself and not the company he works for.

Private blog: http://blog.eliasen.dk

Private email: j...@eliasen.dk

[Hajin Studio Group]

I have not, I plan to run tonight, but the issue we seem to have is
everything is working now after a reboot of the DB server (just restarting
the db does nothing) so I feel the only good results I will get from these
types of tests are when I am in a failed state which over the last few days
just comes and goes. Thanks for the reply.

[Hajin Studio Group]

I had the event several times and once I was able to access the server while
e in the error condition I got more info.

I ran the DTCtester tool, and got an error but bigger then that I
encountered and condition where I could access the DB server using RDP, but
from within the server I could not reach any other server. Seems like a
networking problem,

The browser service was unable to retrieve a list of servers from the
browser master \\MSRAPDC on the network \Device\NetBT_Tcpip

Why I can't explain how I can get to the host via RDP but can't even ping
out or access a file share from the host this explains to me why a reboot
fixes the issue.

For now I disabled the 2nd network card as some events point to this, the
error has not occurred in 48 hours, previously it happened every 12 hours, I
will allow a little more time to see status.

[Hajin Studio Group]