The idea is:
Extend authentication options for the Microsoft SQL Node to include AD Authentication.
My use case:
My team has been using self-hosted n8n for various automation task this far and have recently extended use to other teams. One of these teams raised that the use of AD-based authentication to their Azure SQL DBs (using the existing Microsoft SQL Node) is not supported. This would ensure proper scope access without introducing back-door entries to the DBs.
I think it would be beneficial to add this because:
Enhance use of MS SQL Node by including further authentication options.
Any resources to support this?
There exists a community node that includes this capability: https://www.npmjs.com/package/n8n-nodes-advanced-sql.