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.
5,392 questions
Synapse Link and SQL 2022 Error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 74%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kramomat
6
Reputation points
I am trying to setup Azure Synapse Link between my local SQL Server 2022 Instance and Azure Synapse.
Setup went fine so far.
But when trying to start the sync I get the message "There is no available source table that has been enabled successfully for Synapse Link"
I configured two tables and sucessfully published the configuration. Is there something additional to be done?
Azure Synapse Analytics
{count} votes
-
Evgeny Grishchenko 486 Reputation points2022-11-26T11:53:34.56+00:00 Have you checked that the credentials, which you provided for the synapse link are correct?
-
PRADEEPCHEEKATLA 90,811 Reputation points Moderator2022-11-29T07:52:10.287+00:00 Hello @Kramomat ,
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.
-
Kramomat 6 Reputation points
2022-12-05T12:52:08.833+00:00 Yes, I checked the credentials. There is a test connection button, that works fine
-
Kramomat 6 Reputation points
2022-12-05T12:54:30.127+00:00 Unfortunately the issue still persists
I am using an sql user (not an Azure AD account) to connect with my SQL Server.Since connection test went fine, Integration Runtime SQL Server itself and the credentials cannot be the cause of this problem.
My Server is not joined to any domain to make the scenario as simple as possible. -
PRADEEPCHEEKATLA 90,811 Reputation points Moderator
2022-12-07T05:54:55.063+00:00 Hello @Kramomat ,
Could you please try to create a new setup Azure Synapse Link between my local SQL Server 2022 Instance and Azure Synapse and see if you are facing similar issue?
In case, if you are still experiencing the same issue - I would suggest you to share the synapse workspace region?
-
PRADEEPCHEEKATLA 90,811 Reputation points Moderator
2022-12-12T06:40:47.757+00:00 Hello @Kramomat ,
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.
Sign in to comment
Sign in to answer