Issues connecting via tcp/ip

[ceeleelewis]

I am trying to set a connection in ODBC to connect to an SQL Server on another computer in my network(not a domain).
SQL is set to listen in port 1433, but when I run netstat -an there is no sign that the port is listening.
This is preventing me to connect via TCP/IP.
This is the Error Reported when trying to set connection in OBDC
=========
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:

 

[JoeSack]

Hi,

This could be caused by a number of issues. Here is an article that helps review several methods for troubleshooting, "How to troubleshoot connectivity issues in SQL Server 2000":

http://support.microsoft.com/default.aspx?scid=kb;en-us;827422

Best Regards,
Joseph Sack,

http://www.JoeSack.com

Author of "SQL Server 2000 Fast Answers for DBAs and Developers".