Named pipes error -40, SQL server error 53

  • urabe

    SSC Veteran

    Points: 282

    Hi

    I've installed SQL 2005 on Windows server 2003. I can ping the server, enabled TCP/IP and named pipes and remote connections.

    However, I still receive Named pipes error -40, SQL server error 53, error.

    Any ideas or suggestions welcome

  • Gift Peddie

    SSC Guru

    Points: 73570

    urabe (12/21/2009)


    Hi

    I've installed SQL 2005 on Windows server 2003. I can ping the server, enabled TCP/IP and named pipes and remote connections.

    However, I still receive Named pipes error -40, SQL server error 53, error.

    Any ideas or suggestions welcome

    Your problem is not related to what you are saying error 40 then error 53 means the server cannot be contacted. I have posted the SQL Server protocol blog link which includes most reasons for the error including firewalls in the thread below.

    http://www.sqlservercentral.com/Forums/Topic754255-291-1.aspx

    Kind regards,
    Gift Peddie

  • nunezreinaldo

    Grasshopper

    Points: 11

    In my case what it worked for me was the Hosts file in the folder C:\Windows\System32\drivers\etc

    I was trying to connect into a SQL server with a name that has an entry in the HOSTS file; however, the IP in the HOSTS file was unreachable - Nonexisting - 

    First, I connected using my SQL  client using the IP address and it was no problem.
    Next, I delete the entry for the SQL server name in the HOST file in the folder C:\Windows\System32\drivers\etc, saved it and again tried to connect into that SQL server using the name that I just deleted from the host file and it went thru without issues.

    I hope it helps someone along the way

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply