bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases
MIT License
31 stars 18 forks source link

Additional Authentication Methods for Azure SQL #73

Open rgonzalez466 opened 1 year ago

rgonzalez466 commented 1 year ago

The current module only seems to support password authentication with Azure SQL . Are there any plans to support other authentication methods ? AD Password ?

deaquino commented 9 months ago

Maybe, just adding additional parameters to the connection string could work, right? Authentication="Active Directory Default | Active Directory Password ..."

deaquino commented 9 months ago

I've tried every option trying to configure Azure Active Directory Password. I could't. it requires the clientId in some cases...

I had to use the component odbc in order to connect to my database. but without the bulk benefits and do it by hand.

deaquino commented 5 months ago

Do we have an update on this topic?