What is the correct connection string for Azure SQL database using a Service Principal?

Hi all,

Apologies if this has been answered already, but I'm struggling to find a solution.
I'm trying to build a connection string that connects to Azure SQL Database using a Service principal.

I've checked here:
https://www.connectionstrings.com/azure-sql-database/

And from other sources I've also tried:
Server=demo.database.windows.net; Authentication=Active Directory Service Principal; Database=testdb; User Id=App Id; Password=secret

Thanks so much in advance!

1 answer