dbContext.SaveChanges(); error

SSIS and Import/Export
1

After looking at this problem for quite a few days, I don't know if the error is related to SQL code, or specifically to being able to store a new record in an SQL Server database.

Everything seems to go fine(though I cannot tell) until the following statement:

dbContext.SaveChanges();

I keep getting the following error message:

Microsoft.Data.SqlClient.SqlException: '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.)'

Any ideas would be greatly appreciated!

2

One idea:

The certificate chain was issued by an authority that isn't trusted - SQL Server | Microsoft Learn

3

I added "TrustServerCertificate=True;" to the connection string, and I get the same result.
Any other ideas as to how to eliminate the problem?

4

Have you confirmed that your certificate is still valid? That it hasn't expired or been revoked by the certificate authority? That the certificate authority hasn't been revoked?

Example:

That's dated a month ago, there may be more recent ones.