sql server connect: SQL Connection problem -- sql server connect

SQL Connection problem

Aboki
7/24/2003 1:42:40 PM

sql server connect:

This is the error my user is getting. The environment is
clustered. He can connect to the other two clustered
environments in QA and dev. but not in production.

Connection failed
SqlState:'01000'
SQL Server Error:10061
[Microsoft][ODBC SQL Server Driver][TCP/IP sockets]
ConnectionOpen (connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL

Re: SQL Connection problem

Carlos Eduardo Rojas
7/28/2003 10:11:28 AM

Can the user ping the server (by the cluster name)? If so, then try
connecting to the server on tcp port 1433. To try this, use the following
command:
telnet servername 1433
This at least will give you an idea, to see if the user can see the server
and connect to the sql server port.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example

[quoted text, click to view]