Azure / Azure/sql-action

Error: Managed Identity: DefaultAzureCredential authentication failed

Open
#248 1 comment 1 reaction 0 assignees View on GitHub
Dominant language
TypeScript
Stars
142
Forks
73
PR merge metrics
No merged PRs in 30d

Description

Hello,

I'm encountering an issue when trying to use a Managed Identity with a Federated Credential in GitHub Actions to run azure/sql-action@v2.3. The Managed Identity has been configured with a Federated Credential for GitHub (environment).

I added my Managed Identity to the database as `db_owner`, with the following query:

```sql
DROP USER IF EXISTS [ManagedIdentity-Dev];
CREATE USER [ManagedIdentity-Dev] FROM EXTERNAL PROVIDER WITH DEFAULT_SCHEMA=[dbo];
ALTER ROLE db_owner ADD MEMBER [ManagedIdentity-Dev];
```

Here is my GitHub Actions workflow (.yml file):

```yaml
create-sql-users:
runs-on:
group: github-runner-Dev
environment: ${{ inputs.environment }}
steps:
- uses: actions/checkout@main
- uses: azure/login@v2
with:
client-id: ${{ vars.AZURE_CLIENT_ID }} # The Managed Identity with Federated Credential
tenant-id: ${{ vars.AZURE_TENANT_ID }}
subscription-id: ${{ vars.AZURE_SUBSCRIPTION_ID }}
- uses: azure/sql-action@v2.3
with:
connection-string: ${{ secrets.AZURE_SQL_CONNECTION_STRING }}
path: './.github/sql/users.sql'
skip-firewall-check: true
```

**Issue**:

When the workflow runs, I receive the following error message:

```
sqlcmd -S mydatabase-dev.database.windows.net,1433 -d mydatabase-dev --authentication-method=ActiveDirectoryDefault -i ./.github/sql/users.sql
DefaultAzureCredential authentication failed
GET http://localhost:42356/msi/token
--------------------------------------------------------------------------------
RESPONSE 400 Bad Request
--------------------------------------------------------------------------------
{
"statusCode": 400,
"message": "No User Assigned or Delegated Managed Identity found for specified ClientId/ResourceId/PrincipalId.",
"correlationId": "86d82795-065e-4a71-a11c-12a10e7879d0"
}

```

Am I missing something?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.