Home » Topic » How to fix ”Named Pipes Provider, error: 40” in SQL Server

How to fix ”Named Pipes Provider, error: 40” in SQL Server

Stephen West ~ Modified: December 3rd, 2015 ~ ~ 1 Minute Reading

Home › Forums › How to fix ”Named Pipes Provider, error: 40” in SQL Server

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • December 3, 2015 at 10:45 am #970 Score: 0
    Stephen West
    Moderator
    4 pts

    Can’t connect to SQL Sever Management Studio 2008. When I try to connect to SQL Server Management Studio environment I get the following error

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

    What can I do?

    December 5, 2015 at 11:22 am #980 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    Make sure:
    1.The site can communicate with the server
    2.Remote connections are allowed.
    3.Named pipes/TCP is enabled.
    4.Enabled everything in SQL Server Configuration Manager.

    December 7, 2015 at 10:45 am #983 Score: 0
    Stephen West
    Moderator
    4 pts

    I have checked the remote connection, named pipes/TCP and also tried the local IP address to connect but I am still getting the error

    December 10, 2015 at 12:17 pm #993 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    Just enabled TCP/IP, VIA, Named Pipes in SQL Server Configuration manager

    December 12, 2015 at 12:36 pm #997 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    I found an informative blog about this problem here that reference:http://www.sqlserverlogexplorer.com/fix-error-message-40/

    December 15, 2015 at 12:48 pm #1000 Score: 0
    Stephen West
    Moderator
    4 pts

    Thanks Lincoln for the link I’ve got the solution 🙂

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.