skip to Main Content

Error 1: Failed to load one or more resources due to no access, error code 403.
I checked with the answers here but they don’t work for me. As the screenshots below suggest, I am the service administrator, owner and contributor of the Synapse workspace. I also allow public access to the Synapse workspace.

my role assignment

allow public access

Error 2: If I check the access control on Synapse studio portal, it says I am not the synapse administrator but I am actually the service administrator of the entire subscription.
Contact a Synapse Administrator

Error 3: Cannot create an SQL pool. Cannot create an SQL pool

2

Answers


  1. The Azure IAM/RBAC roles are for working with the Azure resource, but the Synapse workspace also has its own access control. You will need to grant permissions/RBAC inside the workspace itself. [documentation]

    I recommend using Groups to manage permissions, but you can start by adding yourself as a Synapse Administrator.

    Login or Signup to reply.
  2. For Error1: You may try the following steps and let us know.

    enter image description here

    This article – Disabling Public Network Access in Synapse helps to resolve the issue.

    For Error2:Make sure you have Synapse Administrator role in the Manage => Security => Access Control

    enter image description here

    For more details, refer to Grant access to SQL pools.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search