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….

Reconfigure BizTalk

Let’s say you have a configured BizTalk Server in development with a few applications running and various custom host instances. Let’s say you configured BizTalk using a local admin account and instead you wanna configure BizTalk with a domain admin account. Enterprise SSO and all BizTalk host instances have to be running under the domain…

Custom Functoid: SSOConfigReader

Yet another example that can be useful. A custom functoid to read configuration data from SSO. using System; using System.Reflection; using Microsoft.BizTalk.BaseFunctoids; namespace Rfs.Integration.BizTalk.Library.Functoids { public class SSOConfigReader : BaseFunctoid { public SSOConfigReader() : base() { this.ID = Constants.SSOConfigReader; // set up the resource assembly to our own assembly SetupResourceAssembly(Constants.functoidsResourcesPath, Assembly.GetExecutingAssembly()); SetName(“SSOCONFIGREADER_NAME”); SetTooltip(“SSOCONFIGREADER_TOOLTIP”); SetDescription(“SSOCONFIGREADER_DESCRIPTION”); SetBitmap(“SSOCONFIGREADER_BITMAP”);…

Configuration Settings in SSO – Part 2

This information was copied from Link. Once you’ve added a setting to the Excel settings spreadsheet, it’s readily accessible to your BizTalk application at runtime. To read a setting value at runtime from maps, orchestrations, pipeline components or .NET code: 1. Complete the steps outlined in Configuration Settings in SSO – Part 1. 2. Copy…

Configuration Settings in SSO – Part 1

This post was copied from Link. I wanted to prevent the risk of losing it. In order to make the settings in your Excel settings spreadsheet (SettingsFileGenerator.xml) available to your BizTalk application at runtime, they must be deployed into a BizTalk SSO affiliate application. Once deployed into SSO, the settings may be read dynamically at…