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:

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

Please ignore the above. The connection string actually works. Apologies everyone. I made a spelling mistake that took me hours to spot!