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!
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 Learn
Thankyou for your understanding.
Hi cgapmmg,
Could you please confirm if the issue has been resolved after raising a support case?
If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.