Login to Azure SQL DB via Personal Access Token

Question

Login to Azure SQL DB via Personal Access Token

Priya Jha 896

Hi All,

Is it possible to login into Azure SQL DB via Personal Access Token

Is there any python code/ code snippet to achieve this?

1 answer

Your answer

Answer 1

GeethaThatipatri-MSFT 29,542 Microsoft Employee Moderator

Hi, @Priya Jha Thanks for posting your question on the Microsoft Q&A platform.
As I understand from the question, you want to know if there is possible to login into Azure SQL DB via Personal Access Token.
Azure AD supports token-based authentication for applications connecting to SQL Database and SQL Managed Instance.
If you're working within Microsoft tools, then your Microsoft account (MSA) or Azure Active Directory (Azure AD) is an acceptable and well-supported approach. But, if you're working with third-party tools that don't support Microsoft or Azure AD accounts – or you don't want to provide your primary credentials to the tool – use PATs to limit your risk.
Please refer to this document here

Please provide more information on your use case so I can provide additional details.

Regards
Geetha

Priya Jha 896 Reputation points

2023-01-10T07:49:00.317+00:00

HI @GeethaThatipatri-MSFT ,

Thanks for your response.

But is there any code snippet available indicating how can we login to Azure SQL DB via PAT's. I have searched for this and was not able to find relating documentation.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-01-11T07:01:43.59+00:00

Hi, @Priya Jha Chances are you would be utilizing pyODBC (https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-Windows) – which leverages the ODBC driver under the hood.

These 2 resources demonstrate utilizing the ODBC access token param:

https://sidequests.blog/2022/02/09/azure-sql-access-token-authentication-with-python-and-azure-powershell-from-azure-devops-pipelines/

https://stackoverflow.com/questions/57193301/pass-azure-ad-token-for-azure-sql-db-in-pre-connection-arguments-to-sqlalchemy-c

More information on the connection string param for the access token:

https://learn.microsoft.com/en-us/sql/connect/odbc/dsn-connection-string-attribute?view=sql-server-ver16#sql_copt_ss_access_token

https://learn.microsoft.com/en-us/sql/connect/odbc/using-azure-active-directory?view=sql-server-ver16#authenticating-with-an-access-token

Please go with the above-mentioned links and let me know if you have additional questions.

Regards

Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-01-13T18:02:21.1133333+00:00

Hi, @Priya Jha Did you had the chance to check the above-provided links.?

If you think your question has been answered, click "Mark as Accept Answer" if just helped click "Vote as helpful". This can be beneficial to other community members reading this forum thread.

Regards

Geetha

Share via

Login to Azure SQL DB via Personal Access Token

1 answer

Your answer