Wouter van E 21 Reputation points


I am trying to set up the Synapse Link for SQL when I get the following message when I publish the link connection:

Error code: OK
Inner error code: SynapseLinkStorageResourceNotProvisioned
Message: The Synapse Link storage resource is not provisioned for workspace {workspace name}

The connection to Azure SQL DB (source) is configured and the connection gives me a thumbs up.

The destination SQL Pool is created and is accessible.

I think I have checked and validated if all roles have been assigned and are attached to the right resources.

Any tips or ideas or solutions would be greatly appreciated.

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.
2,612 questions
No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 53,096 Reputation points Microsoft Employee

    Hello @Wouter van E ,

    Thanks for the question and using MS Q&A platform.

    This error message indicates that the subscription hasn't whitelisted, or the workspace was created before whitelist. If it's latter, you should delete and recreate the workspace.

    This is already documented in Known limitations and issues with Azure Synapse Link for SQL (Preview) - Azure Synapse Analytics | Microsoft Learn.

    "Users must use an Azure Synapse Analytics workspace created on or after May 24, 2022, to get access to Azure Synapse Link for SQL functionality."

    Hope this will help. Please let us know if any further queries.

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

0 additional answers

Sort by: Most helpful