Connect to Azure Sql Database in Visual Studio Code using Active Directory Authentication

Question

I am looking to connect to azure sql server in Visual studio code using one of the Active Directory connection modes. However seems only sql authentication is supported as of now in visual studio code. Any help here is appreciated.

Tried checking in visual studio code documentation but didn't find any mention of active directory authentication

Answer 1

Please consider using Azure Data Studio, which is derived from VS Code for use with SQL Azure and other Azure Data services. It supports Azure Active Directory authentication (which is a bit different than traditional integrated authentication against a local AD. Given that SQL Azure isn't domain joined to your local domain, you would not be able to use it to authenticate anyways.

Here's the release notes where they mention AAD auth supportRelease Notes.