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