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

Posted 2010-04-21 14:30
by Mark Tassenholtz
in the SQL Server Forum

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!

Thanks

Reply 2010-04-21 14:33
by Max Wikström
in the SQL Server Forum

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!

Reply 2010-04-21 14:35
by Mark Tassenholtz
in the SQL Server Forum

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

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

Thanks!!!