在用MSSQL连接数据库的过程中,经常会遇见“Error establishing socket.”的错误,大概得错误日志信息如下:
Sql代码
java.sql.SQLException : [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection( DriverManager.java:523 )
at java.sql.DriverManager.getConnection( DriverManager.java:171 )
at test.SqlServerTest.main( SqlServerTest.java:29 )
java.sql.SQLException : [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection( DriverManager.java:523 )
at java.sql.DriverManager.getConnection( DriverManager.java:171 )
at test.SqlServerTest.main( SqlServerTest.java:29 )
我在网上查询到问题解决的方式有大概如下 种:
一 配置错误
jdbc配置语句为: jdbc:microsoft:sqlserver://server_name:1433
其中的sqlserver、server_name和端口号都要看仔细了。
二 1433端口问题
可以通过命令“netstat -an”,来查看是否开了1433端口,如果列表中没有,要增开端口。
要保持jdbc配置语句( jdbc:microsoft:sqlserver://server_name:1433)中的端口与数据库传输协议默认的端口相同。
MSSQL设置端口号步骤如下:
1. 打开企业管理器,依次在控制台根目录 ->Microsoft SQL Servers->SQL Server 组,列出一部分数据库服务器。
2. 右击我们要连接的数据库服务器,选择属性,在常规选项卡点击网络配置弹出新窗口。
3. 在启用的协议区域我们选择 TCP/IP ,点击属性按钮,弹出新窗口。在这个窗口有网络协议默认值设置,一般默认端口是:1433。 如果你在url中用的端口号与这个不同,就会出现错误。应保持二者相同。
三 没打补丁
可以用如下的方式查看MSSQL的版本:
打开企业管理器-〉工具-〉SQL查询分析器-〉帮助-〉关于
查看MSSQL的详细版本号
如果 是 8.00.194 就是还没打补丁
8.00.760 就是SP3
8.00.2039 就是SP4
1、下载MSSQL 2000 Service Pack 3a并安装,SQL请选用混和安装模式!!!
http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=zh-cn
解压缩sp3的升级包后,还要点击setup安装.才能成功升级到sp3。
2、下载SQL Server 2000 Driver for JDBC Service Pack 3
http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en
四 系统防火墙或者杀毒软件
如果系统开防火墙或者杀毒软件,在有些情况下也可以出现类似的问题。
没有遇见过,有人这么说。
可能我查询的未必全面,如果你的解决方式不同,可以给我留言,一起完善其解决方法.
分享到:
相关推荐
"java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver" ...[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. 解决了jsp连接 sql server 2000的问题
此文档中详细的记载了,谈JDBC SQLSERVERError establishing socket,希望可以帮到下载的朋友们!
我们在在使用SQL Server时都会遇到使用SQL Server Management Studio无法连接远程数据库实例的问题,错误描述信息摘录如下: An error has occurred while establishing a connection to the server. (provider: ...
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at ...
Error occurred while establishing connection to Oracle server. You might have 32-bit connectivity components installed on the machine, in order for SSMA to make use of those connectivity libraries, ...
你编写java程序出现了如下的错误提示【[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket】
Grant Fritchey's book SQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization ...
准备环境 Windows XP+JDK5.0+Microsoft SQL Server 2000个人版+JCreator(或Eclipse) 下载数据库驱动程序SQL Server 2000 Driver for JDBC Service Pack 3.exe...1、是不是出现了Error establishing socket之类的错误
This book covers the latest in performance optimization features and techniques and is current with SQL Server 2017. If your queries are not running fast enough and you’re tired of phone calls from ...
title: 解决JDBC连接MySQL时发出的警告问题描述解决JDBC连接MySQL时发出的警告WARN: Establishing SSL connecti
Establishing Confidence in PDN Simulation
Establishing a Framework for Business Communication
Bug with error processing on socket data reading under Unix is fixed Oracle data provider DataTypeMapping conversion from XMLType to ftString is added DataTypeMapping conversion from Interval to ...
Both client and server must support SSH/SSL for establishing secure connection. To establish secure connection using SecureBridge components it's enough to select required authentication methods and...
Laravel开发-flickering Flickr API的现代接口
-Bug with error processing on socket data reading under Unix is fixed Oracle data provider -DataTypeMapping conversion from XMLType to ftString is added -DataTypeMapping conversion from Interval to ...
In this module we will discuss Microsoft® SQL Server™ interaction with the operating system and methodology of troubleshooting server-based problems. At the end of this module, you will be able to:...
-Bug with processing tinyint and bigint parameters in SQL Server Compact Edition is fixed -Bug with the Integer Overflow error on query preparation when DescribeParams is True is fixed -Bug with ...
Toward Establishing Trust in Adaptive Agents,好文章