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!
Please ignore the above. The connection string actually works. Apologies everyone. I made a spelling mistake that took me hours to spot!