jdbc配置语句为: jdbc:microsoft:sqlserver://server_name:1433
如运行程序时出现 "Error establishing socket" 错误,则应进行如下调试:
1 检查SQL SERVER 是否允许远程访问.具体步骤:
1)打开"企业管理器",打开控制台根目录>SQL Server 组>数据库
2)在相应"数据库"上单击右键,选择"属性"
3)选择"连接"选项卡,检查"远程服务器连接"下,RPC服务是否选择.
2 使用telnet IP地址 1433,系统是否提示连接出错,如系统提示出错
检查是否防火墙屏蔽了SQL SERVER 或 java IDE 的网络访问端口
如果是,关闭防火墙,重新启动SQL SERVER和java IDE,进行测试,
如果系统仍提示上述错误,尝试下列步骤
3 检查SQL SERVER 端口号及是否启用了TCP/IP协议,具体步骤:
1)打开"企业管理器",打开控制台根目录>SQL Server 组>数据库
2)在相应"数据库"上单击右键,选择"属性"
3)选择"常规"选项卡,点击"网络配置",如启用的协议中无"TCP/IP协议"将其加入
4)选择"TCP/IP协议",点击"属性",检查其端口号是否为1433
5)如端口号为1433将其修改为其它端口号,修改jdbc连接语句,将端口号同样改为新启用的端口号,如jdbc:microsoft:sqlserver://server_name:1400(假设新端口号为 1400)
以下的方法你每种的去试试:
#检查一下sql server的connection有没有full.
#如果是认证的问题.
可到sql enterprice manager->指定server->内容->安全性.
把验证改为 SQL server 及 windows.
#点选属性检查一下port是否正确.
#执行%MSSQL_HOME%/80/Tools/Binn/SVRNETCN.exe
把TCP/IP启用.
#关掉防火墙.
#把SQL server update到sp3:
http://www.microsoft.com/sql/downloads/2000/sp3.asp
分享到:
相关推荐
总结JDBC连接SQLServer的错误Error establishing socket
"java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver" ...[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. 解决了jsp连接 sql server 2000的问题
SQL Server 出现Error: 1326错误 我们在在使用SQL Server时都会遇到使用SQL Server Management Studio无法连接远程数据库实例的问题,错误描述信息摘录如下: An error has occurred while establishing a ...
此文档中详细的记载了,谈JDBC SQLSERVERError establishing socket,希望可以帮到下载的朋友们!
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, ...
准备环境 Windows XP+JDK5.0+Microsoft SQL Server 2000个人版+JCreator(或Eclipse) 下载数据库驱动程序SQL Server 2000 Driver for JDBC Service Pack 3.exe...1、是不是出现了Error establishing socket之类的错误
你编写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 ...
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 ...
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at ...
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:...
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...
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 ...
-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 ...
Laravel开发-flickering Flickr API的现代接口
-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,好文章
NATBLASTER-Establishing TCP Connections Between Hosts Behind NATs.pdf