Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support Azure Managed Identities to authenticate to Azure SQL DB #281

Open
mnowrot opened this issue Oct 27, 2023 · 2 comments
Open

Support Azure Managed Identities to authenticate to Azure SQL DB #281

mnowrot opened this issue Oct 27, 2023 · 2 comments
Labels
status: ideal-for-contribution An issue that a contributor can help us with type: enhancement A general enhancement

Comments

@mnowrot
Copy link

mnowrot commented Oct 27, 2023

Feature Request

Is your feature request related to a problem? Please describe

I'd like to use passwordless authentication to my AzureSQL database. So far I'm unable to do it. My question on StackOverflow remains unanswered so far.

Describe the solution you'd like

Indicate the name of the managed identity I want to use to connect in the driver settings. The driver, possibly with support of external libraries should attempt to authenticate with this managed identity. Both System- and User-assigned managed identities shall be supported.

Describe alternatives you've considered

So far, I fell back to using usernname/password authentication. An alternative would be to use the JDBC driver which supports this authentication style.

Teachability, Documentation, Adoption, Migration Strategy

I'd consider introducing a property to driver settings:
azureManagedIdentityClientId

Authentication should be performed if the given managed identity is assigned to the azure resource from which I'm attempting to authenticate (a Virtual Machine, Azure Container App, etc.)

@mnowrot mnowrot changed the title Suport Azure Managed Identities to authenticate to Azure SQL DB Support Azure Managed Identities to authenticate to Azure SQL DB Oct 27, 2023
@mp911de
Copy link
Member

mp911de commented Oct 27, 2023

Thanks a lot. We have quite some requests asking for additional authentication options. Our maintainer team is rather small without Microsoft being involved in the driver. We don't have the bandwidth nor infrastructure to test and develop additional auth mechanisms at the time being.
We happily accept contributions from the community though.

@mp911de mp911de added type: enhancement A general enhancement status: ideal-for-contribution An issue that a contributor can help us with labels Oct 27, 2023
@davidkarlsen
Copy link

Related: #101

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status: ideal-for-contribution An issue that a contributor can help us with type: enhancement A general enhancement
Projects
None yet
Development

No branches or pull requests

3 participants