Get ERROR for azure-active-directory-password in mssql

[kimisikainai]

Describe the bug Get error when use authentication type azure-active-directory-password in mssql. ERROR: Error opening connection Security token could not be authenticated or authorized.

To Reproduce Steps to reproduce the behavior:

1. Configure the connection { "mssqlOptions": { "appName": "SQLTools", "useUTC": true, "encrypt": true, "authentication": { "type": "azure-active-directory-password", "options": { "userName": "[email protected]", "password": "xxxxxx" } } }, "previewLimit": 50, "server": "xxxxxxxxxxxx", "port": 1433, "driver": "MSSQL", "name": "DEV", "database": "dbname", "username": "[email protected]", "password": "xxxxxx" }

2. Click to connect

Desktop (please complete the following information):

• SQLTools Version [v0.27.1]
• VS Code Version: [1.79.2]
• OS: [Windows10]
• Driver:
  • [ ] PostgreSQL/Redshift
  • [ ] MySQL/MariaDB
  • [X] MSSQL/Azure
  • [ ] SQLite
  • [ ] Other? Which...
• Database version: [synapse sql dedicated pool
  Microsoft Azure SQL Data Warehouse - 10.0.20443.0 Mar 14 2023 23:02:36 Copyright (c) Microsoft Corporation ]