sql server odbc: SQL Server Driver][TCP/IP Sockets]SQL Server Does not exist -- sql server odbc

SQL Server Driver][TCP/IP Sockets]SQL Server Does not exist

Kevin
7/28/2004 2:17:56 PM

sql server odbc:

Two part question:

1) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
SQL Server does not exist or access denied.

I have SQL & Windows authentication set on the server,
I'm running SQL 2000 - 8.00.194 and Standard Edition Win
2k(5.2). Do I need to "Set Impersonate = true" Or
Configure IE for Delegation ( which it is).

2) When I try to create a Server DSN connection to
the server, I get the following error message:

Error on connection:
SQL State: '01000'
SQL Server Error 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
ConnectionOpen (Connect())
Error on connection:
SQL State: '08001'
SQL Server Error 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL
Server does not exist
or access denied

- I can ping the SQL Server by name and IP address
- I have tried the name and the IP address in the ODBC
driver
- I am using SQL Server authentication and sa as user

Do I need to install the latest version of MDAC? I would

Re: SQL Server Driver][TCP/IP Sockets]SQL Server Does not exist

Michael C
7/29/2004 2:16:49 AM

While you're at it you might want to upgrade to SQL SP 3a (8.00.761). Check
your sa password and make sure your SQL Server is using TCP/IP. You might
try to set up an ODBC connection locally on the server using the servername
and using (local) to make sure your connection information is correct.

Thanks,
Michael C.

[quoted text, click to view]