Biztalk Server 2004 AND SQL adapter error

Hi, I am seenig the below error messages on the Biztalk Server Event viewer. I am not that aware the Biztalk functioning and would like to know when such errors occur:

The Biztalk server connects to SQL Server 2000 Instance mentioned below as


13h30,45s => The "SQL" adapter is suspending an outbound message going to destination URL:"SQL://Servername/InstanceName/DatabaseName/". Details:"[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. ".

13h30,45s => The Messaging Engine has suspended "1" message(s) from adapter "SQL" due to failures in message processing. Please refer to Health and Activity Tracking tool for more detailed information on this failure.

13h30,45s =>The adapter failed to transmit message going to send port "SQL://Servername/InstanceName/DatabaseName/". It will be retransmitted after the retry interval specified for this Send Port. Details:"Unspecified error".

Any help is highly appreciated!!!
more ▼

asked Oct 04, 2011 at 02:44 AM in Default

Mandar Alawani gravatar image

Mandar Alawani
376 33 38 44

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 04, 2011 at 02:44 AM

Seen: 1146 times

Last Updated: Oct 04, 2011 at 03:57 AM