[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)
在查询分析器中显示的结果: 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)
(C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\Administrator>telnet localhost 1433
正在连接到localhost...不能打开到主机的连接, 在端口 1433: 连接失败C:\Documents and Settings\Administrator>netstat -aActive 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: 连接失败
2 没有启用TCP/IP
3 安装 SP4 看看吧!
三个文件解压到一个目录后才会真正生成一个安装文件select @version —— 8.00.2093此时才表明你的sp4真的打上了
看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)
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)
http://topic.csdn.net/u/20080404/08/38770693-dcbe-4ce1-b06a-d69e607eb8fe.html?seed=1359003126
还有,我这是今天刚拿一个例了做实验,谢谢了,真是不好意思!!!!!!!!!!!!!!!!!
现在感觉用java就不应该连接sql server,高端有oracle,低端有my sql,而且sql server不能跨平台,对java的支持也不好。