Wednesday, September 2, 2015

How to Fix named Pipes Provider Error 40 cannot open connection to Sql server instance



Symptoms of error

A network related or instance specific error occurred while establishing a connection to sql server the server was not found or not accessible.verify   that the instance name is correct (Provider : Named pipes error Error no 40; etc .

To fix this error goto start menu--> go to  Microsoft Sql Server --> go to configurations folder and click on sql server configuration manager. check below image.



Expand Sql Native client 11.0 Configuration manager. In client protocols you will see TCP/IP, named Pipes,Via disabled, enable those



Expand Server Network Configuration In Protocols for Sql Server here  Enable Shared,Named,TCP/IP

Expand Sql Native client 11.0 Configuration manager. In client protocols you will see TCP/IP, named Pipes,Via disabled, enable those  and restart the Sql related services. Now the error fixed.