Skip to content

feat: add more authentication options#45

Merged
dhensby merged 1 commit intotediousjs:masterfrom
stokedout:patch-1
Sep 11, 2024
Merged

feat: add more authentication options#45
dhensby merged 1 commit intotediousjs:masterfrom
stokedout:patch-1

Conversation

@stokedout
Copy link
Copy Markdown
Contributor

Hey, would like to use this in a project but I need more authentication options:

SQL Server now has 8 options for Authentication as per https://learn.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=sql-server-ver15#setting-microsoft-entra-authentication

@dhensby
Copy link
Copy Markdown
Collaborator

dhensby commented Sep 11, 2024

Nice - are there any other extra props required for any of these additional options?

@stokedout
Copy link
Copy Markdown
Contributor Author

Thx for quick response. I'm not 100% sure but based on the examples in the link above and the connection string I have from a client of ours it seems your library has the properties needed already. For example we're using the following below where client id and secret reuse the user id and password fields:

Server=tcp:{server}; Authentication=Active Directory Service Principal; Encrypt=True; Database={db}; User Id={client_id}; Password={client_secret}

@dhensby dhensby merged commit df07ac8 into tediousjs:master Sep 11, 2024
@dhensby
Copy link
Copy Markdown
Collaborator

dhensby commented Sep 11, 2024

This is released in v0.6.0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants