Post reply

Named pipes error -40, SQL server error 53

  • December 21, 2009 at 1:10 am

    #73472

    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

  • December 21, 2009 at 9:17 am

    #1094846

    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

  • February 27, 2019 at 9:23 am

    #2023094

    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 2 (of 2 total)

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