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

问题:部署在windows 上运行一切正常,部署在linux系统报以下错误:

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=11; handshake=702; [Login] initialization=1; authentication=5; [Post-Login] complete=14012;

 

解决方案:SqlClient现在不支持Linux的SP1连接。Sqlserver 2008 R2需要升级安装SP3 Service Pack

参考资料:https://www.cnblogs.com/xiaxiaolu/p/10309064.html

https://www.cnblogs.com/yyfh/p/11757976.html

posted @ 2020-08-05 17:36  优秀的代码搬运工zz  阅读(1066)  评论(0编辑  收藏  举报