July 31, 2007 at 1:30 am
Hi,
i have installed sql 2000 personal edition on win xp, and i can not telnet to the localhost: telnet localhost 1433
the query analyser works fine.
Can anyone help me with this problem?
tnx
July 31, 2007 at 8:10 am
Different protocol in use, not text.
August 1, 2007 at 6:48 am
Indeed, but TELNET is a quick and dirty "Is such a port open" test.
Check the error log on the SQL server. It will tell you if TCP is enabled. On one of my servers, there is a startup message in the error log.
...
SQL server listening on 192.168.1.234: 1434.
...
This tells me that the IP address and TCP port that my SQL instance is using. In this case, it is port 1434.
If I telnet to that TCP port, I won't be able to do anything (I don't speak TDS) but I can see if the port is open to me.
It could be that your SQL server does not have TCP enabled, and that your QA connection is via Named Pipes.
August 2, 2007 at 11:54 pm
are you sure you ss2000 has installed sp3 or sp4?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply