search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.44k stars 291 forks source link

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

Open kimisikainai opened 1 year ago

kimisikainai commented 1 year ago

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": "xxx@xxx.com", "password": "xxxxxx" } } }, "previewLimit": 50, "server": "xxxxxxxxxxxx", "port": 1433, "driver": "MSSQL", "name": "DEV", "database": "dbname", "username": "xxx@xxx.com", "password": "xxxxxx" }

  2. Click to connect

Desktop (please complete the following information):