BizTalk and “Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.”

Error Microsoft.ServiceModel.Channels.Common.ConnectionException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. —> System.Data.SqlClient.SqlException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. The user was correct, and that was driving me crazy. I had just built the database from a script, […]

SQL to XREF all BizTalk Maps on all Send and Receive Ports

Suppose you want to find if a map is used on some ReceivePort. In BizTalk, one Receive Port can contain multiple maps. The one that is executed is based on the matching target namespace and root element. <pre> select app.nvcName as ApplicationName,        rp.nvcName as ReceivePortName,        it.Name as MapName,        it.FullName,   — you might […]

XREF a BizTalk BTS.Operation back to the Orchestration Operation Name

Today, I saw a send port that had a filter such as BTS.Operation == Send204External. I looked at the orchestrations that I thought were involved in this application/project, but couldn’t find that operation name in any of the orchestration send ports. There are two approaches to doing the xref: 1) Scanning all the code. I […]

SQL Command to List BizTalk Receive/Port Locations (and Addresses) by Application

The query below shows how to join the BizTalk Receive Port and Receive Location, along with the Application Name. <pre> select app.nvcName,        rp.nvcName as ReceivePort,        bTwoWay,        rl.Name as ReceiveLocation,        InboundTransportURL,        ReceivePipelineData   from bts_receiveport rp inner join adm_ReceiveLocation rl on rl.ReceivePortId = rp.nID inner join bts_application app on rp.nApplicationID = app.nID […]

SQL command to list BizTalk send ports by application

I’ve been doing a lot of reverse engineering and studying of old systems as we migrate them to new releases of BizTalk. I find myself constantly using SQL command to narrow down the ports I’m interested in… By joining to the bts_sendport_transport table, we are able to show the address (for example, disk/file directory name, […]

Matching RabbitMQ RoutingKey from BizTalk Send/Receive Ports

We have our own RabbitMQ adapter. The addresses look like the following. Send Port Receive Location What I wanted to do is match which Receive Ports subscribe to RabbitMQ RoutingKeys from other Send Ports. In other words, when I send out a message from one orchestration (send port), which orchestration (or Receive Port) […]

How to get properly formatted fully qualified assembly name

Sometimes you need the full assembly name, properly formatted to use for various reasons (such as a WCF Custom Behavior file that is imported into BizTalk adapter). Here are a couple of ways to get it: DOS Comamnd Window (GacUtil /L) C:\Windows\system32>gacutil /l | find "bLogical"   bLogical.BizTalk.RESTBehavior, Version=, Culture=neutral, PublicKeyToke n=8b7f8ad23140b57b, processorArchitecture=MSIL   bLogical.RESTSchemas, Version=, Culture=neutral, […]

Recent Posts




All Rights Reserved Theme by 404 THEME.