关于SqlServer2005的jdbc连接的TCP/IP错误问题解决

最新推荐文章于 2021-03-09 21:55:23 发布
最新推荐文章于 2021-03-09 21:55:23 发布
阅读量502 收藏
点赞数
分类专栏： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/q727668704/article/details/46789601
版权
解决方案（自己照图配置，ok）
   打开SQL Server Configuration Manager，然后按如下图的配置：



VIA一定不就要开，否则，服务重启不了，我的是这样！



   
网络方案（仅供参考）
在 SQL Server 2005 里面，如果出现到主机的 TCP/IP 连接失败。
java.net.ConnectException: Connection refused: connect!
首先是因为sqlserver2005默认情况下是禁用了tcp/ip连接。
您可以在命令行输入：telnet localhost 1433进行检查，这时会报错：正在连接到localhost...不能打开到主机的连接，在端口 1433: 连接失败
启动tcp/ip连接的方法：
打开 \Microsoft SQL Server 2005\配置工具\目录下的SQL Server Configuration Manager--->网络配置选择mssqlserver协议, 然后右边窗口有个tcp/ip协议，然后启动它，把sqlserver服务停了，然后在启动。问题就解决了！
这时在命令行输入：telnet localhost 1433就不会再报错了，窗口显示为一片黑，即为正常



特例：
1，打开SQL server configuration manager--->网络配置--->Tcp/Ip，右键选择开启Tcp/IP
2，双击修改Tcp/IP端口号。注意不是所有机器的端口号都是1433，打开Tcp/Ip界面后，先查看最底下一栏的动态端口号是多少，像我的机器就是2921.在这儿纠结了很久，原先全部的时间都浪费在把端口设置成1433！！
然后把上面所有的动态端口号都改为2921（你自己机器的动态端口号），所有Enable的选项都选YES。然后应用，确定。
附：我是索性把所有的不论动态端口还是端口都设成了2921，调了半天，生气了！
3，重启数据库连接服务。
然后在命令行输入：telnet localhost 端口号，如果窗口不显示连接不上，出来一个黑屏，那么就表示连接成功了。
然后去你写的类里面连接数据库吧，起码不会再有“到主机的TCP/IP连接失败”的问题了！
  • 大小: 372.6 KB
  • 大小: 187.4 KB
Evan_Super
关注
专栏目录
java连接SQL数据库时出现的com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。问题的解决经验
chenxin_1的博客
05-14 4021
如题所述，我作为一个菜鸟，在运行程序时遇到了如下问题 com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect 最开始的开始，请你确认，并不是因为你的代码大小写，甚至是一个空格，一个句号导致出现错误。 经过我百度和看大神们的博客，总结出可能是如下几个问题： SQL server 服务端口未写对，可以在SQL服务管理器中
Druid连接SQL Server报错：The TCP IP connection to the host 127.0.0.1, port 1433 has failed.
SCscHero的博客
01-23 3608
阅文时长 | 1.05分钟 字数统计 | 1684字符 主要内容 | 1、引言&背景 2、解决方案 3、声明与参考资料 『Druid连接SQL Server报错：The TCP IP connection to the host 127.0.0.1, port 1433 has failed. 』 编写人 | SCscHero 编写时间 | 2022/1/19 PM5:41 文章类型 | 系列 完成度 | 已完成 座右铭 每一个伟大的事业，..
sqlserver 2005 到主机 的 TCP/IP 连接失败
03-24
NULL 博文链接：https://aaagu1234.iteye.com/blog/1030113
SQL2005 到主机的TCP/IP连接失败 解决方案
回忆录
04-12 295
在 SQL Server 2005 里面，如果出现到主机的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect! 首先是因为sqlserver2005默认情况下是禁用了tcp/ip连接。 您可以在命令行输入：telnet localhost 1433进行检查，这时会报错：正在连接到localhost...不...
sql server 2005远程连接
疯狂的流浪狗
01-19 1033
本文轉自：http://hi.baidu.com/ren_long_/blog/item/aabe18177b771d12962b435c.html 连接到 SQL Server 2005 时，在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败 (Microsoft SQL Server，错误: 10060)步骤1.打开SQL Server Con
启用SQL2005TCP/IP协议
热门推荐
xqf222的专栏
05-25 1万+
在命令行输入：telnet localhost 1433进行检查，这时会报错：正在连接到localhost...不能打开到主机的连接，在端口 1433: 连接失败    启动TCP/IP连接的方法：<br />    打开开始—程序—Microsoft SQL Server 2005—配置工具—SQL Server Configuration Manager-- SQL Server 2005网络配置—MSSQLSERVER的协议, 然后右边窗口有个TCP/IP协议，点右键“启用”.在开始—程序—管理工具—
SQL Server 2005 提示“到主机 的 TCP/IP 连接失败”错误
wtwshui的专栏
04-16 965
连接SQL Server时出现“com.microsoft.sqlserver.jdbc.SQLServerException: 到主机   的 TCP/IP连接失败。 java.net.ConnectException: Connection refused: connect”错误，解决方法如下： 上面错误的原因是因为SQL Server 2005默认情况下是禁用了TCP/IP连接，现在启
通过端口1433连接到主机127.0.0.1的 TCP/IP 连接失败，错误:“connect timed out”的解决方法
09-03
在使用SQL Server数据库时，有时会遇到通过端口1433连接到本地主机127.0.0.1的TCP/IP连接失败的问题，错误提示为“connect timed out”。这个错误通常意味着客户端无法在指定时间内与服务器建立连接，可能是由于网络...
JDBC与SQL Server 2005的连接方式
11-15
### JDBC与SQL Server 2005的连接配置详解 #### 一、引言 在当前的软件开发环境中，数据库的高效访问对于提高应用程序性能至关重要。JDBC (Java Database Connectivity) 是 Java 开发语言中用于连接数据库的标准...
JDBC连接Sql Server 2005总结
09-10
首先，进行JDBC连接SqlServer 2005之前，需要做好准备工作。准备工作包括下载所需的软件，包括Microsoft SQL Server 2005 Express Edition、SQL Server Management Studio（SSMS）和SQL Server 2005的JDBC驱动。 ...
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
04-08
Transact-SQL, or T-SQL, is Microsoft Corporation’s powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational database management systems (RDBMS). You may already have a basic idea of what SQL is used for, but you may not have a good understanding of the concepts behind relational databases and the purpose of SQL. This book will help you build a solid foundation of understanding, beginning with core relational database concepts and continuing to reinforce those concepts with real-world T-SQL query applications. If you are familiar with relational database concepts but are new to Microsoft SQL Server or the T-SQL language, this book will teach you the basics from the ground up. If you’re familiar with earlier versions of SQL Server, it will get you up-to-speed on the newest features. And if you know SQL Server 2005, you’ll learn about some exciting new capabilities in SQL Server 2008. Information Technology professionals in many different roles use T-SQL. Our goal is to provide a guide and a reference for IT pros across the spectrum of operational database solution design, database application development, and reporting and business intelligence solutions. Database solution designers will find this book to be a thorough introduction and comprehensive reference for all aspects of database modeling, design, object management, query design, and advanced query concepts. Application developers who write code to manage and consume SQL Server data will benefit from our thorough coverage of basic data management and simple and advanced query design. Several examples of ready-to-use code are provided to get you started and to continue to support applications with embedded T-SQL queries. Report designers will find this book to be a go-to reference for report query design. You will build on a thorough introduction to basic query concepts and learn to write efficient queries to support business reports and advanced analytics. Finally, database administrators who are new to SQL Server will find this book to be an all-inclusive introduction and reference of mainstream topics. This can assist you as you support the efforts of other team members. Beyond the basics of database object management and security concepts, we recommend Beginning SQL Server 2005 Administration and Beginning SQL Server 2008 Administration from Wrox, co-authored in part by the same authors. This book introduces the T-SQL language and its many uses, and serves as a comprehensive guide at a beginner through intermediate level. Our goal in writing this book was to cover all the basics thoroughly and to cover the most common applications of T-SQL at a deeper level. Depending on your role and skill level, this book will serve as a companion to the other Wrox books in the Microsoft SQL Server Beginning and Professional series.. This book will help you to learn: * How T-SQL provides you with the means to create tools for managing databases of different size, scope, and purpose * Various programming techniques that use views, user-defined functions, and stored procedures * Ways to optimize query performance * How to create databases that will be an essential foundation to applications you develop later Each section of this book organizes topics into logical groups so the book can be read cover-to-cover or can be used as a reference guide for specific topics. We start with an introduction to the T-SQL language and data management systems, and then continue with the SQL Server product fundamentals. This first section teaches the essentials of the SQL Server product architecture and relational database design principles. This section (Chapters 1–3) concludes with an introduction to the SQL Server administrator and developer tools. The next section, encompassing Chapters 4 through 9, introduces the T-SQL language and teaches the core components of data retrieval, SQL functions, aggregation and grouping, and multi-table queries. We start with the basics and build on the core structure of the SQL SELECT statement, progressing to advanced forms of SELECT queries. Chapter 10 introduces transactions and data manipulation. You will learn how the INSERT, UPDATE, and DELETE statements interact with the relational database engine and transaction log to lock and modify data rows with guaranteed consistency. You will not only learn to use correct SQL syntax but will understand how this process works in simple terms. More advanced topics in the concluding section will teach you to create and manage T-SQL programming objects, including views, functions, and stored procedures. You learn to optimize query performance and use T-SQL in application design, applying the query design basics to real-world business solutions. Chapter 15 contains a complete tutorial on using SQL Server 2008 Reporting Services to visualize data from the T-SQL queries you create. The book concludes with a comprehensive set of reference appendixes for command syntax, system stored procedures, information schema views, file system commands, and system management commands. The material in this book applies to all editions of Microsoft SQL Server 2005 and 2008. To use all the features discussed, we recommend that you install the Developer Edition, although you can also use the Enterprise, Standard, or Workgroup editions. SQL Server 2005 Developer Edition or SQL Server 2008 Developer Edition can be installed on a desktop computer running Windows 2000, Windows XP, or Windows Vista. You can also use Windows 2000 Server, Windows Server 2003, or Windows Server 2008 with the Enterprise or Standard edition. The SQL Server client tools must be installed on your desktop computer and the SQL Server relational database server must be installed on either your desktop computer or on a remote server with network connectivity and permission to access. Consult www.microsoft.com/sql for information about the latest service packs, specific compatibilities, and minimum recommend system requirements. The examples throughout this book use the following sample databases, which are available to download from Microsoft: the sample database for SQL Server 2005 is called AdventureWorks, and the sample database for SQL Server 2008 is called AdventureWorks2008. Because the structure of these databases differs significantly, separate code samples are provided throughout the book for these two version-specific databases. An example using the AdventureWorks2008DW database for SQL Server 2008 is also used in Chapter 15.
java连接sqlserver2005 tcp 有时超时,SQL Server 2005 出现到主机 的 TCP/IP 连接失败
weixin_42374596的博客
03-09 168
用jdbc连接SQL Server2005出现到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect!估计是因为sqlserver2005默认情况下是禁用了tcp/ip连接。您可以在命令行输入：telnet localhost 1433进行检查，这时会报错：正在连接到localhost...不能打开到主机的...
SQL Server 2005 问题：TCP/IP无法连接
王以山的专栏
09-27 1350
 刚碰到这个问题时，以为是应用服务器和数据库服务器没连通，查了半天的网络结果网上一查，跟SQL Server 2005有关，你太阳的！   开始菜单-SQLServer2005-配置工具-SQL Server Configuration Manager-SQLserver2005网络配置-MSSQLSERVER的协议-双击TCP/IP协议   把IP改成当前使用的，当然，端口也要确保正确。再重启数
sqlserver2005 连接不上问题解决！
zhuangjx的专栏
02-01 862
       最近装了vs2005，使用其自带的sqlserver2005，发现使用管道可以链接使用，使用tcp/ip则无法连接，提示找不到服务器，百思不得其解，搞了几天，终于解决。       无法链接的原因：       1 sqlserver2005默认不支持远程链接       2 sqlserver2005服务端默认端口为1553，而client链接的默认端口为1433 
彻底解决SQL Server 2005远程连接错误
lhhui668的专栏
09-13 864
<br />连接到 SQL Server 2005 时，在默认的设置下 SQL Server 不允许进行远程连接,彻底解决此问题的步骤如下： <br /> <br />步骤1.<br /> <br />打开SQL Server Configuration Manager，查看里面的SQL Native Client 配置，判断里面的别名是否配置。<br />注意：如果远程连接异地数据库，可以使用此种方法进行别名配置，连接异地数据库。<br /> <br />步骤2.<br />彻底解决SQL SERVER
该驱动程序只能与 SQL Server 2000 或更高版本一起使用
dzx_2016的博客
06-07 5433
异常com.microsoft.sqlserver.jdbc.SQLServerException: 通过端口 1433 连接到主机 localhost 的 TCP/IP 连接失败。错误:驱动程序收到意外的登录前响应。请验证连接属性，并检查 SQL Server 的实例正在主机上运行，且在此端口接受 TCP/IP 连接。该驱动程序只能与 SQL Server 2000 或更高版本一起使用。
sqlsever2005限指定IP访问数据库--登录触发器实现
xuanshilee的专栏
12-08 1354
1.查看本机sql server 2005当前版本　　网上很多地方写的是，sqlserver升级到sp2及以上，就可以写登录触发器了。可是很多人反应，自己sqlserver是sp2的时候，LOGON也是无效事件。　　你是不是用select  @@version 这个语句查询的sqlserver版本的呢？　　在新建查询里，输入　　　　select @@version 　　将会得到　　　　Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24
解决JDBC连接SQL Server 2000/2005/2008的问题
"关于使用JDBC连接SQL Server 2008时遇到的问题及解决方案" 在Java开发中，使用Java Database Connectivity (JDBC) API连接SQL Server 2008数据库时，可能会遇到一系列的问题。以下是一些常见的问题及其解决方法： ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值