Azure / Azure/azure-cli

Setting SQL AD Admin for Azure Synapse fails.

Open
#20,683 13 comments 0 reactions 0 assignees View on GitHub
act-codegen-extensibility-squad customer-reported question Service Attention Synapse
Dominant language
Python
Stars
4.6k
Forks
3.5k
Avg merge
3d 2h
Merged PRs (30d)
60

Description

I've noticed that on some Synapse workspaces (not all of them), when trying to set up SQL AD admin, it fails with the following error:
"Failure occurred while performing CreateOrUpdateAadAdmin operation in one of the subsystems of the workspace.".

This happens no matter how you push the change: via portal, via PS or via CLI. More than that, it seems that CLI also gives a false response sometimes. Although the command offers a response that it passed through, the change isn't actually implemented.

I'm guessing that this probably happens on older Synapse Workspaces which were created before the SQL AD admin feature was implemented.

Can anybody confirm/infirm this and resolve the bug?

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.