Groups | Blog | Home
all groups > sql server connect > april 2006 >

sql server connect : SQL Server 2000 listening on port 1433, but not answering!


James
4/28/2006 5:48:15 AM
Hi

I have a windows 2003 std ed server, with SQL Server 2000 SP4 on it,
and a netstat -an shows port 1433 as listening, but it doesn't reply
when I telnet to it! I'm very new to SQL Server, so please excuse me if
I'm being an idiot! Anyone know what might be wrong? I know there is no
firewall issue on this server, and everything I'm trying to do here is
form the localhost, but it doesn't work from external connections
either.

C:\Documents and Settings\Administrator>netstat -an

Active Connections (I've edited out everything that isn't related to
1433)

Proto Local Address Foreign Address State
TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1036 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:1433 127.0.0.1:1036 ESTABLISHED
TCP ***.***.***.***:1043 ***.***.***.***:1433 TIME_WAIT

Where ***.***.***.*** is my server's IP address.

Thanks
James
Linchi Shea
4/29/2006 8:31:01 PM
I don't know why your telent ddn't get any response. But why not try to make
a SQL Server connection? For instance using the followign command line:

cmd>osql -S127.0.01,1433 -Uuser -Ppassword

It's more informative that telnet.

Linchi

[quoted text, click to view]
James
4/30/2006 9:17:47 AM
Thanks Linchi! osql connected fine, so I'm guessing my SQL Server is
listening out for me!

Thanks again!
James
AddThis Social Bookmark Button