Can't connect to Azure gov from Visual Studio

Aashishkebab 5 Reputation points
2023-03-30T19:43:44.99+00:00

When I click the Connect option from inside the portal, it goes to this screen:

User's image

When I click Open Visual Studio, it defaults to SQL Authentication, but it has an error when I try to connect. This is obvious, because I set up Azure-only authentication.

However, NONE of these options work. Yes my firewall is configured to accept the device:

User's image

The interactive authentication says I've entered my password incorrectly too many times. Password authentication says it can't find the user. Integrated authentication says it isn't suppported.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,631 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ed Harris 25 Reputation points
    2023-03-30T21:43:57.3866667+00:00

    Hello. I didn’t see a question directly asked, but I think I get you. The answer is obvious; Azure requires Azure AD authentication, cf. https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16

    Make sure your version of SSMS is the latest and that you have Azure development configured as an installation option and you should see the Azure authentication options available. If you’re government, you’ll almost certainly be using MFA.

    Please see below an example of what your dropdown should appear like when you have the proper components installed.

    User's image