This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(304, 61%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
HI,
please can some one guide me how to Establish Connection to SQL server using manage identity in data bricks using manage identity object id
I am using following code
from azure.core.exceptions import ClientAuthenticationError
from azure.identity import DefaultAzureCredential
c_id = DefaultAzureCredential(managed_identity_client_id=client_id)
try:
#https://database.windows.net/.default
#bipp-training-server.database.windows.net/.default
secret = c_id.get_token("https://database.windows.net/.default")
except ClientAuthenticationError as ex:
print(ex.message)
and I am getting DefaultAzureCredential failed to retrieve a token from the included credentials
An Apache Spark-based analytics platform optimized for Azure.
A cloud-based identity and access management service for securing user authentication and resource access
Welcome to the QnA forums
Please check the following tutorial which provide a great explanation step-by-step
https://hevodata.com/learn/databricks-connect-to-sql-server/
You can also go over this Microsoft doc on using JDBC
I assume that you will not have any question after you read it and try it but of you do, then feel free to come back and elaborate what you need
Hi, thanks for the reply but is it possible through using managed identity's object ID @Ronen Ariely
I saw multiple request for this in multiple forums (like this one), but all end up with using SQL authentication instead.
Unfortunately this is not a good time for your question :-)
I did not try it myself and I cannot try anything in the next few days until (if) my azure subscription will be renewed. I already cleaned almost all my subscription's services in the last few days and I cannot test it now.
(1) Check this tutorial on How to Use Managed Identities with Azure SQL Database.
(2) After you have the connection string, then use the same tutorial which I gave you before to use this connection string
Inform us if this worked for you well :-)