解决.net core3.1使用docker部署在Ubuntu上连接sqlserver报error:35的问题
2023-09-27 14:25:38 时间
最近把一个项目从core2.2迁移至core3.1,在本地win上跑没有问题,但是上线到生产Ubuntu docker环境下连接不上sqlserver报以下错误。
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)
stacktrace: at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at
折腾了一晚终于搞定了,原来是core3.1 image的问题,大概是core3.1默认image的ssl证书设置的问题,更改为FROM mcr.microsoft.com/dotnet/core/sdk:3.1-bionic后终于恢复正常了。
相关文章
- Sqlserver表分区
- Sqlserver_视图
- Sqlserver_判断该路径是否存在该文件
- mysql监控工具sqlprofiler,类似sqlserver的profiler工具安装(一)
- oracle与sqlserver区别
- Oracle Gateways 方式创建dblink 连接 SQLSERVER数据库
- [读书笔记]SQLSERVER企业级平台管理实践读书笔记02
- SQLSERVER 执行过的语句查询
- SqlServer—Base64编码、解码
- SqlServer性能检测和优化工具使用详细
- SQLserver视图中定义参数
- SqlServer时间戳与普通格式的转换
- [ASP.NET][Session] 使用 SQLServer 会话管理解决 Session 丢失问题
- sqlserver性能调优入门篇
- sqlserver 2008备份与还原