'Access issue with Azure Synapse studio

I created a Synapse workspace in my Azure Portal and tried opening the Synapse studio and I received the following error:

Failed to load one or more resources due to No access, error code 403.

credential    
linkedService      
dataset   
pipeline   
trigger  
sqlscript
notebook
sparkjobdefinition 
dataflow

What could be the reason. I believe I have required access to resource groups

azureazure-synapse


Solution 1:[1]

This could be an intermittent issue while opening synapse workspace.

Could you please confirm the permission on the Synapse workspace which you are trying to login?

enter image description here

Make sure you have required permissions to access workspace:

  • From Azure Portal under Synapse Workspace, user needs to have Owner/Contributor permission
  • From Azure Portal under Synapse Workspace, user needs to enable correct IP address under firewall settings

Option1: Try to manually login by going to the https://web.azuresynapse.net and sign into your workspace.

enter image description here

For more information, refer to the Open Synapse Studio

Option2: You please try the below:

  1. Clear “Cookies and Cached data” of your browser.
  2. Private Mode (New InPrivate Window).
  3. Try in different browser.

Solution 2:[2]

Go to your storage account -> Access Control (IAM) -> Role Assigments and check if you can find ther role storage-blob-data-contributor if not add it.

This role shoulde be added automaticly but there are exceptions fron this rule

Detials are here how-to-grant-workspace-managed-identity-permissions

Solution 3:[3]

I had this issue and I was able to solve it by doing the following:

  1. Open Synapse Studio from Overview screen in Synapse

  2. Click Manage from the left navigation blade

  3. Click on Access Control in Security

  4. Click Add and then Select the Role "Synapse Administrator"

  5. Select the User permission should be given to

  6. Select Apply

After that, restart Azure and the error should disappear.

Solution 4:[4]

I managed to fix the same issue by following these steps: Open "Azure Synapse Studio" with your admin account from the Workspace, Open Manage\Access Control\ and add the user you need with Role Synapse Administrator or more adequate privilege. Sign Out "Azure Synapse Studio" Sign In with the other user that you just gave privilege to.

Solution 5:[5]

As per abautista this was the fix for me: Synapse Studio >> Manage >> Access Control in Security >> Add yourself as the Role "Synapse Administrator"

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 CHEEKATLAPRADEEP-MSFT
Solution 2 Arkadiusz ?ukasiewicz
Solution 3 Syscall
Solution 4 user14220735
Solution 5 Timothy Jaco

Related Questions