Tuesday, October 20, 2015

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

Sometimes when we try to login with Sql Server Management studio we get the below error -

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

Preliminary solution is just confirm if Sql Server service is started on your machine -

Type "SQLServerManager.msc" on windows search and enter to open Sql Server Configuration Manager. Verify if MSSQLServer service is running properly.

Note :- SQLServerManager12.msc is for Sql Server 2014 and SQLServerManager13.msc is for Sql Server 2016. You can change the version as per the Sql Server version installed on your PC.

If this is stopped then right click on it and click Start to run this service.

About the Author

Manish Rai

Author & Editor

I am Manish Rai an IT Professional, I started the www.einfoportal.com at the beginning of 2013.My goal is to establish www.einfoportal.com as a information portal that will help every individual(s) to get the information related to their day by day activities and use this information for the good purpose. I love to share my knowledge with the people. Follow me on Facebook | Google+ | Twitter


Post a Comment

Copyright © www.einfoportal.com . All Rights Reserved