Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Posts
    119

    Unanswered: Ann error has occurred while establishing a connection to the server??

    I have SQL Server 2000, and a mix of workstations running XP Pro and 2000.
    I have several Excel reports that link via ODBC to SQL. My 2000 machines link up fine; however my XP machine get 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 setting SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - could not open connection to SQL Server)"

    Again, I do not have SQL Server 2005, and I only get this message from XP Machines (with Firewalls DISABLED). Once we click OK on the error, it updates anyway.

    The ODBC driver for SQL Server is 2000.85.1117.00 on our XP machines.

    ANY ideas would be GREATLY APPRECIATED!
    TIA,
    Krista

  2. #2
    Join Date
    Jun 2006
    Posts
    5
    Hi,

    When u connect via XP machine , in the connection setup use server machine IP instead of server name.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •