database – Azure Elastic Job Use Credentials instead of Identity

We have an elastic jobs agent that has been running for some time now but recently started seeing every job failing consistenly.

We have used credentials in the past but it appears someone added an identity to to the agent and now every job returns wih the error:
Failed to determine members of SqlServerTarget (server name ‘server-name’, server location ‘server-location’): Login failed for user ‘token-identified principal’.

I beleieve this means the agent is attempting to use the UMI (User Managed Identities) to login to the DB instead of the credentials

I have deleted the identity but the error persists.

Please help how to I get the agent to use credentials again or turn of UMI.

THANKS!

Read more here: Source link