I am having issues connecting to a AzureSQL Database/Server using VSCode.
I tried a couple of extensions but non of them seem to support the Active Directory Service Principal authentication.
Has anyone had any success?
I tried using the Azure Tools, which does not support Azure SQL. I tried using the SQL Server (mssql) extension, but as far as I see it does not support that type of authentication, same with SQL Tools by "Matheus Teixeira".
Agreed with @Thom A As far as concern with Connecting Azure SQL Database with VSCode there are only Two methods are supported.
Microsoft Entra Integrated and Microsoft Entra Service Principal are not same in integrated authentication we need Microsoft Entra Id user to authenticate.
Microsoft Entra Service Principal (Active Directory Service Principal authentication) is not supported in mssql extension of VSCode
You can connect it with the programming language in VScode using C# as mentioned here