10-14-2021 07:52 AM
How do I connect to a on-premise SQL server using window authentication from a databricks notebook
10-14-2021 08:01 AM
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
10-14-2021 08:01 AM
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
10-14-2021 08:05 AM
Thanks Ashwin
04-04-2022 03:29 PM
Hi @Sudhakar Nandigam , Were you able to connect to the on-premise SQL server?
04-26-2023 07:54 AM
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?