topic Unable to connect to Amazon Redshift - SSL certificate verification error in Report Server

Unable to connect to Amazon Redshift - SSL certificate verification error

Anonymous — Tue, 11 Aug 2020 12:27:03 GMT

Recently I've encountered the following error while trying to connect to Redshift through Powerbi:

However, i would like to mention that while using the same credentials, server address etc. i am able to successfully connectto my database while using a query program such as Dbeaver for eg.

Any ideas what might cause this issue?

Many thanks !

Re: Unable to connect to Amazon Redshift - SSL certificate verification error

MarM — Wed, 16 Nov 2022 14:16:36 GMT

Anonymous did you ever got a fix for this issue?

Re: Unable to connect to Amazon Redshift - SSL certificate verification error

rachelgomez1234 — Fri, 18 Nov 2022 06:32:57 GMT

Steps to Fix SSL Certificate Error
Diagnose the problem with an online tool.
Install an intermediate certificate on your web server.
Generate a new Certificate Signing Request.
Upgrade to a dedicated IP address.
Get a wildcard SSL certificate.
Change all URLS to HTTPS.
Renew your SSL certificate.

Greeting,

Rachel Gomez