JDBC 连接SQL Server 2000数据库错误，解决了马上给分

Question

如果用的是win2003则SQLServer必须要打sp3。
如果不是请检查SQLServer的默认端口是否1433

Answer 1

呵呵，我当时也是这样的情况，查询分析器可以连到SQLSERVER的服务器，可1433端口就是没有被监听，打了SP3也不行，重装了SQLSERVER，1433端口也被监听了，就没问题了

Answer 2

先看看jdbc驱动是否正确，用jdbc是否能连接sql server,在看看是否是网络问题。

Answer 3

我是在微软的网站下的驱动，是那个打过sp3的的最新的驱动；
我用telnet ip 1433不通，怎么办啊
怎样设置监听端口阿

Answer 4

你在CMD方式下输入netstat -a,看有没有下面类似的输出 Active Connections  Proto  Local Address          Foreign Address        State
  TCP    roger:1433              roger:0                LISTENING如果没有，说明你的数据库没有启动，或是端口不是1433。再就是如果你的操作系统是xp的话，最好不要打包，以前也有人用xp连SQL Server的时候，只要打了包就连不上，把包卸掉就可以连上了。

Answer 5

telnet ip 1433不通并不能说明sql server不能使用这类问题的解决办法如下：
1）安装SQL 2000 sp3a
2）鉴权模式最好用mixed方式
3）激活tcp/ip选项（在server上打开属性对话框，general标签－>网络配置）

Answer 6

楼主用的到底是什么操作系统？ 
2K or XP ？

Answer 7

需要MS Sql Server 200的SP3

Answer 8

我已经按照iforem(做官不为民作主，不如回家卖红薯)兄的步骤完成了配置，但还是连不上啊，
Error Trace in getConnection() : [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.Error: No active Connection
SQLState: 08001
Message: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
Vendor: 0
SQLState: HY000
Message: [Microsoft][SQLServer 2000 Driver for JDBC]Connection refused: connect
Vendor: 0而且按照drugon(personal) 兄的做法，netstat -a后也没发现1433端口可用

Answer 9

那就把netstat -a的结果贴出来看看

Answer 10

Proto  Local Address          Foreign Address        State
TCP    0782d7cb699a4b3:smtp   0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:http   0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:epmap  0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:https  0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:microsoft-ds  0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:1026   0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:3389   0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:1025   0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:1025   localhost:1073         ESTABLISHED
TCP    0782d7cb699a4b3:1025   localhost:1075         ESTABLISHED
TCP    0782d7cb699a4b3:1025   localhost:1078         TIME_WAIT
TCP    0782d7cb699a4b3:1025   localhost:1087         ESTABLISHED
TCP    0782d7cb699a4b3:1025   localhost:1131         TIME_WAIT
TCP    0782d7cb699a4b3:1025   localhost:1135         TIME_WAIT
TCP    0782d7cb699a4b3:1025   localhost:1143         TIME_WAIT
TCP    0782d7cb699a4b3:1025   localhost:1147         TIME_WAIT
TCP    0782d7cb699a4b3:1025   localhost:1149         TIME_WAIT
TCP    0782d7cb699a4b3:1025   localhost:1153         TIME_WAIT
TCP    0782d7cb699a4b3:1025   localhost:1155         ESTABLISHED
TCP    0782d7cb699a4b3:1027   0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:1037   0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:1073   localhost:1025         ESTABLISHED
TCP    0782d7cb699a4b3:1075   localhost:1025         ESTABLISHED
TCP    0782d7cb699a4b3:1087   localhost:1025         ESTABLISHED
TCP    0782d7cb699a4b3:1155   localhost:1025         ESTABLISHED
TCP    0782d7cb699a4b3:8888   0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:netbios-ssn  0782d7cb699a4b3:0      LISTENING
TCP    0782d7cb699a4b3:1069   202.202.12.17:http     TIME_WAIT
TCP    0782d7cb699a4b3:1072   211.152.33.73:http     TIME_WAIT
TCP    0782d7cb699a4b3:1074   61.186.252.133:http    ESTABLISHED
TCP    0782d7cb699a4b3:1076   61.186.252.133:http    ESTABLISHED
TCP    0782d7cb699a4b3:1081   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1084   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1086   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1088   61.186.252.130:http    ESTABLISHED
TCP    0782d7cb699a4b3:1090   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1092   61.186.252.136:http    TIME_WAIT
TCP    0782d7cb699a4b3:1094   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1096   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1098   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1100   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1102   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1104   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1106   219.153.11.85:http     TIME_WAIT
TCP    0782d7cb699a4b3:1108   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1110   61.186.252.132:http    TIME_WAIT
TCP    0782d7cb699a4b3:1114   61.186.252.136:http    TIME_WAIT
TCP    0782d7cb699a4b3:1116   61.186.252.136:http    TIME_WAIT
TCP    0782d7cb699a4b3:1122   61.186.252.136:http    TIME_WAIT
TCP    0782d7cb699a4b3:1126   61.186.252.136:http    TIME_WAIT
TCP    0782d7cb699a4b3:1130   61.186.252.136:http    TIME_WAIT
TCP    0782d7cb699a4b3:1134   61.186.252.136:http    TIME_WAIT
TCP    0782d7cb699a4b3:1142   61.186.252.136:http    TIME_WAIT
TCP    0782d7cb699a4b3:1146   61.186.252.136:http    TIME_WAIT
TCP    0782d7cb699a4b3:1152   61.186.252.136:http    TIME_WAIT
TCP    0782d7cb699a4b3:1156   61.186.252.136:http    ESTABLISHED
UDP    0782d7cb699a4b3:microsoft-ds  *:*
UDP    0782d7cb699a4b3:isakmp  *:*
UDP    0782d7cb699a4b3:1032   *:*
UDP    0782d7cb699a4b3:2967   *:*
UDP    0782d7cb699a4b3:3456   *:*
UDP    0782d7cb699a4b3:4000   *:*
UDP    0782d7cb699a4b3:4500   *:*
UDP    0782d7cb699a4b3:6000   *:*
UDP    0782d7cb699a4b3:6001   *:*
UDP    0782d7cb699a4b3:6002   *:*
UDP    0782d7cb699a4b3:6003   *:*
UDP    0782d7cb699a4b3:61440  *:*
UDP    0782d7cb699a4b3:ntp    *:*
UDP    0782d7cb699a4b3:1035   *:*
UDP    0782d7cb699a4b3:1041   *:*
UDP    0782d7cb699a4b3:1066   *:*
UDP    0782d7cb699a4b3:1900   *:*
UDP    0782d7cb699a4b3:ntp    *:*
UDP    0782d7cb699a4b3:netbios-ns  *:*
UDP    0782d7cb699a4b3:netbios-dgm  *:*
UDP    0782d7cb699a4b3:1900   *:*

Answer 11

我已经激活tcp/ip选项（在server上打开属性对话框，general标签－>网络配置），
并指定端口为1433了

Answer 12

不用问一看报错就是纯连接问题  sp3  端口 或是ip 127.0.0.1 都试试没准就好了

Answer 13

怎样设置端口阿，我在SQL Server 内指定了，但netstat -a没反映阿
sp3 也打过了阿

Answer 14

C:\Documents and Settings\user>netstat -a -n

Answer 15

SQLServer 2000 Driver for JDBC驱动安了没有

Answer 16

nescafe1111(流浪狗) 我和你一样
无法连接，我也装的是win2003+sqlserver2000+sqlserver_sp3

Answer 17

我刚刚解决这个问题：好像是sp3a对端口改了。具体你的端口是看sql控制台－>属性－》常规＝》网络配置=>启用协议（光标点tcp/ip）属性看看你的端口是多少
把1433改过来