Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

FRESH DATA FROM DATABRICKS

Hi everyone,

 

I would like to refresh data, the source from 1 sandbox DataBricks (not created by me but I have permission rights) but this message occurs:

OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: '[Microsoft][Hardy] (134) File ***: A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded. Error Detail: File ***: An error had occurred while attempting to download the result file.The error is: [Microsoft][DriverSupport] (1120) SSL verification failed because the server host name specified for the connection does not match the "CN" entry in the "Subject" field or any of the "DNS Name" entries of the "Subject Alternative Name" field in the server certificate.. Since the connection has been configured to consider all result file download as retriable errors, we will attempt to retry the download.'..
 
The source is:
= DatabricksMultiCloud.Catalogs("dbc-***.cloud.databricks.com", "/sql/***/***", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null])
 
I try to add  [EnableQueryResultDownload="0"] as solved previous topic but did not work
= DatabricksMultiCloud.Catalogs("dbc-***.cloud.databricks.com",[EnableQueryResultDownload="0"] , "/sql/***/***", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null])
 
Please help
Thank you in advance!
1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

Hi @Anonymous ,
Based on your description and the error information provided, the SSL validation failure appears to be the root cause of the problem. This usually happens when the server's SSL certificate does not match the hostname specified in the connection or the certificate is not trusted by the customer's system.
To solve this problem, you can try the following steps:
First, make sure that the server hostname specified in the connection string matches either the CN (common name) entry or the DNS name entry in the Subject Alternative Name field of the server SSL certificate. Secondly, SSL validation failures can also be due to the system not trusting the certificate. You may need to add the server's SSL certificate to your system's trusted certificate store.
You can refer to the following documents for more information
ssl - Adding Self Signed Certificate to trusted root certificate store using Command Line - Super User


Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

thanks team

v-heq-msft
Community Support
Community Support

Hi @Anonymous ,
Based on your description and the error information provided, the SSL validation failure appears to be the root cause of the problem. This usually happens when the server's SSL certificate does not match the hostname specified in the connection or the certificate is not trusted by the customer's system.
To solve this problem, you can try the following steps:
First, make sure that the server hostname specified in the connection string matches either the CN (common name) entry or the DNS name entry in the Subject Alternative Name field of the server SSL certificate. Secondly, SSL validation failures can also be due to the system not trusting the certificate. You may need to add the server's SSL certificate to your system's trusted certificate store.
You can refer to the following documents for more information
ssl - Adding Self Signed Certificate to trusted root certificate store using Command Line - Super User


Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors