error 40 could not open a connection sql server

You may get below error or Named Piped error

A network-related or instance-specific error occured while establising a connection to SQL Server.The server was not found or was not accessible.Verify that the instance name is correct and that SQL Server is configured to allow remote connections.(Provider:Named Pipes Provider, error:40- Could not open a connection to SQL Server)(Microsoft SQL Server, Error:2)

• Follow below steps to resolve the issue.

1. Go to Start->All Programs->Microsoft SQL Server 2008 R2->Configuration Tools->SQL Server Configuration Manager.
2. Click on SQL Server Network Configuration->Protocols for SQLEXPRESS on left side panel.

• You will find 

1. Shared Memory
2. Name Pipes
3. TCP/IP
4. VIA

Enable all except VIA.

Not required to Enable VIA. Leave it as it is.

• Refresh Stop and Start the SQLEXPRESS server service(Click on start then type services.)