t-sql.dk - T-SQL.dk – A blog on code, coffee & curiosities

Description: This blog is about SQL Server, Azure, Analytics, Data Integration, Data Warehousing, IoT and Business Intelligence.

business intelligence (1787) bi (1099) sql server (656) visual studio (238) sqlserver (62) sqlpass (5) ssdt (4) data tools (3) sqlsaturday (2) #sqlfamily (2)

Example domain paragraphs

The idea, as far as I have understood, is that whenever you invoke the Azure.Identity.DefaultAureCredential class, it provides a flow for attempting authentication using one of the following credentials, in listed order:

I suspect that since I have deployed my Azure Function using the Managed Identity setting to a Systems Assigned identity, like this:

AND the fact that ManagedIdentityCredential is before VisualStudioCredential in the authentication flow, it fails, since it is unable to authenticate the managed identity – which is the main principle of the design – none other than the service can assume the identity of the service.

Links to t-sql.dk (2)