今天寫程式連結資料庫,遇見這樣的錯誤
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
寫信給我,不要私訊 — mis2000lab (at) yahoo.com.台灣 或 school (at) mis2000lab.net
ASP.NET遠距教學、線上課程(Web Form + MVC)。 第一天課程, “完整” 試聽。