SSO issue BizTalk

In this BizTalk setup I had a separate BizTalk Server and SQL Server. The SSO feature was installed on the SQL Server. I received the following issues in BizTalk: Could not contact SSO Server SQL. Check that SSO is configured and that the SSO service is running on that server. Additional information: The RPC server…

Restore master secret key

Restoring the master secret key is no rocket science, you just have to make sure you do things right, otherwise your BizTalk environment will be corrupted. In the scenario at hand, I had a BizTalk environment with a separate BizTalk Server and a separate SQL Server. The BizTalk SSO feature is installed on SQL Server….

BizTalk service with WS-Security

To create a WCF Receive Location with WS-Security (messagesecurity with clientcredentialtype=”UserName”), you must first use the WCF Publishing Wizard. The WCF Publishing Wizard creates a WCF service in IIS. This WCF service has minimal configuration. That’s because the WCF service is coupled to a WCF receive location. In the WCF receive location the configuration is…

Alerting in BizTalk

Suppose you don’t use BizTalk360 and you want a send a mail every time an error occurs. In that case, you can create an orchestration. The orchestration starts with an activating receive. The message received is of type Microsoft.Practices.ESB.ExceptionHandling.Schemas.Faults.FaultMessage. The activating receive uses the following filter: ErrorReport.FailureCode Exists Or Microsoft.Practices.ESB.ExceptionHandling.Schemas.Property.FaultCode Exists The next step is…

BizTalk CAT

The BizTalk CAT Instrumentation Framework is a high performance tracing/logging framework for BizTalk that builds upon the Event Tracing for Windows (ETW) infrastructure. The Controller is designed for use both on development machines and production servers. Compared to System.Diagnostic.Trace, Enterprise Library Tracing or Log4Net, CAT has a negligible impact on performance. To use the BizTalk CAT…

BizTalk 2016 and SQL Server AlwaysOn

Below description is a summary of: High Availability using SQL Server Always On Availability Groups. Traditionally, BizTalk uses SQL Server Failover Clustering and Log Shipping to provide high availability, backup and restore, and disaster recovery for its on-premises databases. In Azure IaaS (Azure virtual machines), previous versions of SQL Server do not support Failover Cluster Instances…

WCF-WebHttp adapter in BizTalk

Configuring a WCF-WebHttp send port for calling a REST service in BizTalk is pretty straight-forward. On the General tab specifiy a base URL and a BtsHttpUrlMapping. For instance: Base URL: https://service.local:8443 <BtsHttpUrlMapping> <Operation Method=”PUT” Url=”/api/Contact/{UID}” /> </BtsHttpUrlMapping> In this case the URL contains a variable which can be specified via the variable mapping. Note that…

Use ESB Exception Handling Only

Most of the time, you only want to use the exception handling functionality of the ESB Toolkit. In that case you can include the necessary artefacts in a BizTalk.Framework application. You will still have to create the ESB Exception database via the ESB Configuration Tool first. Next, in case you use the BizTalk Deployment Framework…