I have configured my sql server with an Azure Active Directory admin that is a service principal (app registration). Is it possible to use clientid/secret to connect from Sql Management Studio?
I have tried Azure Active Directory - password authentication but client id and secret did not work.
It works just fine from my C# code with the same id and secret.
As suggested by @junnas in the comment section we cannot connect to Azure SQL database with Service Principal in SSMS.
Please check this blog