I received the below error when doing a BizTalk Server 2009 configuration today. It seems the box I was working on had previously had a failed attempt at configuring BizTalk. I deleted the local SSO Administrators group and the config proceeded without error.
(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.))