As we know, BizTalk application’s configuration can be also store in SSO DB. There are below some of advantages of storing into SSO DB.
- Secure and centralized as very useful in multi BizTalk servers environment.
- No need to restart host instance after change.
- Easy to backup and deploy.
There are below UI tools can be used to manage application configuration in SSO DB.
- SSO Configuration Application MMC Snap-In –http://www.microsoft.com/en-us/download/details.aspx?id=14524
- BizTalk SSO Configuration Data Storage Tool written by RICHARD SEROTER –
http://seroter.wordpress.com/2007/09/21/biztalk-sso-configuration-data-storage-tool/
After installation of SSO Configuration Application MMC for BizTalk 2013/R2, It allows to create application but not saving or displaying property into SSO DB. I also checked event log but no luck.
After some investigation, I found that Microsoft incremented the assembly version of the Microsoft.EnterpriseSingleSignOn.Interop.dll assembly to 7.0.2300.0 in BizTalk 2013 and 9.0.1000.0 in 2013 R2. But SSOMMCSnapIn.dll assembly in “C:\Program Files (x86)\Microsoft Services\SSO Application Configuration” folder still refers to Microsoft.EnterpriseSingleSignOn.Interop.dll version 5.0.1.0.
To Fix this issue, you have to update SSOMMCSnapIn.dll.config as below:
BizTalk Sever 2013
<?xml version=”1.0″ encoding=”utf-8″ ?>
<configuration>
<runtime>
<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″ appliesTo=”v4.0.30319″>
<dependentAssembly>
<assemblyIdentity name=”Microsoft.EnterpriseSingleSignOn.Interop” publicKeyToken=”31bf3856ad364e35″ culture=”neutral” />
<bindingRedirect oldVersion=”5.0.1.0″ newVersion=”7.0.2300.0″/>
</dependentAssembly>
</assemblyBinding>
</runtime>
<appSettings>
<add key=”CompanyName” value=”=”<CompanyName>” />
</appSettings>
</configuration>
BizTalk Sever 2013 R2
<?xml version=”1.0″ encoding=”utf-8″ ?>
<configuration>
<runtime>
<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″ appliesTo=”v4.0.30319″>
<dependentAssembly>
<assemblyIdentity name=”Microsoft.EnterpriseSingleSignOn.Interop” publicKeyToken=”31bf3856ad364e35″ culture=”neutral” />
<bindingRedirect oldVersion=”5.0.1.0″ newVersion=”9.0.1000.0″/>
</dependentAssembly>
</assemblyBinding>
</runtime>
<appSettings>
<add key=”CompanyName” value=”<CompanyName>” />
</appSettings>
</configuration>
References:
http://www.microsoft.com/en-us/download/details.aspx?id=14524
http://seroter.wordpress.com/2007/09/21/biztalk-sso-configuration-data-storage-tool/