How to resolve the error on Lab 15, DP-203 (Use Azure Synapse Link for SQL)

Question

The Lab URL is : https://microsoftlearning.github.io/dp-203-azure-data-engineer/Instructions/Labs/15-Synapse-link-sql.html

If the Lab is followed as is, on the step: "Configure Azure Synapse Link/Create a Link Connection", the following error message occurs:

It seems as if the configuration script provisions a DB with insufficient capacity.

Kindly assist.

Answer 1

Hello Olugbemiga Adefuye,

Welcome to the Microsoft Q&A forum.

Per the below document, there are some Limitations and known issues with Azure Synapse Link for SQL

https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/synapse-link-for-sql-known-issues

<copied from the document>

• Azure Synapse Link for SQL isn't supported on Free, Basic, or Standard tier with fewer than 100 DTUs.
• Azure Synapse Link for SQL isn't supported on SQL Managed Instances.
• Service principal isn't supported for authenticating to source Azure SQL DB, so when creating Azure SQL DB linked Service, choose SQL authentication, user-assigned managed identity (UAMI) or service assigned managed Identity (SAMI).
• If the Azure SQL Database logical server has both a SAMI and UAMI configured, Azure Synapse Link uses SAMI.
• Azure Synapse Link can't be enabled on the secondary database after a GeoDR failover, if the secondary database has a different name from the primary database.
• If you enable Azure Synapse Link for SQL on your database as a Microsoft Entra user, Point-in-time restore (PITR) fails. PITR only works when you enable Azure Synapse Link for SQL on your database as a SQL user.
• If you create a database as a Microsoft Entra user and enable Azure Synapse Link for SQL, a SQL authentication user (for example, even sysadmin role) won't be able to disable/make changes to Azure Synapse Link for SQL artifacts. However, another Microsoft Entra user is able to enable/disable Azure Synapse Link for SQL on the same database. Similarly, if you create a database as an SQL authentication user, enabling/disabling Azure Synapse Link for SQL as a Microsoft Entra user doesn't work.
• Cross-tenant data replication is not supported where an Azure SQL Database and the Azure Synapse workspace are in separate tenants.

To resolve the error, please upgrade the database to a higher tier: You can upgrade the database to a higher tier that supports change feed. This will provide the necessary capacity to support the link connection.

or if upgrading the database is not feasible, you can try using a different database that has the required capacity to support change feed.

I hope this helps! Let me know if you have

If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.