Consultants BizTalk Server disponible !

I already experienced several times the error : "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" Could any one explain to me to what this is related?

This time there was no impact, but it could have in the future?

For information purposes only, we found what was going wrong.

The BizTalk Server is not the same as the SQL Server A user belonging to the Active Directory was used by BizTalk Server to access SQL Server

Tags: user null | Error | Connection | BizTalk | Active Directory | SQL Server

Hits: 16439 | Lire la suite...

I'm trying to use enable routing for failed messages, I specify my send port with a filter on the existence of a failure code (everything is ok till here, the failed messages are correctly routed)

Then I add a filter on errors that come specifically from a receive port. And here nothing, the message is not routed and this acts as if no routing existed, when I see the context of the failed message the receive port is a promoted property !

If you look closely at your suspended Error Message (The non-resumable instance), you will see that the regular ReceivePortName (BTS.) is marked "Not Promoted", whereas the ErrorReport.ReceivePortName is. So you need to change your subscription to:
ErrorReport.ErrorType exits AND
ErrorReport.ReceivePortName = WHATEVER 

Tags: Routing | failed messages | BizTalk | Receive | Port | Error | schema

Hits: 16473 | Lire la suite...