cancel
Showing results for 
Search instead for 
Did you mean: 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 

Databricks connect - SQL Server - Login error with all purpose cluster

erigaud
Honored Contributor

Hello everyone,

I'm using the Databricks connect feature to connect to an SQL server on cloud.

I created a foreign catalog based on the connection but whenever I try to access the tables, I get a login error : 

erigaud_0-1727337571433.png

I have tried with a serverless cluster and got a different error (firewall). When I added the ip of the serverless cluster to the networking configuration of the cloud database, I was able to connect without issue, showing that the credentials are correct.

Does someone have an idea as to why I'm seeing the login error ? 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions

erigaud
Honored Contributor

Solved.

Turns out it was a networking issue, once the subnets from databricks where allowed by the cloud sql server we managed to connect. The error message is misleading because the credentials were correct

View solution in original post

1 REPLY 1

erigaud
Honored Contributor

Solved.

Turns out it was a networking issue, once the subnets from databricks where allowed by the cloud sql server we managed to connect. The error message is misleading because the credentials were correct

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group