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

Solution:

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!!

Nandri!

Saravana

Author: Saravana Kumar

Saravana Kumar is the Founder and CTO of BizTalk360, an enterprise software that acts as an all-in-one solution for better administration, operation, support and monitoring of Microsoft BizTalk Server environments.

One Platform Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

One Platform - Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

One Platform - Operations, Monitoring and Analytics Software
ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

Back to Top