Installing an Update from 6.2024.520.0 or later

Updated by Cheryl Wallace

The update to 6.2024.520.0 can require a change to the appsettings.json configuration file depending on your SQL Server configuration. This is due to a breaking change from Microsoft in Microsoft.Data.SqlClient 4.0.

Prior to Microsoft.Data.SqlClient 4.0, the default in connection strings was Encrypt=false. Effective with Microsoft.Data.SqlClient 4.0, the default is now Encrypt=true.

  • If your SQL Server is configured with a valid certificate and the client trusts the certificate, no change is required.
  • If your SQL Server is not configured with a valid certificate or the client does not trust this certificate, edit your connection string to add the parameter Encrypt=false.

Example:

"ToolHoundConnection": "Server=[COMPUTER_NAME]\\[INSTANCE_NAME];User Id=[USER_NAME];Password=[PASSWORD]; Max Pool Size=10; Encrypt=false"

If these conditions are not met, users will be unable to log in and the following error will be displayed:

One or more errors occurred. (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.))

Read more about this change here or from Microsoft here and here.

See also

​Copyright © 2020-2024 ToolHound Inc. All Rights Reserved.

How did we do?