I am getting lots of 5740 & 5743 logged in the app log of our Biztalk Server.
The adapter "SQL" raised an error message. Details "[DBNETLIB][ConnectionWrit
e (send()).]General network error. Check your network documentation.".
The adapter failed to transmit message going to send port "SQL-DeriveItemCode" with URL "SQL://1**SQL4/pepsibillin
g/". It will be retransmitted after the retry interval specified for this Send Port. Details:"[DBNETLIB][Connec
tionWrite (send()).]General network error. Check your network documentation.".
Basically the queues build up and the transactions eventually get through.
I have searched high and low and found a MS KB that I thoguth was related but ot hasn't made any difference.
Anyway it could well be our SQL box in question. The box is win2k3 Ent SP1 (SQL 2000 Ent SP4)
Any suggestions would be great.