Cannot login with Entra ID guest account

[dnovvak]

Describe the bug

Entra ID auth does not work for guest accounts (user tenant is different than the server tenant).
Also the error says "password authentication failed" while using Entra Auth.

To Reproduce

Steps to reproduce the behavior:

1. Create PG server in another tenant than your account belongs to and configure Entra ID auth, make sure you have guest account there,
2. In VSCode, click on '+ Add Connection' from POSTGRESQL extension pane,
3. Fill the form with connection details,
4. Choose 'AUTHENTICATION TYPE' 'Entra Auth',
5. Click on 'Add Entra Id' and login with your account,
6. Click on 'Save & Connect',
7. See the error.

Expected behavior

The vscode-pgsql extension allows me to configure connection with Entra ID auth to the server in a different Tenant via guest account. In another words, there should be a way to choose tenant where the server is located.

Screenshots

VS Code version

Version: 1.100.2 (system setup)
Commit: 848b80aeb52026648a8ff9f7c45a9b0a80641e2e
Date: 2025-05-14T21:47:40.416Z
Electron: 34.5.1
ElectronBuildId: 11369351
Chromium: 132.0.6834.210
Node.js: 20.19.0
V8: 13.2.152.41-electron.0
OS: Windows_NT x64 10.0.26100

Extension Logs

N/A

[mmcfarland]

Thanks for reporting this issue @dnovvak, we're currently looking into supporting this feature. To help shape that, can you indicate what variant of user name you use when connecting to this guest-tenant DB with other tools (please don't share your actual user name :)

Is it similar to the format <home_tenant_alias>#EXT#@<guest_tenant_name> or do you use a custom, arbitrary user name?

[elmaxe]

We are also missing this feature. We are using this in Azure Data Studio, we cannot migrate to this extension if this feature is missing

We use a specific Azure AD group as the username when signing in

[mmcfarland]

Hi folks, we've published a pre-release version of the extension that allows for selecting your tenant, and providing a custom username (which could be a Security Group or guest account). Please see the instructions in this comment, and if you're able to test, I'd appreciate any feedback in this thread. Thanks again :)

[dnovvak]

Hi @mmcfarland,
the pre-release version works like a charm, thank you!

[elmaxe]

Works excellently! Thank you! @mmcfarland

[mmcfarland]

Thanks for your feedback and validation help. This feature was included in stable release 1.6.0.