Unanswered: An error has occurred while establishing a connection to the server???
*** Also posted under SQL 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) and only in EXCEL (Access links up fine). 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!