Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,357 questions
Synapse notebook connect to Azure SQL Database
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 20%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Raj D
616
Reputation points
Greetings!!!
I am working on connecting to Azure SQL Database from an Azure Synapse analytics notebook using Azure Active Directory Integrated authentication using code below.
Code:
import requests
import com.microsoft.aad.ActiveDirectoryIntegrated
#Azure SQL Database Azure Active Directory Integrated
print("Use MSSQL connector to write to master SQL instance ")
servername = "jdbc:sqlserver://sql-server.database.windows.net:1433"
dbname = "
Azure Synapse Analytics
{count} votes
-
PRADEEPCHEEKATLA 90,626 Reputation points Moderator2021-10-05T08:31:52.777+00:00 Hello @Raj D ,
Thanks for the question and using MS Q&A platform.
We are reaching out to the internal team to get more details on this ask. I will be update you once I hear back from the team.
-
PRADEEPCHEEKATLA 90,626 Reputation points Moderator
2021-10-08T06:52:41.257+00:00 Hello @Raj D ,
We are still awaiting for the response from the internal team. I will be update you once I hear back from the team.
Stay Tuned!
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 35%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Freeman, Geoffrey 1 Reputation point2021-10-18T17:48:22.357+00:00 We need this too - how do we install custom drivers to a synapse spark pool?
-
PRADEEPCHEEKATLA 90,626 Reputation points Moderator
2021-10-19T09:05:36.987+00:00 Hello @Freeman, Geoffrey ,
You don’t need to add the connector Apache Spark connector Jar or any package com.microsoft.sqlserver.jdbc.spark to your Synapse Spark pool. The connector is there out of the box for Spark 2.4 and for Spark 3.1 it will be in production most likely in upcoming weeks.
-
Freeman, Geoffrey 1 Reputation point
2021-10-19T16:00:22.763+00:00 so how come we're getting
Failed to load both mssql-jdbc_auth-8.4.1.x64when we try to use ActiveDirectoryIntegrated? I see that JDBC 8.4.1 is supposed to be in the base image, how come jdbc_auth is not part of that? -
Ben 0 Reputation points2023-08-01T13:52:14.1466667+00:00 This is still an issue?
-
Freeman, Geoffrey 1 Reputation point
2023-08-01T16:27:57.51+00:00 honestly I don't know. We never got any support on this, so we moved our customers to databricks.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 73%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
Gnaneswar Reddy Sodini 0 Reputation points2024-06-10T21:01:03.9+00:00 Do we have any update on this i am also facing the same issue? Did anyone resolved it?
Sign in to comment
Sign in to answer