Synapse built-in Serverless pool - Unauthorized

Thabet, Hamdi 20 Reputation points
2023-04-12T20:16:03.7433333+00:00

When trying to access for first time to Synapse workspace, the built-in sql serveless pool has the status "Unauthorized". The error message is: You don't have access to the serverless SQL pool, Built-in. To be granted access, contact a Synapse Administrator for this workspace. I already follow microsoft recommandations:

  • I have both roles: Synapse Administrator or Synapse SQL Administrator
  • Grant access to my ip address in security --> Networking
  • Clear browser cookies and cache
  • Navigation in private mode

But still have the error. Could you assist please. error serveless

Azure SQL Database
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,462 questions
{count} votes

1 answer

Sort by: Most helpful
  1. VasimTamboli 4,420 Reputation points
    2023-04-14T20:27:47.1233333+00:00

    It sounds like you have taken the appropriate steps to grant yourself access to the built-in SQL Serverless pool in your Synapse workspace, but are still encountering an "Unauthorized" status.

    One additional step you may want to try is to check if the Azure Synapse Analytics service is in the same subscription as your Azure AD tenant. If they are not in the same subscription, you may need to grant your Azure AD tenant access to the subscription containing the Synapse workspace.

    To do this, navigate to the subscription that contains your Synapse workspace and select "Access control (IAM)" from the left-hand menu. From there, you can add a new role assignment and select "Azure AD user, group, or service principal" as the assignee. Then, enter the email address associated with your Azure AD tenant and select the appropriate role (e.g. "Contributor" or "Owner").

    If you have already tried this step or it does not resolve the issue, you may need to contact a Synapse Administrator for your workspace to troubleshoot the issue further. They may be able to identify any underlying issues or misconfigurations that are preventing you from accessing the SQL Serverless pool.

    3 people found this answer helpful.