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

Question

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 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.

What else do I have to do here?

Answer 1

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:

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