Reputation: 1361
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
Upvotes: 6
Views: 26134
Reputation: 355
We also experienced the same error message but it was caused by improper configuration of private endpoints. If you are using private endpoints, you need four of them: one for the Azure Synapse Private Link Hub and three for the workspace sub-resources (SQL, SqlOnDemand, and Dev).
Once we corrected the issue this error went away for us and Studio behaves normally now.
So as the other answers point out, this can be caused by missing RBAC roles or by networking issues.
Upvotes: 1
Reputation: 2780
I had this issue and I was able to solve it by doing the following:
Open Synapse Studio from Overview screen in Synapse
Click Manage from the left navigation blade
Click on Access Control in Security
Click Add and then Select the Role "Synapse Administrator"
Select the User permission should be given to
Select Apply
After that, log out and log back to Azure and the error should disappear.
In case you still see the error then you need to access to the Synapse workspace and under the Security tab you need to click on it and add the range of IP addresses that will have access to the instance.
Upvotes: 12
Reputation: 1
As per abautista this was the fix for me: Synapse Studio >> Manage >> Access Control in Security >> Add yourself as the Role "Synapse Administrator"
Upvotes: 0
Reputation: 11
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.
Upvotes: 1
Reputation: 12788
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?
Make sure you have required permissions to access workspace:
Option1: Try to manually login by going to the https://web.azuresynapse.net
and sign into your workspace.
For more information, refer to the Open Synapse Studio
Option2: You please try the below:
Upvotes: 4
Reputation: 6366
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
Upvotes: 3