Named Pipes Provider, error 40 Microsoft SQL server when unable to connect

Posted by Self-Innovator under Sql Server category on | Points: 40 | Views : 942
When you are experiencing the "Named Pipes provider Microsoft SQL server Error 40" try the below steps to resolve the issue

Step 1: Search for SQL Server Configuration manager, if unable to find/missed while installing it then install it (SQLEXPR_x64_ENU.exe) this is for 64 bit version, you can install according to you computer's/ laptop's Configuration

Step 2: Go to Configuration Manager section and Enable the TCP/IP protocol

Step 3: Go to Control Panel -> Admin Tools -> Services -> Search for MSSQLSERVER Service and restart it.

Step 4: Login back to SQL server management studio with proper instance name as
Server Name =.\SQLEXPRESS
Authentication: SQL Server Authentocation
Login: sa
Password: **********

This will resolve the issue

Comments or Responses

Posted by: Wingsio on: 12/11/2017 Level:Starter | Status: [Member] | Points: 10
Oh, great, your article gives me useful information and a fresh perspective on the subject.

Posted by: Wingsio on: 4/9/2018 Level:Starter | Status: [Member] | Points: 10
I read some articles on this site and I think your blog is really interesting and has great information. Thank you for your sharing.

Login to post response