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.
Unable to access synapse workspace from adf linked service
![](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(268.8, 17%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Guruprasad Kulkarni
60
Reputation points
Hi Team,
I am unable to create link service from adf to synapse serverless pool due to below error. I have already provided contributor access to adf in synpase. I am using option 'System managed access identity'
option as authentication type. Please advice.
Note :- I have tried to access the same workspace using SQL authentication option and able to do it. Also, I have enabled 'Allow azure service to access synapse workspace' option in Networking option.
Azure Synapse Analytics
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2024-01-04T09:02:37.8+00:00 Thanks for the question and using MS Q&A platform.
Based on the error message you provided, it seems like there could be an issue with the firewall settings on your SQL database preventing the Azure Data Factory integration runtime from accessing it.
Here are some troubleshooting steps you can take to diagnose and resolve the issue:
- Check the firewall settings on your SQL database: Make sure that the IP address of the Azure Data Factory integration runtime is added to the firewall rules on your SQL database. You can find the IP address of the integration runtimehere: Azure Integration Runtime IP addresses: Specific regions.
- Check the linked service configuration: Double-check that the linked service configuration for your SQL database is correct. Make sure that the connection string, username, and password are all correct and match what is configured on your SQL database.
- SMI Permissions: Even though you’ve provided contributor access, there might be specific permissions that the SMI requires. Please verify this.
- Check the authentication method: Ensure that the authentication method specified in the linked service is correct. If you're using a managed identity, make sure that it has the appropriate permissions to access.
- Check the integration runtime: Ensure that the integration runtime is running and is able to connect to the internet.
If none of the above steps resolve the issue, try recreating the linked service from scratch and testing the connection again.
Hope this helps. Do let us know if you any further queries.
-
Anonymous
2024-01-05T10:11:43.37+00:00 @Guruprasad Kulkarni 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.
-
Guruprasad Kulkarni 60 Reputation points
2024-01-06T06:53:23.5366667+00:00 I am still facing the issue.
-
Guruprasad Kulkarni 60 Reputation points
2024-01-06T06:55:26.7333333+00:00 Please let me know what other details you required. I can DM you if required details requried sensitive info.
-
Anonymous
2024-01-08T08:44:11.8433333+00:00 please check these steps and confirm us
- Reassign Roles: Remove and reassign the roles for the System Managed Identity in both ADF and Synapse.
- Reconfigure Identity: Try removing and reconfiguring the System Managed Identity in both ADF and Synapse.
- Check Network Security Groups (NSGs): NSGs might be blocking the connection. Check if there are any NSGs associated with your subnet that could be blocking the connection.
-
Anonymous
2024-01-09T04:25:55.3566667+00:00 @Guruprasad Kulkarni 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.
-
Guruprasad Kulkarni 60 Reputation points
2024-01-13T17:12:37.7333333+00:00 I am still getting same error
-
Anonymous
2024-01-17T14:19:07.7433333+00:00 checking with the internal team will get back to you shortly.
-
Anonymous
2024-01-22T07:20:42.1066667+00:00 @Guruprasad Kulkarni
could you please try using SQL authentication option to access the same workspace. Additionally, you can enable ‘Allow azure service to access synapse workspace’ option in Networking option. and confirm us.and moving could you provide screenshots of linked services if possible.
-
Guruprasad Kulkarni 60 Reputation points
2024-01-22T07:40:34.1866667+00:00 I can access synapse using SQL authentication and also I have enabled ‘Allow azure service to access synapse workspace’ option. I can privately messaged you the snpashot of linked service option but not comfortable in pasting here. Please let me know what are the ways to do it.
-
Anonymous
2024-01-24T08:34:37.3866667+00:00 @Guruprasad Kulkarni
could you please send an email toAzCommunity@microsoft.comwith the details. if possible -
Anonymous
2024-01-25T13:53:42.3933333+00:00 @Guruprasad Kulkarni was just checking back to see if you have sent mail with details
Sign in to comment
Sign in to answer