How do I fix the er...
Clear all

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


Sathish Kumar
Member Moderator
Joined: 4 months ago
Posts: 1203
20/03/2021 9:45 am  

When I try to connect to my database from a site. I am getting this below error:

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

I even also tried connecting using the local IP address as well as a public one.

I had also checked the below things:

  1. Yes, the site can be able to communicate with the server
  2. Named pipes/TCP is enabled.
  3. Remote connections are allowed as well.
  4. Windows Firewall is in off condition.
  5. I did create an exception for port 1433 in the Windows Firewall.
  6. Enabled everything in the SQL Server Configuration Manager.

Noble Member
Joined: 4 months ago
Posts: 1179
20/03/2021 9:46 am  

You can solve this issue very easily,

  1. First, go to the control panel.
  2. Search for "services".
  3. Then open the Local services window from your search results.
  4. Restart your MSSQLSERVER service.

Screenshot of the steps:

Screenshot of the steps

If you want to explore more about SQL then do check out the SQL Certification course.