Skip to content

[Bug]: Cannot Connect to Azure SQL Managed Instance in Azure USGovernment #19473

Open
@emixon

Description

@emixon

Description

With Azure Data studio set to expire. I have been trying repeatedly to transition to VSCode.

I work in an Azure Government (US) subscription and I have set Microsoft-sovereign-cloud: Environment to "USGovernment"

To add an account I use the "MS SQL: Add Microsoft Entra Account" command. However, this command will only attempt authentication with the commercial azure environment (https://login.microsoftonline.com/). It does not seem to respect the local cloud environment settings.

I've been able to login to my gov cloud account through the "Azure: Sign In" command. But when I try to configure a connection to our Azure SQL Managed Instance it tells me "User account '{myAccount@domain.onmicrosoft.us}' not found in MSAL cache, please add linked account or refresh account credentials."

Attempting to click "Sign In" again takes me to the commercial login and not the USGovernment login.

Steps to Reproduce

Attempt to connect to Azure SQL Managed Instance within USGovernment Azure cloud.

Login will not allow you to sign-in to USGovernment regardless of Microsoft-sovereign-cloud: Environment settings.

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

  • VS Code Version: 1.100.2
  • MSSQL Extension Version: 1.32.0
  • OS: MacOS Sequoia 15.1.1
  • SQL Server Version: Azure SQL Managed Instance (AzureUSGovernment)
  • Connection Type: Microsoft Entra ID - Universal with MFA Support

Confirmation

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions