I've got a new Win2008R2 server setup which is a vm, to host a web site.
I've installed sql 2008 r2 express edition.
I can run queries fine from ssms but when the website connects through .NET sql client on the same machine I get this:
Shared Memory Provider, error: 0 - No process is on the other end of the pipe.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
The connection strings I've tried are
Remote connections are enabled and as far as I can tell named pipes is enabled and I just moved it to the top in the "order" of protocols.