SqlException：ConnectionTimeout Expired. The timeout period elapsed during the post-login phase

2022-10-14

linux系统部署.netcore程序后,访问某台sqlserver 2008 r2数据库

connection timeout expired. the timeout period elapsed during the post-login phase. the connection could have timed out while waiting for server to complete the login process and respond; or it could have timed out while attempting to create multiple active connections. the duration spent while attempting to connect to this server was - [pre-login] initialization=90; handshake=301; [login] initialization=0; authentication=0; [post-login] complete=14001;

sqlclient现在不支持linux的sp1连接。sqlserver 2008 r2需要升级安装sp3 service pack

《SqlException：ConnectionTimeout Expired. The timeout period elapsed during the post-login phase.doc》

下载本文的Word格式文档，以方便收藏与打印。

相关推荐

MySQL报错：Cause: java.sql.SQLException: Incorrect string value: '\xE6\x9D\xA8","...' for column 'obj_value' at row 1

$MySQL报错：Cause: java.sql.SQLException: Incorrect string value: '\xE6\x9D\xA8","...' for column 'obj_value' at row 1$

1、插入MySQL表时，报错：Cause: java.sql.SQLException: Incorrect string value: '\xE6\x9D\xA8","...' for column 'obj_value' at row 1 错误原因：参数中带有emoji表情，插入数据库时，一些特殊字符如“...
2023-07-29编程代码incorrect,SQLException,报错
Zookeeper中Session Timeout的那些事

前言： RDS系统致力于MySQL数据的高可用，高可靠，高性能以及在线扩展功能，实现这些特性的主要逻辑功能都运行在管理服务器上，一旦管理服务器宕机，数据库的在线扩展功能／备份功能／故障恢复功能等都无从谈起。...
2023-06-20编程教程session,timeout,Zookeeper
Got timeout reading communication packets解决方法

Got timeout reading communication packets解决方法 http://www.th7.cn/db/mysql/201702/225243.shtml [Note] Aborted connection xxxx to db: 问题现象：在tail -f/data/logs/mysql/error.log日志中出现大量的...
2023-06-12编程教程Reading,timeout,解决方法
kafka 消费者 timeout 6000

kafka 消费者 timeout 6000 1：查看zookeeper 的状态，kafka默认是自带zookeeper配置，我建议安装单独的zookeeper 服务，并且配置文件也很简单..直接改zookeeper 的host 跟port 就行； zookeeper 状态查看...
2023-06-02编程教程kafka,timeout,消费者
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERR

dbc 链接orcal出错 java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) 我的是SID错误，本来我用sqlplus连接远...
2023-05-17编程教程io,SQLException,异常
java.sql.SQLException: connection holder is null;

一、问题来源分析出现的错误： Cause: java.sql.SQLException: connection holder is null; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; connection holder is null; nested ex...
2023-05-17编程教程java,SQL,SQLException
java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed

org.springframework.dao.TransientDataAccessResourceException: ### Error updating database. Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allow...
2023-05-17编程教程connection,read,SQLException
java.sql.SQLException: Io 异常: Connection reset

当数据库连接池中的连接被创建而长时间不使用的情况下，该连接会自动回收并失效，但客户端并不知道，在进行数据库操作时仍然使用的是无效的数据库连接，这样，就导致客户端程序报“ java.sql.SQLException: ...
2023-05-17编程教程java,SQLException,异常