Hi!

I have a receive location that gets disabled every other day and there is no activity on this receive location, it is polling sql using WCF SQL adapter. Any clue why I'm getting this error?

The receive location "Rcv-WCF-SQL" with URL "mssql://SQLDEV//Tran?InboundId=TranPoll" is shutting down. Details:"System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) ---> System.ComponentModel.Win32Exception (0x80004005): The semaphore timeout period has expired

Hi Chris,

The semaphore timeout period has expired.

Are you using SQL Database and is it installed on different server ?

This issue occurs when not able to access the SQL Server. Please test distributed transactions across firewalls or against networks and use this tool for help.

DTCPing.exe

This tool helps to test distributed transactions across firewalls or against networks.

Hi,

True!! 

This error occurs when there is some issue with the connectivity between SQL Server and BizTalk Server. You can check some of the things like:

• Your network Configuration and if something is not correct.
• All the required Inbound and Outbound ports are opened up between the 2 servers.

Check these links:

High Performing BizTalk Server 2009 /BizTalk Server 2010 Server Setup

Troubleshooting SQL connectivity issues

Rahul

• Marked as answer by Chris7887 16 hours 40 minutes ago

Hi,

True!! 

This error occurs when there is some issue with the connectivity between SQL Server and BizTalk Server. You can check some of the things like:

• Your network Configuration and if something is not correct.
• All the required Inbound and Outbound ports are opened up between the 2 servers.

Check these links:

High Performing BizTalk Server 2009 /BizTalk Server 2010 Server Setup

Troubleshooting SQL connectivity issues

Rahul

• Marked as answer by Chris7887 Friday, September 11, 2015 2:20 PM

Hi,

True!! 

This error occurs when there is some issue with the connectivity between SQL Server and BizTalk Server. You can check some of the things like:

• Your network Configuration and if something is not correct.
• All the required Inbound and Outbound ports are opened up between the 2 servers.

Check these links:

High Performing BizTalk Server 2009 /BizTalk Server 2010 Server Setup

Troubleshooting SQL connectivity issues

Rahul

• Marked as answer by Chris7887 Friday, September 11, 2015 2:20 PM