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

Self-Innovator
Posted by Self-Innovator under Sql Server category on | Points: 40 | Views : 157
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.
http://wingsio0.com/

Login to post response