Error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?

fix the error 'named Pipes Provider, error : 40 - Could not open a connnnection to SQL Server (Microsoft SQL Server error: 2 !!

sometimes when trying to connect to SQL Server managment studio this error appears. For several reasons, first things to check:

1. If connection remotly, check if the site can communicate with the server.

2. Named pipes/TCP is enabled.

3. Remote connections are allowed.

4. Windows Firewall is off.

5. Created an exception for port 1433 in Windows Firewall.

If none of this previous steps worked their magic, then solving this problem is very easy:

1. Go to control panel.

2. search for services.

3. Open Local services window from your search results

4. Restart your MSSQLSERVER service.