views:

157

answers:

2

I've got an ASP.NET app that uses the standard SQL Server Membership provider to authenticate. Works fine with a local database (this is NOT SQL Svr Express!). When I try to authenticate against a remote database, even with correct connection string, I always get a 'Named Pipes Provider, error 40: Could not open a connection to SQL Server. I've verified that the server allows remote connections and that it supports Named Pipes connections. No one else is using the database at the same time (although others may be connected to the server). Here is the connection string and membership info in my web.config (names dummied and ip address dummied for privacy). Any one have any ideas? Bob

(same settings as above for roleManager)

A: 

Are you able to connect to the remote SQL Server using the Management Studio on your local machine?

hallie
A: 

Named pipe is valid for local connection only. Need TCP Protocol.

Sky Sanders