Tedious does not support Active Directory Password Authentication

[tvrprasad]

Azure SQL DB supports two new modes of authentication:
Active Directory Password Authentication
Active Directory Integrated Authentication

I tried getting Tedious to work with Active Directory Password Authentication but couldn't make it work. Is there config to support this mode of authentication or is this a missing feature in Tedious?

@arthurschreiber @arobson - Thoughts please.

[navneetccna]

i am having same issue with Active Directory Password Authentication

[keatz55]

@navneetccna So are we

[tvrprasad]

Azure Active Directory Authentication is currently not supported by Tedious.

[summittracker]

@tvrprasad - Does Tedious still not support Azure Active Directory Authentication?

[arthurschreiber]

Thanks to the work done by @Hadis-Fard, starting with tedious@4.1.0, tedious now supports Azure Active Directory Authentication.

There's a new top-level authentication option that allows specifying with authentication method to use:

new Connection({
  'config': {
    'server': '<server>',
    'authentication': {
      'type': 'azure-active-directory-password',
      'options': {
        'userName': '<userName>',
        'password': '<password>'
      }
    },
    'options': {
      'encrypt': true
    }
  }
})

Currently, tedious@4.1.0 is available from the next release channel. You can install it using npm install tedious@next. It will soon be promoted to the latest channel and will be available via regular npm install tedious.

Please let us know if you run into any trouble using this connection option! 🙇