Creating Synapse Workspace

Question

Creating Synapse Workspace

Chris Bellerby 0

Hi

New to Synapse and we are trying to create a workspace, that works however we are receiving an error when loading

Failed to load one or more resources due to forbidden issue, error code 403.

Pipeline
Dataset
Linked service
Trigger
Data flow
SQL script
Spark job definition
Synapse KQL scripts
Credential
Lake databases
Apache Spark configuration
Managed Private Connections

following many guides, but nothing seems to be helping,

https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-powershell

However failing on the following.

    2023-10-03 14:58:39Z  0.187s  HTTP 404  129 chars  CORS(*)  Passed
  GET https://management.azure.com/subscriptions/8b3b8a60-1dd0-4824-8770-2ed6a55d8e27/resourceGroups/test-synapse-connectivity-dummy/providers/Microsoft.Synapse/workspaces/dummy/sqlPools?api-
version=2019-06-01-preview&__session_id=df2ccdcc-1079-41ea-acea-d9c60cdb59af
    2023-10-03 14:58:40Z  0.037s  HTTP 401  88 chars  CORS(*)  Passed
RBAC
  GET https://biu-synw-dw-dev-uksouth.dev.azuresynapse.net/checkAccessSynapseRbac?api-version=2020-08-01-preview&__session_id=df2ccdcc-1079-41ea-acea-d9c60cdb59af
    2023-10-03 14:58:40Z  0.377s  HTTP 403  319 chars  CORS  Failed  Unexpected status code: 403. Expecting: 401.
    --> System.Management.Automation.RuntimeException: Unexpected status code: 403. Expecting: 401.
Spark Pool
  POST https://biu-synw-dw-dev-uksouth.dev.azuresynapse.net/livyApi/versions/2019-11-01-preview/sparkPools/test-synapse-connectivity-dummy/sessions
    2023-10-03 14:58:40Z  0.109s  HTTP 403  319 chars  CORS  Failed  Unexpected status code: 403. Expecting: 401.
    --> System.Management.Automation.RuntimeException: Unexpected status code: 403. Expecting: 401.
  GET https://biu-synw-dw-dev-uksouth.dev.azuresynapse.net/livyApi/versions/2019-11-01-preview/sparkPools/test-synapse-connectivity-dummy/sessions/1
    2023-10-03 14:58:40Z  0.077s  HTTP 403  319 chars  CORS  Failed  Unexpected status code: 403. Expecting: 401.
    --> System.Management.Automation.RuntimeException: Unexpected status code: 403. Expecting: 401.
SQL Pool (443)

Anonymous

2023-10-04T10:23:11.45+00:00
@Chris Bellerby

Thanks for approaching Microsoft Q& A

it seems that you are experiencing a "Failed to load one or more resources due to forbidden issue, error code 403" error when trying to access certain resources in your Azure Synapse workspace. This error can occur due to various reasons, such as RBAC permission issues, network configuration issues, or incorrect authentication credentials. To troubleshoot this issue, you can try the following steps:

Ensure that you have the necessary permissions to access the resources you are trying to access. You can check your permissions by going to the Access control (IAM) tab in the Azure portal and reviewing your role assignments.

Ensure that your network configuration is set up correctly to allow access to the Azure Synapse workspace. You can refer to the Troubleshoot Synapse Studio connectivity with PowerShell guide.

Ensure that you are using the correct authentication credentials to access the Azure Synapse workspace. You can try re-entering your credentials or resetting your password if necessary.

If you have enabled public network access for your Azure Synapse workspace, you can try disabling it to see if it resolves the issue

If none of the above steps resolve the issue, please do let us know.
Anonymous

2023-10-05T10:31:48.9633333+00:00

@Chris Bellerby

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Anonymous

2023-10-06T06:41:11.69+00:00

@Chris Bellerby

just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Anonymous

2023-10-04T10:23:11.45+00:00

@Chris Bellerby

Thanks for approaching Microsoft Q& A

it seems that you are experiencing a "Failed to load one or more resources due to forbidden issue, error code 403" error when trying to access certain resources in your Azure Synapse workspace. This error can occur due to various reasons, such as RBAC permission issues, network configuration issues, or incorrect authentication credentials. To troubleshoot this issue, you can try the following steps:

Ensure that you have the necessary permissions to access the resources you are trying to access. You can check your permissions by going to the Access control (IAM) tab in the Azure portal and reviewing your role assignments.

Ensure that your network configuration is set up correctly to allow access to the Azure Synapse workspace. You can refer to the Troubleshoot Synapse Studio connectivity with PowerShell guide.

Ensure that you are using the correct authentication credentials to access the Azure Synapse workspace. You can try re-entering your credentials or resetting your password if necessary.

If you have enabled public network access for your Azure Synapse workspace, you can try disabling it to see if it resolves the issue

If none of the above steps resolve the issue, please do let us know.
Anonymous

2023-10-05T10:31:48.9633333+00:00

@Chris Bellerby

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Anonymous

2023-10-06T06:41:11.69+00:00

@Chris Bellerby

just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Anonymous

@Chris Bellerby

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

And also Watch this video to learn how to disable public network access.

Hope this helps. Do let us know if you any further queries.

Please don’t forget to Accept Answer wherever the information provided helps you, this can be beneficial to other community members.

0 comments

Share via

Creating Synapse Workspace

1 answer

Your answer