search

Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
https://budibase.com
Other
21.73k stars 1.49k forks source link

MSSQL Server - Support Trusted Authentication #3601

Open mjashanks opened 2 years ago

mjashanks commented 2 years ago

Currently, we do not have the option to authenticate to MSSQL via trusted authentication (i.e. Active Directory).

This is supported by tedious, the underlying ms-sql library.

I believe the config option should be authentication.type = ntlm, and we'd also need to add authentication.options.domain.

I'm sure someone in the community could help us test this, so we don't have to go setting up Active Directory: https://github.com/Budibase/budibase/discussions/3584!

https://tediousjs.github.io/tedious/api-connection.html

stale[bot] commented 2 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.