Connect SharePoint Online List with Synapse Integrated Runtime Managed Virtual Network

CarmeloLoPresti-2973 61 Reputation points
2024-05-16T14:01:45.88+00:00

Getting an error when attempting to create a Linked Service for SharePoint Online List in Synapse.

I've followed the instructions and prerequisites on MS documentation, but getting the following error when testing the connection:

An error occurred while sending the request. Unable to connect to the remote server

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 52.104.x.x:443

We are using integrated runtime with managed virtual network. Other linked services to databases and storage accounts work fine. There's not much further helpful info on the error.

Could this be due to using Synapse Managed Virtual Network? The SharePoint list is within our tenant - we're not going outside of our tenant to access. T
Thanks.

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.
4,565 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,071 questions
{count} votes

Accepted answer
  1. phemanth 7,590 Reputation points Microsoft Vendor
    2024-05-17T12:01:46.6566667+00:00

    @CarmeloLoPresti-2973 Welcome to Microsoft Q&A platform and thanks for posting your question.

    I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer.

    Ask: Getting an error when attempting to create a Linked Service for SharePoint Online List in Synapse.

    I've followed the instructions and prerequisites on MS documentation, but getting the following error when testing the connection:

    An error occurred while sending the request. Unable to connect to the remote server

    A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 52.104.x.x:443

    We are using integrated runtime with managed virtual network. Other linked services to databases and storage accounts work fine. There's not much further helpful info on the error.

    Could this be due to using Synapse Managed Virtual Network? The SharePoint list is within our tenant - we're not going outside of our tenant to access. T

    Solution: I believe I've found the answer. I opened a ticket with MS after further research, and found some documentation that supports if Data Exfiltration is enabled, it does not allow ANY outbound access. Since SP Online is outbound, it is blocked. https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/synapse-connectivity-series-part-3-synapse-managed-vnet-and/ba-p/3706983

    I tested this by creating another Synapse workspace with managed vNet enabled, but Data Exfiltration Protection disabled. I was able to connect to my SP online list from this workspace. Also want to add that this second Synapse workspace is on the same exact vNet (private endpoints) as the first Synapse workspace, so I know the networks are exactly the same.

    If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

    If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

0 additional answers

Sort by: Most helpful