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,696 questions
Unable to connect IICS with Azure Synapse
![](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(41.6, 1%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
M, Murugeswari (Cognizant)
456
Reputation points
Hi,
We are getting below error while connecting IICS with one of our Dedicated Sql pool in the Azure
Managed Service Identity has not been enabled on this server
Can anyone pls suggest how to configure Managed Service identity
{count} votes
-
![](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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee2022-03-28T22:32:31.133+00:00 Hello @Anonymous ,
Thanks for the question and using MS Q&A platform.
Just to summarize your ask - you are receiving above error, while trying to connect to Dedicated SQL pools in Azure Synapse. Please correct if I misunderstood the question.Could you please confirm what is the authentication type used for establishing a connection to Synapse Dedicated pool?
Also please confirm if you have a staging enabled to a Azure Storage/Gen2?If you have enabled staging, then I would recommend reading this article and see if that helps to resolve your issue?
- This is a similar issue but while trying to connect from ADF - ADF to Synapse Pool: Please enable Managed Service Identity and try again
- Cannot Add Managed Identity to Synapse Pool
Ref doc: Are there any known issues with the COPY statement?
Do let us know how it goes.
Thank you
-
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee
2022-03-30T17:34:06.817+00:00 Hello @Anonymous ,
Just checking in to see if the above information was helpful. And, if you have any further query do let us know.
Sign in to comment