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.