patriksimek/node-mssql

Hello Guys,
I am trying to use mssql package - as it offers connection pooling to connect to Azure SQL DB
using the authentication type: "azure-active-directory-password", Following is the code snippet.
`
// Import the mssql package
var sql = require("mssql");
// Create a configuration object for our Azure SQL connection parameters
const config = {
driver: "tedious",
server: "xxxxxxxxxSQL.database.windows.net",
authentication: {
type: "azure-active-directory-password",
options: {
userName: "AzureAdUser", // Use your username
password: "AzureADpwd", // Use your password
domain: "dummy.domain",
}
},
options: {
database: "sqlDB",
encrypt: true,
},
};

function getData() {

var conn = new sql.ConnectionPool(dbConfig);
conn.connect()
// Successfull connection
.then(function () {

// Create request instance, passing in connection instance
var req = new sql.Request(conn);

// Call mssql's query method passing in params
req.query("Select * from dbo.table1")
.then(function (recordset) {
console.log(recordset);
conn.close();
})
// Handle sql statement execution errors
.catch(function (err) {
console.log(err);
conn.close();
})

})
// Handle connection errors
.catch(function (err) {
console.log(err);
conn.close();
});
}

getData();

`

When I execute this code - I get the following error.
But I am able to connect to this same Azure SQL db from Sql Server Mgmt Studio using same Credentials and authentication type from my machine.

PS C:\Projects\POC> node .\index1.js
ConnectionError: Security token could not be authenticated or authorized.
at C:\Projects\POC\node_modules\mssql\lib\tedious\connection-pool.js:71:17
at Connection.onConnect (C:\Projects\POC\node_modules\tedious\lib\connection.js:1043:9)
at Object.onceWrapper (node:events:510:26)
at Connection.emit (node:events:390:28)
at Connection.emit (C:\Projects\POC\node_modules\tedious\lib\connection.js:1071:18)
at C:\Projects\POC\node_modules\tedious\lib\connection.js:2961:22
at processTicksAndRejections (node:internal/process/task_queues:96:5) {
code: 'EFEDAUTH',
originalError: ConnectionError: Security token could not be authenticated or authorized.
at ConnectionError (C:\Projects\POC\node_modules\tedious\lib\errors.js:13:12)
at C:\Projects\POC\node_modules\tedious\lib\connection.js:2960:63
at processTicksAndRejections (node:internal/process/task_queues:96:5) {
code: 'EFEDAUTH'
}
}

Can someone provide any help with this matter, to help me understand what is that i'm missing in the above code?
Or if anyone was able to leverage mssql to use Authentication.type = "azure-active-directory-password" or "azure-active-directory-access-token"