none
connection error RRS feed

  • Question

  • I have installed an application on several xp machines. They all seem to be working fine.
    Except one machine which has windows 2000. The application works but it is slow and sometimes it gives the following error:

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    Please note that in sql server 2005 Local and Remote connections is selected using tcpip

    Any thoughts why only this machines sometimes gives this error when connecting to the sql server 2005 please?
    Thanks

    Wednesday, December 5, 2007 3:57 PM

Answers

  • Here is the complete list of steps to fix error 40 because I noticed you said TCP/IP but not Named Pipes it is better to use both.  And the browser service in configuration Manager must be enabled.

     

    Steps for Configuration Manager:

    Make Browser service automatic from Manual in SQL Server 2005 services

     

    Go to Network Configuration in Configuration Manager

    Enable TCP/IP

    Enable Named Pipes

     

    Surface Area Configuration tool steps:

    Go to Surface Area configuration for services and Connection

    In Database Engine click on Remote Connection

    In there change to Local and Remote

    And choose both TCP/IP and Named Pipes it is the last option.

     

     

    If you do the above and still get an error then it maybe firewall related and that is covered by Microsoft below.

     

    http://support.microsoft.com/kb/914277

     

    Wednesday, December 5, 2007 5:37 PM