?
Solved

Is MSDTC problems creating issues with Biztalk connecting to the database

Posted on 2007-10-10
7
Medium Priority
?
1,810 Views
Last Modified: 2013-11-30
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, but I am cautions to start making changing based just on a article I found - http://msdn2.microsoft.com/en-us/library/aa561924.aspx when I dont have a better handle on the actual 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.  
0
Comment
Question by:HajinStudioGroup
  • 4
6 Comments
 

Author Comment

by:HajinStudioGroup
ID: 20080565
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.
0
 
LVL 2

Expert Comment

by:snidenik
ID: 20109356
I faced this problem several times workaround is go to SQL SErver
Management --> Processes, kill the Windows NT \System process ..This process will be in the Suspended state. This process creates locks You need to kill all the suspended process for Windows NT. Once this is done your problem will be solved.

I believe this happened bcos BizTalk MAnagement Databases looses name of SQL server it is hosting on. you can restore the name of server by doing following

use master  go  select * from sysservers  go      
 
2. Identify the name of the local server in the list. If the name exists, and the server id is anything other than 0, run the following statement and replace "yourservername" with the name of the local server:
sp_dropserver 'yourservername','droplogins'      
If a non-local server has a server id value of 0, then you need to drop that entry and run the sp_dropserver stored procedure.
 
3. Add the local server back to the list by running this code:
sp_addserver 'localservername', 'local'
 
0
 

Author Comment

by:HajinStudioGroup
ID: 20109496
I will look into this right away.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:HajinStudioGroup
ID: 20109788
The server ID seems to be correct as the local host has a value of 0. I am going on 72 hours without a reoccurrence, this is after I disabled SQLSafe a backup tool. This was the first time I saw the issue go away without a reboot. Other SQL servers have the same backup tool with no problems.

Not that I want to see it come back, but if it does I will just the SQL processes to see if this corrects the issue without a reboot. Thanks for the reply.
0
 

Author Comment

by:HajinStudioGroup
ID: 20150046
Just to update this some...

My testing has shown that this problem is most likely related to the SQL Safe product we have on the DB server. In the error state if I disable the service the problem goes away. When I have this service disabled I have gone 72 hours without the problem and it only occurs when the service is on.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22504768
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question