BizTalk 2009 (public beta), Windows XP – SP3, SQL 2008

|  Posted: March 11, 2009  |  Categories: BizTalk Server

Today I was trying to install the BizTalk 2009 public beta bits on a virtual machine running

  • Windows XP SP3 ( BizTalk 2009 won’t install if you don’t have SP3, so I did a windows update to get all the latest bits)
  • SQL 2008 RTM
  • VS 2008

BizTalk installation went fine without any issues. Most of you guys who have used BizTalk long enough knew always the tricky bit starts with BizTalk configuration, it can fail for variety of reasons right from MS DTC setting, Database Access, permission etc etc.

I selected basic configuration with a local account. Installation was failing constantly right on the first step configuring Enterprise Single Sign on. Received following error messages

Error 1:

Failed to generate and backup the master secret to file: C:Program FilesCommon FilesEnterprise Single Sign-OnSSO48AE.bak (SSO) Additional Information (0x80070005) Access is Denied.

Error 2:

An error occurred while attempting to access the SSO database. See the event log (on computer ‘SK-XP-VM’) for more details.
(SQL: 0x000000E9: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.))


1. Create the SSO Administrators group manually

2. Add the service account and logged in account to the group.

3. Re-run the configuration wizard.

Bit weird, but it works!!



Author: Saravana Kumar

Saravana Kumar is the Founder and CEO of BizTalk360 | Serverless360 | Atomic Scope | Document360. Founder of multiple B2B products that solve the pain point of enterprise customers. Entrepreneur, Investor, and Technical enthusiast. Passionate about running and scaling a company in a profitable way with calculated risks.

Back to Top