topic Connect SQL server using windows authentication in Data Engineering

Connect SQL server using windows authentication

Data_Analytics_ — Thu, 14 Oct 2021 14:52:33 GMT

How do I connect to a on-premise SQL server using window authentication from a databricks notebook

Re: Connect SQL server using windows authentication

User16829050420 — Thu, 14 Oct 2021 15:01:12 GMT

We should have network setup from databricks Vnet to the on-prem SQL server.

Then the connection from the databricks notebook using JDBC using Windows authenticated username/password - https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases

Re: Connect SQL server using windows authentication

Data_Analytics_ — Thu, 14 Oct 2021 15:05:08 GMT

Thanks Ashwin

Re: Connect SQL server using windows authentication

DBXC — Wed, 26 Apr 2023 14:54:26 GMT

Would someone provide example with IntegratedSecurity instead of user name and password?

Is this even possible with Databricks? We do have Azure AD sync'd. Any additional steps to allow IntegratedSecurity in connection string for better security control?