通过端口 1433 连接到主机 127.0.0.1 的 TCP/IP 连接失败。错误:“Connection refused: connect。_百度知道
通过端口 1433 连接到主机 127.0.0.1 的 TCP/IP 连接失败。错误:“Connection refused: connect。
TODO Auto-generated method stub DBUtil db=new DBUtil().sql.createStatement().ResultSet.0;import java.getConnection(&quot,f_date from t_news& }
public int executeUpdate(String sql) throws SQLE public static void main(String[] args) {
&#47.+rs.Connection.println(
conn=getConnection()：package beans.printStackTrace().executeQuery(sql);/ TODO Auto-generated catch block
e.getString(3)); TODO Auto-generated catch block
return conn.close();&#47,f_import java.0;
Statement stmt=null.printStackTrace();
while (rs:sqlserver.executeUpdate(sql).SQLE TODO Auto-generated catch block
e, SQLException {
Connection conn=null.printStackTrace().createStatement();
iCount=stmt.password=sa&&#47.S
} catch (SQLException e) {
&#47.getString(2)+&
stmt=conn.
Statement stmt=
} catch (SQLException e) {
ResultSet rs=null:1433;
conn=getConnection();&#47.printStackTrace();
conn=DriverManager.SQLServerDriver& TODO Auto-generated catch block
} catch (SQLException e) {
&quot, ClassNotFoundException {
Connection conn=
} public ResultSet executeSelect(String sql) {
Connection conn=+rs.user=Select f_id.forName(&public class DBUtil { public Connection getConnection() throws ClassNotFoundException.sql.getString(1)+&
&quot.1，SQL默认TCP/&#47. TODO Auto-generated catch block
e.DriverM);databaseName=
} catch (ClassNotFoundException e) {
&#47.out.next())
S/com.executeSelect(&IP端口号是1433啊;
} catch (SQLException e) {
&#47:/
int iCount=0;
ResultSet rs=**
* @param args
* @throws SQLException
*/)，怎么回事;&#47.printStackTrace()？代码如下;).sqlJSP连接SQL2005数据库出现错误
提问者采纳
SQLException {
Connection conn=password=sa&com:sqlserver:1433;/
Class.sqlserver:&#47.SQLServerDriver&quot，一般是验证身份出了问题.)？;);
conn=DriverManager.forName(&127.microsoft。上面这个语句定义了前台到Database的验证;user=sa.0.1.getConnection(&
连接被拒，但是你的数据库允许SA弱口令登录否.0public class DBUtil { public Connection getConnection() throws ClassNotFoundEdatabaseName=newsdb？
其他类似问题
为您推荐：
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁正在连接ip..无法打开到主机的连接。在端口 23: 连接失败_百度知道
正在连接ip..无法打开到主机的连接。在端口 23: 连接失败
我在哗耽糕甘蕹仿革湿宫溅cmd命令如下：
IP可出现上面的问题。~~怎么办怎么办~我是在telnet自己的计算机，这样可以吗？是windows 7 系统那个telnet服务启动时报错求解答
我有更好的答案
启动策略里的TELNET依存项。
哪个依存项？
为您推荐：
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁telnet&127.0.0.1&1433&&&&&提示：不能打开到主机的连接，在端口1
服务器IP能否ping通。
sql server
2000sql server 2000IP
在Dos或命令行下输入telnet
服务器IP 端口，看能否连通。
telnet 202.114.100.100
14331433sql server 2000Tcp/IP,"
1 sql server
2 Tcp/IP()
-&-&Microsoft SQL Server-&tcp/ip
3 tcp/ip1433tcp/ip1433
telnetTcp/ip2433
4 sp2windows1433windows()
5 1433tcp1433dos
netstat -a -n netstat
tcp 127.0.0.1 1433
listening sql server
select @@version
sql server2000
java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
com.microsoft.jdbc.sqlserver.tds.TDSConnection.(Unknown
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown
com.microsoft.jdbc.base.BaseConnection.open(Unknown
com.microsoft.jdbc.base.BaseDriver.connect(Unknown
at java.sql.DriverManager.getConnection(Unknown
at java.sql.DriverManager.getConnection(Unknown
...........
server2000sp3
dos:netstat -a ,,1433,,,sp3
select @@version
8.00.760,sp3,8.00.194,sp3,:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 :48 Copyright (c)
Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack
8.00.194 ------SQL Server 2000
8.00.384 ------(SP1)
8.00.534 ------(SP2)
8.00.760 ------(SP3)
/download/d/d/e/dde427eb-0296-4eac-a47c-d11a66b03816/chs_sql2ksp3.exe
setup.bat.
b-&regedit
cHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session
ePendingFileRenameOperations
2SQL Server SP3windowssqlsp.out
[TCP/IP Sockets]Specified SQL server not
[TCP/IP Sockets]ConnectionOpen
(Connect()).
SQL Server
SP3bugsp3tcp/ip
1SQL servername pipe.
2[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]
"DSQUERY"="DBNETLIB".
telnet ip 1433
检查客户端设置
-&Microsoft SQL
Server -& tcp/ip1433()
在企业管理器里或查询那分析器连接测试
-&SQlserver-&sqlserver-&-&IP-&-&Sqlserver-&-&(sa,password)-&-&-&
-&-&-&IP-&(sa,password)-&
SQL Server415
-&-&-&"SQL Server"""-&-&
Windows"SQL Server(
SQL Server
Server"SQL Server""""
3 """SQL Server
Server(dosnet stop mssqlservernet start mssqlserver)
已投稿到：
以上网友发言只代表其个人观点，不代表新浪网的观点或立场。