How to fix SQL Server 2019 connection error due to certificate issue

0md85ypi 于 2023-03-11 发布在 SQL Server

关注(0)|答案(1)|浏览(203)

I am using a .NET console app to test SQL Server 2019 database connection and get following error message:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

The user id and password are valid. The C# code is not using any encryption. I have not configured any certificate in SQL Server configuration.

Is certificate required in SQL Server 2019?
Can I get a self generated cert from the SQL Server?
If no self-generated cert available, where can I get a valid certificate for free?

sql-server

来源：https://stackoverflow.com/questions/70399243/how-to-fix-sql-server-2019-connection-error-due-to-certificate-issue

1条答案

按热度按时间

x8diyxa71#

To improve the answer, let me sum up the comments:

While setting TrustServerCertificate=True or Encrypt=false in the connection string is a quick fix, the recommended way of solving this issue is to provide a proper certificate for your SQL Server from a trusted CA.

To install a certificate for a single SQL Server instance ( source ):

In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration.
Right-click Protocols for , and then select Properties.
Choose the Certificate tab, and then select Import.
Select Browse and then select the certificate file.
Select Next to validate the certificate. If there are no errors, select Next to import the certificate to the local instance.

赞(0）回复(0）举报 2023-03-11

我来回答

How to fix SQL Server 2019 connection error due to certificate issue

1条答案

相关问题

热门标签

最新问答