Azure Workload Identity Support for federated identity credentials

[yousamasham]

I am trying to use the MS SQL Scaler with Keda v1.12.1 to auto scale my pod but I am unable to use azure workload identity to connect to the Azure SQL database. This means that the connection string does not need to have a username or a password.

I am setting the podIdentity to use the azure workload which uses a federated identity credentials as described here: https://keda.sh/docs/2.12/authentication-providers/azure-ad-workload-identity/

However, everytime I try to connect I get the following message: error establishing mssql connection. Login error: Login failed for user ''. So it is expecting a username and/or password.

Is this supported in keda version 1.12.1? Do I need to upgrade keda version? Or is my use case not supported?