Azure SQL Database
An Azure relational database service.
6,326 questions
Refresh token
![](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(19.2, 97%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHZ%3C/text%3E%3C/svg%3E)
Henry Zhanhao Zhang
5
Reputation points
How can I refresh og make a token longer so I don't get : "Login failed for user '<token-identified principal>'. Token is expired.". When I am doing data ingestion in to Azure SQL database
Azure SQL Database
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,514 questions
{count} votes
-
![](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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SSingh-MSFT 16,371 Reputation points Moderator2023-06-07T09:36:36.07+00:00 Hi Henry Zhanhao Zhang •,
Welcome to Microsoft Q&A forum and thanks for using Azure Services.
As I understand, you want to refresh token.
Could you please let us know at what step you are getting Login failed error?
What are the steps you are following and configuration details of the database should help.
Thanks
-
Henry Zhanhao Zhang 5 Reputation points
2023-06-07T11:37:25.2533333+00:00 When I am doing databricks jobs from codespace, the jobs being stopped and received this error:
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '<token-identified principal>'. Token is expired.
-
![](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(316.8, 85%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Deba Nayak 61 Reputation points2023-06-11T20:38:28.09+00:00 Hi @SSingh-MSFT
We are using Service Principal to allow data bricks to insert into Azure SQL and MSAL (python) is used to generate a token. While running one of the long-running insert statements, we are getting "Token Expired" after a couple of hours. Is there a way to either extend the lifetime of a token or refresh the token on the fly?
Sign in to comment
Sign in to answer