Forum Discussion
Gateway stopped working - SSL certificate error
Hello cgapmmg,
If you still face the issue then please consider raising a support ticket for further assistance.This will allow the engineering team to investigate the issue in detail and provide a resolution or guidance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft LearnThankyou for your understanding.
I solved it by adding the parameter AllowSelfSignedServerCert = 1 to the microsoft.impalaodbc.ini file, and that fixed the issue.
I was getting the error:
ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect
This happened after a server update, which now uses a self-signed certificate. I found that unless AllowSelfSignedServerCert is explicitly set to 1 in the microsoft.impalaodbc.ini file, the Microsoft Impala ODBC driver assumes a default value of 0, which causes the SSL certificate verification to fail.Now my gateway is running fine.
Thanks to everyone who tried to help!
Hi v-sgandrathi !
My issue persists. I'm still working with the support to find a solution on it. The have my gateway log and browser log. I hope it will be solved soon.
Thanks!
Hello cgapmmg,
Thank you for providing the update. I sincerely hope that the issue will be resolved promptly and that you will be able to find an effective solution.
Your efforts are much appreciated, and I look forward to hearing more about the progress.
Thankyou for using Microsoft Community Forum.