Synapse Studio Access - Unknown Admin

WZIAFP 157 Reputation points
2022-01-07T16:27:11.557+00:00

I have inherited an Azure Synapse Workspace.
Unfortunately the admin of the workspace is no longer with the company and no-one has access to workspace.
Is there a workaround for the scenario?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,662 questions
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 38,326 Reputation points Microsoft Employee
    2022-02-01T16:07:21.567+00:00

    Hi @WZIAFP ,

    This issue resolved via support case.

    It was a permission issue, and you were able to get the issue resolved by adding your AAD account into the synapse administrator Role.

    Please consider hitting Accept Answer. Accepted answers helps community as well.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Nandan Hegde 31,111 Reputation points MVP
    2022-01-07T17:02:48.65+00:00

    Based on my understanding, the owner of the RG/subscription hosting the workspace can provide access .
    The below link might help :
    https://learn.microsoft.com/en-us/azure/synapse-analytics/get-started-add-admin

    0 comments No comments

  2. PRADEEPCHEEKATLA-MSFT 85,031 Reputation points Microsoft Employee
    2022-01-10T06:08:44.05+00:00

    Hello @WZIAFP ,

    Thanks for the question and using MS Q&A platform.

    You need to reach out to your "Owner" of the subscription to add you as the Synapse Administrator role for the workspace.

    Here is the complete walkthrough on how to add Synapse Administrator role for the workspace.

    163478-synapse-sa.gif

    For more details, refer to Add an administrator to your Synapse workspace.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments