Databricks Community

Nick_Pacey

Hi,Is there a limitation or know issue when creating a foreign catalog to a SQL Server 2008 R2?We are successfully able to connect to this SQL Server through a JDBC connection string. To make this work, we have to switch the Java encrypt flag to fal...

Nick_Pacey · 02-18-2025

Hi,We are creating a lakehouse federated connection to our 2016 On Prem SQL Server. This has an instance in place, so we only want and need to connect to this instance. From this connection, we want to create a foreign catalog of a database on the ...

Nick_Pacey · 02-17-2025

Hi,Does anyone know if and when Databricks will enable the Preview option to work for PDF files stored in a Catalog Volume?Thanks!Nick

Nick_Pacey · 02-11-2025

Hi,We are trying to connect to an On-prem SQL Server instances using JDBC (we really want to use a Federated connection, testing JDBC first). We have successfully done this for one of the SQL Servers we have, but cannot get it to work for the other....

Nick_Pacey · 02-12-2025

We've finally found and understood the issue. It was down to a configuration on the SQL Server to use dynamic ports, but then define the port to listen on buried in the network configuration. Once we had the right port to talk on, the JDBC connecti...

Nick_Pacey · 02-11-2025

Thanks for coming back to me!I'm using a different python SQL library, but my config is almost the same as your code above. I'm having to use the IP address of the server rather than the name (does this matter?). This is the error I get..com.micros...

Databricks Community

User Stats

User Activity

Foreign Catalog error connecting to SQL Server 2008 R2

Issue when trying to create a Foreign Catalog to a On Prem SQL Server Instance

Catalog Volume Preview for PDF files

Connecting to a On Prem SQL Server Instance using JDBC

Re: Connecting to a On Prem SQL Server Instance using JDBC

Re: Connecting to a On Prem SQL Server Instance using JDBC