[SQL Server] A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 — 此憑證鏈結是由不受信任的授權單位發出的。)
今天寫程式連結資料庫，遇見這樣的錯誤
Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 — 此憑證鏈結是由不受信任的授權單位發出的。)
環境 .NET Core 6 / VS 2022
解決方法：DB連結字串 ConnectionString
需要額外加上 TrustServerCertificate=true。不然會出現錯誤
以 appsettings.json 設定檔為例
“ConnectionStrings”: {
“DefaultConnection”: “Server=.\\sqlexpress;Database=資料庫名稱;Trusted_Connection=True;TrustServerCertificate=true;MultipleActiveResultSets=true”
},
相關的錯誤也都可以用上述相同解法
(1) Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 — Encryption(ssl/tls) handshake failed) System.IO.EndOfStreamException: End of stream reached
(2) A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 — The target principal name is incorrect.)
(3) Microsoft.Data.SqlClient.SqlException (0x80131904): 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=837; handshake=394; [Login] initialization=3; authentication=15; [Post-Login] complete=1027; — -> System.ComponentModel.Win32Exception (258): Unknown error 258 at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
我將思想傳授他人， 他人之所得，亦無損於我之所有；
猶如一人以我的燭火點燭，光亮與他同在，我卻不因此身處黑暗。 — — Thomas Jefferson
線上課程教學，遠距教學 (Web Form 約51hr) https://dotblogs.com.tw/mis2000lab/2016/02/01/aspnet_online_learning_distance_education_VS2015
線上課程教學，遠距教學 (ASP.NET MVC 約75~88hr) https://dotblogs.com.tw/mis2000lab/2018/08/14/ASPnet_MVC_Online_Learning_MIS2000Lab
ASP.NET MVC線上課程 第一天 免費看 (5.5小時)
寫信給我，不要私訊 — mis2000lab (at) yahoo.com.台灣 或 school (at) mis2000lab.net
ASP.NET遠距教學、線上課程（Web Form + MVC）。 第一天課程， “完整” 試聽。
……………. facebook社團 https://www.facebook.com/mis2000lab ………………….
……………. YouTube (ASP.NET) 線上教學影片 https://www.youtube.com/channel/UC6IPPf6tvsNG8zX3u1LddvA/
Blog文章 “附的範例” 無法下載，請看 這裡 …… https://dotblogs.com.tw/mis2000lab/2016/03/14/2008_2015_mis2000lab_sample_download
請看我們的「售後服務」範圍（嚴格認定）。
