A connection was successfully established with the server but then an error

最新推荐文章于 2025-02-16 01:25:12 发布
最新推荐文章于 2025-02-16 01:25:12 发布
阅读量749 收藏 8
点赞数 9
文章标签： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/codinglab/article/details/135572127
版权
本文描述了在使用EntityFrameworkCore(EFCore)构建数据库时遇到的错误，并提供了在连接字符串中添加`Encrypt=True;TrustServerCertificate=True;`以解决该问题的方法。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

在使用EFCore生成数据库的时候，报上面的错误！

解决方法：

加（Encrypt=True;TrustServerCertificate=True;）即可：

"ConnectionStrings": {

"DefaultConnection": "Data Source=LAPTOP;Initial Catalog=DB;persist security info=True;User ID=sa;Pwd=XXXXX;Encrypt=True;TrustServerCertificate=True;"

},

算盘
关注
已成功与服务器建立连接，但在登录过程中发生错误。（提供程序：SSL提供程序，错误：0-证书链是由不受信任的颁发机构颁发的。)”
初时点默
04-24 1万+
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - 证书链是由不受信任的颁发机构颁发的。)”
异常：A connection was successfully established with the server, but then an error occurred during the
weixin_51870728的博客
03-25 5498
原因：为什么包一降级就行了？这里涉及的知识我不了解，搞不清来龙去脉，有懂得朋友可以指点一下。网上的资料不多，很多说改连接字符串内容的，对我的情况无效，单独将linux中的openssl降级也无效，几种一起上才行，我觉得这里的主要起作用的还是sqlclient包降级。（2）将system.Data.SqlClient包替换为Microsoft.Data.SqlClient3.0.1。（3）链接字符串修改：TrustServerCertificate=true;
【报错解决】Sql server 2022连接数据库时显示证书链是由不受信任的颁发机构颁发的
最新发布
web18296061989的博客
02-16 991
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - 证书链是由不受信任的颁发机构颁发的。原因是尝试使用不可验证的证书与 SQL Server 建立加密连接时，会发生此错误。再点连接，就可以直接进入页面了。
A connection was successfully established with the server, but then an error occurred during the log
weixin_46407807的博客
11-11 3575
报错：A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - 证书链是由不受信任的颁发机构颁发的。在数据库连接字符串加上：TrustServerCertificate=True。
C#异常处理 | 连接成功但登陆异常/管道另一端上无任何进程Error: A connection was successfully established with the server, but
m0_50707858的博客
06-15 2816
问题：C#连接数据库做教务系统的时候，之前的登录功能可以成功实现，但是隔天突然在 sqlConnection.Open(); 处报错。 Error: A connection was successfully established with the server, but then an error occurred during the login process. 参考了许多文章，从sql server配置管理器中重新启用也不管用 最后在Sql server中检查更新，发现SSMS需要更新。
.netcore连接sqlserver报错：A connection was successfully established with the server, but
热门推荐
火焰
05-13 2万+
当把.netcore应用程序部署到linux或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) 这个报错的原因是因为
A connection was successfully established with the server, but then an error occurred during the login process如何解决
06-04
"A connection was successfully established with the server, but then an error occurred during the login process" 这个错误通常是由于无法成功验证登录凭据而引起的。可能的原因包括用户名或密码不正确、账户...
A connection was successfully established with the server,but then an error occurred during the login process.(provider:SSL Provider,error:0
07-30
已经成功地与服务器建立了连接，但是在登录过程中遇到了错误。（提供商：SSL提供商，错误代码：0） 这个信息通常表示在尝试通过安全套接字层（SSL）协议进行身份验证和数据交换时遇到了问题。SSL Provider（即SSL...
已成功与服务器建立连接，但是在登录前发生错误
梦翔九天
08-29 2560
VS在项目启动的时候报错A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - 等待的操作过时。    解决方法：在管理员权限下，在命令行里执行n
连接sqlserver2022的时候报a connection was successfully established with the server, but then an error 的解决
花花鱼的专栏
06-12 6388
初始连接sqlserver2022的时候，报证书链是不受信任的颁发机构...的解决方法。
.net6使用EfCore模型驱动创建数据库时报错A connection was successfully established with the server, but then an erro
mrlijack的博客
02-20 4212
这是数据库连接字符串的问题，但是安装sqlServer2014时采用windows验证身份验证（我Windows10 系统时没有设置登录密码的）或者SQL Server身份验证。机翻：已成功与服务器建立连接，但在登录过程中发生错误。（提供程序：SSL提供程序，错误：0-证书链是由不受信任的颁发机构颁发的。数据库版本：SQL Server2014。visualstudio版本：2022。数据库创建采用模型驱动。
EntityFramework Core 报错 A connection was successfully established with the server, but then an err
情绪不稳定的98年程序员
01-05 1675
最理想的解决方法是确保 SQL Server 使用的证书是由一个受信任的证书颁发机构签发的，并将该证书添加到客户端的信任证书存储中。如果这是不可能的，你可以暂时禁用证书验证，但这会带来安全风险，因此仅限于开发环境使用。
A connection was successfully established with the server, but then an error occurred during the pre
qq_32109957的博客
08-16 1万+
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) 出现问题的 asp.net core 程序是跑在容器中的，容器镜像用的是mcr.microsoft.com/dotnet/c..
c# 使用MS SqlServer，连接成功，但是还报异常A connection was successfully established with the server, but then an ...
weixin_33774308的博客
11-26 7431
c# 使用MS SqlServer，连接成功，但是还报异常A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0。。。。...
C# SqlServer，连接成功，但是还报异常A connection was successfully established with the server, but then an ...
王鹤霖的专栏 三人行必有我师
03-25 5927
provider: SSL Provider A connection was successfully established with the server, but then an ... 注意此问题，关于SSL 查找官方文档，问题原因 解决办法： 设置SSL未 未配置即可，重启服务器
efcore 8A connection was successfully established with the server, but then an error occurred during
天马3798
02-05 696
或者加（Encrypt=True;
【C#】A connection was successfully established with the server, but then an error occurred during the
墨苒孤的博客
07-04 3457
已成功与服务器建立连接，但在登录过程中出现错误。（提供程序：SSL提供程序，错误：0-证书链是由不受信任的颁发机构颁发的
SQL - A connection was successfully established with the server, but then an error occurred during t...
weixin_30768661的博客
12-20 1507
I am getting following error when i am trying to connect Production DB from Local Environment. I was able to connect Production DB before, but suddenly i am getting following error, any idea? A...
WebApi A connection was successfully established with the server, but then an error occurred during
qq_53679247的博客
05-30 2196
目录 错误截图： 解决方案： 再次运行成功！ 错误截图： 解决方案： 在连接字符串后面加上这段代码 ;TrustServerCertificate=true 再次运行成功！
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值