Abhishek-Singh-Rana comments

Results 4 comments of


                                            Abhishek-Singh-Rana

Security token could not be authenticated or authorized error ( Node JS connectivity with MS SQL Server using Tedious)

Hello @MichaelSun90 , Thanks for your response. However, When I searched for 'tenantId' parameter it was mentioned that it's optional. `"authentication": { "type":'azure-active-directory-password', ..., "options": { "userName": value, "password": value,...

Security token could not be authenticated or authorized error ( Node JS connectivity with MS SQL Server using Tedious)

Hi @MichaelSun90 , I tried passing the 'tenantId' as following: ``` var Connection = require('tedious').Connection; const config = { authentication: { options: { userName: 'myusername', password: 'mypassword', tenantId: '3cbcd3-idsayXYZ0123456789-0d11484d', },...

Security token could not be authenticated or authorized error ( Node JS connectivity with MS SQL Server using Tedious)

Installing tedious 12.3.0 version resolved my issue.

Security token could not be authenticated or authorized error ( Node JS connectivity with MS SQL Server using Tedious)

@MichaelSun90 , I was using '14.3.0' before. Tedious >= 13.2.0 now needs a client and tenant id for connection authentication "azure-active-directory-password". With this version, issue is resolved irrespective of I...