Connect SQL server using windows authentication

[Data_Analytics_]

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

[User16829050420 · Accepted solution]

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

[Data_Analytics_]

Thanks Ashwin

[DBXC]

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?