telnet localhost 1433 时，连接失败该怎样解决？？？

telnet localhost 1433 时，打不开主机连接，在端口１４３３：连接失败，的原因，该怎样解决？？？？？

15 个解决方案

#1

关闭防火墙，包括杀毒软件的监控设置。还有看看是否设置了动态端口。使用 netstat -a 看看是什么程序占用了端口。

#2

防火墙，杀毒软件监控都关了，怎么还是不行

Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>telnet localhost 1433
正在连接到localhost...不能打开到主机的连接，在端口 1433: 连接失败

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

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    1DB9D29547A841B:http   1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:epmap  1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:https  1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:microsoft-ds  1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:1025   1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:6059   1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:8000   1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:22746  1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:1027   1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:2780   localhost:2781         ESTABLISHED
  TCP    1DB9D29547A841B:2781   localhost:2780         ESTABLISHED
  TCP    1DB9D29547A841B:2782   localhost:2783         ESTABLISHED
  TCP    1DB9D29547A841B:2783   localhost:2782         ESTABLISHED
  TCP    1DB9D29547A841B:36897  1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:netbios-ssn  1DB9D29547A841B:0      LISTENING
  TCP    1DB9D29547A841B:1092   121.33.144.161:5143    ESTABLISHED
  TCP    1DB9D29547A841B:1427   c75-111-194-121.unknwn.ab.dh.suddenlink.net:2000
0  ESTABLISHED
  TCP    1DB9D29547A841B:1444   203-73-54-16.adsl.dynamic.seed.net.tw:4662  ESTA
BLISHED
  TCP    1DB9D29547A841B:1520   61.138.179.85:7788     ESTABLISHED
  TCP    1DB9D29547A841B:1523   61.156.25.112:http     ESTABLISHED
  TCP    1DB9D29547A841B:ingreslock  61.156.25.112:http     ESTABLISHED
  TCP    1DB9D29547A841B:1532   60.222.229.133:http    ESTABLISHED
  TCP    1DB9D29547A841B:1538   123.122.55.171:17916   ESTABLISHED
  TCP    1DB9D29547A841B:1567   222.35.68.56:16818     ESTABLISHED
  TCP    1DB9D29547A841B:1572   222.18.112.82:17586    ESTABLISHED
  TCP    1DB9D29547A841B:1575   211.100.26.121:http    LAST_ACK
  TCP    1DB9D29547A841B:1680   211.100.26.98:http     ESTABLISHED
  TCP    1DB9D29547A841B:1681   211.100.26.98:http     ESTABLISHED
  TCP    1DB9D29547A841B:1796   221.210.182.182:23414  ESTABLISHED
  TCP    1DB9D29547A841B:1797   125.216.234.46:23837   ESTABLISHED
  TCP    1DB9D29547A841B:1820   125.36.228.112:17804   ESTABLISHED
  TCP    1DB9D29547A841B:1824   60.19.64.48:8000       FIN_WAIT_1
  TCP    1DB9D29547A841B:1839   122.157.122.208:16718  LAST_ACK
  TCP    1DB9D29547A841B:1848   60.19.64.48:8000       FIN_WAIT_2
  TCP    1DB9D29547A841B:1850   116.3.14.213:4662      LAST_ACK
  TCP    1DB9D29547A841B:1854   211.100.26.92:http     ESTABLISHED
  TCP    1DB9D29547A841B:1859   211.100.26.75:http     ESTABLISHED
  TCP    1DB9D29547A841B:1871   211.100.26.92:http     ESTABLISHED
  TCP    1DB9D29547A841B:1874   211.100.26.74:http     TIME_WAIT
  TCP    1DB9D29547A841B:1882   211.100.26.74:http     TIME_WAIT
  TCP    1DB9D29547A841B:1884   60.19.64.48:8000       ESTABLISHED
  TCP    1DB9D29547A841B:1885   60.219.196.244:16979   ESTABLISHED
  TCP    1DB9D29547A841B:1886   user-387o88j.cable.mindspring.com:15193  ESTABLI
SHED
  TCP    1DB9D29547A841B:1888   125.37.69.210:18048    ESTABLISHED
  TCP    1DB9D29547A841B:1892   149.125.49.58.broad.wh.hb.dynamic.163data.com.cn
:6649  ESTABLISHED
  TCP    1DB9D29547A841B:1894   60.19.64.48:8000       FIN_WAIT_2
  TCP    1DB9D29547A841B:1895   219-84-177-252-adsl-tpe.dynamic.so-net.net.tw:35
518  ESTABLISHED
  TCP    1DB9D29547A841B:1896   210.44.115.184:netbios-ssn  TIME_WAIT
  TCP    1DB9D29547A841B:2133   218.67.141.35:16818    ESTABLISHED
  TCP    1DB9D29547A841B:2138   124-8-37-25.dynamic.tfn.net.tw:4662  ESTABLISHED

  TCP    1DB9D29547A841B:2491   218-160-156-5.dynamic.hinet.net:8486  ESTABLISHE
D
  TCP    1DB9D29547A841B:4146   156.123.222.222.broad.lf.he.dynamic.163data.com.
cn:4668  ESTABLISHED
  TCP    1DB9D29547A841B:4620   218.1.73.82:6257       ESTABLISHED
  UDP    1DB9D29547A841B:microsoft-ds  *:*
  UDP    1DB9D29547A841B:isakmp  *:*
  UDP    1DB9D29547A841B:1004   *:*
  UDP    1DB9D29547A841B:1032   *:*
  UDP    1DB9D29547A841B:1152   *:*
  UDP    1DB9D29547A841B:1156   *:*
  UDP    1DB9D29547A841B:1169   *:*
  UDP    1DB9D29547A841B:1196   *:*
  UDP    1DB9D29547A841B:1197   *:*
  UDP    1DB9D29547A841B:1198   *:*
  UDP    1DB9D29547A841B:1199   *:*
  UDP    1DB9D29547A841B:1201   *:*
  UDP    1DB9D29547A841B:1203   *:*
  UDP    1DB9D29547A841B:1204   *:*
  UDP    1DB9D29547A841B:1205   *:*
  UDP    1DB9D29547A841B:1253   *:*
  UDP    1DB9D29547A841B:1495   *:*
  UDP    1DB9D29547A841B:1873   *:*
  UDP    1DB9D29547A841B:3456   *:*
  UDP    1DB9D29547A841B:4500   *:*
  UDP    1DB9D29547A841B:10060  *:*
  UDP    1DB9D29547A841B:15005  *:*
  UDP    1DB9D29547A841B:19247  *:*
  UDP    1DB9D29547A841B:23660  *:*
  UDP    1DB9D29547A841B:55979  *:*
  UDP    1DB9D29547A841B:ntp    *:*
  UDP    1DB9D29547A841B:1172   *:*
  UDP    1DB9D29547A841B:3500   *:*
  UDP    1DB9D29547A841B:ntp    *:*
  UDP    1DB9D29547A841B:netbios-ns  *:*
  UDP    1DB9D29547A841B:netbios-dgm  *:*

C:\Documents and Settings\Administrator>telnet localhost 1433
正在连接到localhost...不能打开到主机的连接，在端口 1433: 连接失败

#3

localhost 1433 ？？？

1 你的SQL没有启动
2 没有启用TCP/IP
3 安装 SP4 看看吧！

#4

ＳＱＬ数据我己启动了，安装了ＳＰ４，刚下载的，
网络／客户端的实用工具中已经开启了ＴＣＰ／ＩＰ协义
怎么还是不行

#5

确定一下sp4是否真的安装，下载下来后的运行其实是解压过程，
三个文件解压到一个目录后才会真正生成一个安装文件

select @version —— 8.00.2093

此时才表明你的sp4真的打上了

#6

[code=BatchFile]netstat -ano[/code]
看1433端口 state是否LISTENING状态

另如ls确保是sp4

select @@version

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

#7

sql server的补丁打上应该就可以了

出现这个问题多半是补丁未打，以前是SP3，现在应该是SP4了

#8

在查询分析器中显示的结果：
select @@version
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

#9

8.00.194

很明显你没有打上SP4补丁，不是解压缩就完了的，还要运行呢！

#10

楼主是马甲吗？额的神呀，同一个问题，发了很多贴了 -.-#
http://topic.csdn.net/u/20080404/08/38770693-dcbe-4ce1-b06a-d69e607eb8fe.html?seed=1359003126

#11

我让大家见笑了，我怕老是问你们烦,但是我笨的就是自己弄不到来，
运行是总是报那处错误，

#12

我今天刚学用JDBC连接数据

#13

我终于给弄好了，特别不好意思，特别是 bootupnow的朋友，你回答我同一个问个问题二遍，
还有，我这是今天刚拿一个例了做实验，谢谢了，真是不好意思！！！！！！！！！！！！！！！！！

#14

入门经典问题。关键是要打SP3以上的补丁。
现在感觉用java就不应该连接sql server，高端有oracle，低端有my sql，而且sql server不能跨平台，对java的支持也不好。

#15

看到老紫竹了，嘿嘿

#1