Redshift][ODBC Driver][Server]SSL error: certificate verify failed

Hi Siarhei Melnikau,

Thank you for reaching out to Microsoft QA!

It sounds like you're running into an SSL certificate verification issue with your Redshift connection through the ODBC driver. Here’s what you can try to resolve the "SSL error: certificate verify failed" message:
Driver Setup: Make sure your ODBC driver configuration is correct. You may need to create or update the microsoft.sparkodbc.ini file. Run Notepad or File Explorer as an administrator and save this file in the folder:

text

C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Spark ODBC Driver\

Add the following lines to disable certificate revocation checks:

text
[Driver]
CheckCertRevocation=0

Firewall and Network Settings: If you’re connecting through a VNet Gateway, ensure that your route tables allow outbound traffic for the subnet. You should permit:

1. Service Tags: AzureFrontDoor.FirstParty and OneDsCollector
2. Hostname or IP: crl3.digicert.com or 192.229.221.95 This traffic is necessary for the client to access certificate revocation servers.

JDBC Connection Tweaks: If your setup includes JDBC connections, configuring the connection string with trustServerCertificate=true can help by allowing connections without strict certificate validation. Use this only if your security policies permit.

Driver Updates: Always verify that you are using the latest version of the ODBC driver. Updated drivers often fix SSL/TLS issues and improve compatibility with the latest security protocols.

Additional Resources:
Troubleshooting Power BI and Azure Databricks connection issues

Power BI Proxy and SSL Configuration

Common SSL/TLS errors and solutions

By following these steps, you can mitigate common SSL certificate verification issues while balancing security considerations. If you need help with any specific step, feel free to ask.

This approach ensures your connection is properly configured and optimizes secure communication with your Spark server.

 Hope this helps you get things sorted out! If the issue persists, Please let Us know.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

How I can resolve issue