CODEWITHSUNDEEP
azureazure-synapse
Shankar
Shankar

Reputation: 601

Azure Synapse Studio ServerLess SQL Pool Access Error

I am not able to access any of my Server Less SQL Pool in Azure Synapse. I can create new Spark Pool but not SQL Pool.

Error is  : 
**You don't have access to the serverless SQL pool, Built-in. To be granted access, contact a Synapse Administrator for this workspace.**

When I look back my access privileges, I am the owner of the Azure Synapse Workspace and I do have contributor access too. Simultaneously, I am the "SQL Active Directory admin

Additionally I do have "Storage Blob Data Contributor" to access the storage account.

how do ensure thatI have access to BuiltIn ServerLess SQL Pool ?

Additionally, when I open Synapse Studio I can see following pop error. Any advise, please?

enter image description here

Upvotes: 1

Views: 9054

Answers (1)

Joel Cochran
Joel Cochran

Reputation: 7728

The Synapse Team is constantly updating the Synapse RBAC/privileges feature. The IAM in Azure is for the resource itself. You'll need to check the Workspace RBAC inside the Synapse Studio:

enter image description here

At present, you'll need either Synapse Administrator or Synapse SQL Administrator role to access the Serverless SQL pool.

Upvotes: 5

Related Questions