SQL management tool連線時出現錯誤:此憑證鏈結是由不受信任的授權單位發出的

 

環境:

MS SQL2022

異常狀況:

SQL management tool連線時出現錯誤:此憑證鏈結是由不受信任的授權單位發出的

解決過程:

錯誤訊息「此憑證鏈結是由不受信任的授權單位發出的」是因為 SQL Server 2022 預設強制執行加密連線。

勾選下午的「信任伺服器憑證」選項，即可正常登入。

Environment:

MS SQL Server 2022

Issue:

When connecting using the SQL management tool, the following error appears:

“The certificate chain was issued by an authority that is not trusted.”

Resolution:

This error occurs because SQL Server 2022 enforces encrypted connections by default.

Enable the “Trust Server Certificate” option in the connection settings, and then you will be able to log in normally.

SQL 2022安裝時卡住不動

環境:

MS SQL2022

Kaspersky endpoint security

異常狀況:

MS SQL2022安裝到一半停住很久，cpu跟ram的使用資源都不會動。

解決過程:

將Kaspersky endpoint security防護暫停後，就會繼續安裝過程，完成剛裝

Environment:

MS SQL Server 2022
Kaspersky Endpoint Security

Issue:

During the installation of MS SQL Server 2022, the setup process gets stuck for a long time.
CPU and RAM usage remain unchanged and the installation does not continue.

Resolution:

After temporarily disabling Kaspersky Endpoint Security protection, the installation process resumes and completes successfully.