1

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.

Ilya Chernomordik
  • 27,817
  • 27
  • 121
  • 207
  • 1
    Most likely you can't. Authenticating a service principal is different from a user, and only the password authentication method could potentially work if the SSMS developers made it detect when a client id is used instead of a username. Based on your test, they probably haven't. – juunas Sep 02 '21 at 10:34

1 Answers1

1

As suggested by @junnas in the comment section we cannot connect to Azure SQL database with Service Principal in SSMS.

Please check this blog

JayakrishnaGunnam-MT
  • 1,548
  • 1
  • 5
  • 9