JDBC/ODBC CONNECTION TO AZURE DATABRICKS Fails due to SSL CERTIFICATE

Question

JDBC/ODBC CONNECTION TO AZURE DATABRICKS Fails due to SSL CERTIFICATE

samanth m 11

I am facing issue connecting to databricks from powerbi

1 answer

Your answer

Answer 1

PRADEEPCHEEKATLA 91,751

Hello @samanth m ,

Welcome to the Microsoft Q&A platform.

You may follow the below steps to resolve the issue.

Make sure the certificate has been added or not in your local machine and current user certification store by following these steps:
Start | Run | certlm.msc
Expand "Trusted Root Certification Authorities' and select 'Certificates’.
Search for the certificate SSL certificate whether it is installed or not?
If it is not present, search for it in the Current User's certification store by Using below command.
Start | Run | certmgr.msc
If the certificate is found under the current user's cert store, but not under Local Machine, that will stop any other users from successfully establishing an SSL connection.
If the certificate is NOT found in the correct location, it must be imported.
If it is not installed, please try to contact server Administrator to install the certificate.
Try to download the latest version of desktop by using this link https://www.microsoft.com/en-us/download/details.aspx?id=58494 and check the issue behaviour.

Hope this helps. Do let us know if you any further queries.

------------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

samanth m 11 Reputation points

2021-04-05T10:42:24.337+00:00

As I checked there is no SSL certificates under either current user or local computer.Do I need to install SSL certificate in both local system and current user ?
PRADEEPCHEEKATLA 91,751 Reputation points

2021-04-05T13:08:01.467+00:00

Hello @samanth m ,

Yes, you need to install SSL Certificate in both local and current user.
PRADEEPCHEEKATLA 91,751 Reputation points

2021-04-08T03:58:34.543+00:00

Hello @samanth m ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
samanth m 11 Reputation points

2021-04-08T06:42:15.53+00:00

Hello Pradeep,
May be that would be the solution but in my Lap NETSKOPE client which is third party tracker blocking the connection between databricks and powerbi.Once that is disabled connection has been established.But it should be kept Turned On continuesly so what we did is Netskope has added JDBC link of particular cluster is added in their Netskope client so that it will allow to connect
PRADEEPCHEEKATLA 91,751 Reputation points

2021-04-08T10:37:12.557+00:00

Hello @samanth m ,

Glad to know that your issue has resolved. And thanks for sharing the solution, which might be beneficial to other community members reading this thread.

----------------------------------------------------------------------------------------

Do click on Accept Answer and Up-Vote on the post that helps you, this can be beneficial to other community members.
PRADEEPCHEEKATLA 91,751 Reputation points

2021-04-09T09:27:29.947+00:00

Hello @samanth m ,
Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!

Share via

JDBC/ODBC CONNECTION TO AZURE DATABRICKS Fails due to SSL CERTIFICATE

1 answer

Your answer