Named Pipes: Cannot connect to SQL Server using SQL Native Client

My connection to the SQL Native Client keeps of saying..

Named Pipes: Cannot connect to SQL server.

what is the problem?

I can connect to an ordinary c:*.mdb file but not to my SQL Express Edition even with the suggestions on the site.

Please help!


2 answers

Hi Mark

Did you double check that named pipes is enabled on the server?

Open up "SQL Server configuration manager" (located in the programs folder/SQL Server/Configuration Tools).

Click the SQL Server Network Configuration and then "Protocols".
Named Pipes should be in the list. Check that it is enabled! If not, enable it and try connecting again!

Thanks! That did it, it's working now!!

So I guess named pipes wasn't enabled by default.