Jon Flanders did some great work with SSO for storing BizTalk configuration data (used by .NET code) within the Enterprise SSO Database and the BizTalk team created a sample application for using SSO as a Configuration Store back in BizTalk Server 2006. Richard Seroter brought these things together in an SSO Configuration Utility that enables users to configure values that can then be read at runtime by an incredibly simple API. My BizTalk SSO Storage utility builds upon this work and I’ve updated the solution to Visual Studio 2010. I’ve created a document that explains how to setup SSO Storage Applications and access their secret values using the Microsoft API.
The solution (in compressed form) can be found here:
The document which describes the solution can be found here (and in the zip above):