Scenario:
When using an external database in an Autoindex job, the database connection has a status of OK in the Local Data Connector Tool, but the Autoindex shows the following error message in the logging:
"Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure."
Solution:
To resolve this error message, please complete the following;
1. Download and install the most recent .NET SDK version.
2. Run the following 3 CMD commands:
2a. dotnet dev-certs https --clean
2b. dotnet dev-certs https
2c. dotnet dev-certs https --trust.
Click "Yes" to install/trust the certificate.
3. Now, check the Autoindex to make sure the data is able to be viewed, then run it.
KBA is applicable to Cloud Organizations ONLY.