Description

My account is enabled in 2 tenants. Each tenant has its own subscription.

From mssql extension I'm unable to select the subscription from other tenants and no tenant dropdown is avaiable.

Steps to Reproduce

Azure Data Studio is showing as follow

AZ Cli is showing as follow:

az account list 
[
  {
    "cloudName": "AzureCloud",
    "homeTenantId": "cemasked-forx-secu-rity-reasonxxxx68",
    "id": "b9masked-forx-secu-rity-reasonxxxx52",
    "isDefault": true,
    "managedByTenants": [],
    "name": "Personal Subscription - Visual Studio Enterprise - MPN",
    "state": "Enabled",
    "user": {
      "name": "[email protected]",
      "type": "user"
    }
  },
  {
    "cloudName": "AzureCloud",
    "homeTenantId": "9bmasked-forx-secu-rity-reasonxxxx85",
    "id": "38masked-forx-secu-rity-reasonxxxx61",
    "isDefault": false,
    "managedByTenants": [],
    "name": "FARM ON CLOUD MASKED",
    "state": "Enabled",
    "tenantId": "9bmasked-forx-secu-rity-reasonxxxx85",
    "user": {
      "name": "[email protected]",
      "type": "user"
    }
  }
]

Affected Area

• Connection dialog
• Query editor
• IntelliSense/auto-completion
• Query results panel
• Object Explorer
• Table Designer
• Schema Compare
• Schema Designer
• Query Plan Visualizer
• Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

• VSCode Version: 1.100.2 (latest)
• ms-mssql.mssql Version: 1.32.0 (Latest)
• OS Version: Windows 11 24H2

Confirmation

• I have searched existing issues and couldn't find a match
• I want to work on this issue