admin管理员组文章数量:1313331
I created a new azure databricks workspace with these settings:
- vnet injection
- secure cluster connectivity
- front and backend private link
This is to setup a connection from databricks to our on-premise sql server.
The vnet that was injected with the databricks workspace was peered into our hub vnet that has connection to our on-premise network via azure vpn gateway. I also setup a DNS forwarding ruleset on the vnet. I confirmed connectivity to on-prem resources by creating a compute cluster and running the commands while connected to the compute cluster.
%sh
ping sql-serverpany.local
PING sql-serverpany.local (10.0.80.201) 56(84) bytes of data.
64 bytes from 10.10.80.201 (10.0.80.201): icmp_seq=1 ttl=126 time=28.9 ms
64 bytes from 10.10.80.201 (10.0.80.201): icmp_seq=2 ttl=126 time=27.4 ms
64 bytes from 10.10.80.201 (10.0.80.201): icmp_seq=3 ttl=126 time=27.4 ms
64 bytes from 10.10.80.201 (10.0.80.201): icmp_seq=4 ttl=126 time=27.1 ms
64 bytes from 10.10.80.201 (10.0.80.201): icmp_seq=5 ttl=126 time=27.9 ms
%sh
nc -zv sql-serverpany.local 1433
Connection to sql-serverpany.local (10.0.80.201) 1433 port [tcp/ms-sql-s] succeeded!
After confirming connectivity from the compute cluster to our on-prem sql server, I wanted to setup a connection in databricks to use the sql server via Catalog and add an connection. But I'm still getting cannot establish connection to our SQL server DB.
版权声明:本文标题:Azure Databricks Workspace with VNET Injection unable to connect to on-premise SQL Server - Stack Overflow 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1741935218a2405816.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论