Friday, May 10, 2013

How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?

If you get error 404 when you open the sql server 2012:




Step1: Run SQL Server Configuration Manager.



Step2: Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.



Step3: Make sure TCP/IP is enabled.


Enjoy.....