question

ChakravarthiLolla-7384 avatar image
0 Votes"
ChakravarthiLolla-7384 asked ·

Intermittent Synapse SQL Pool connectivity issue with Private endpoints

Hi,

I am getting the below error when my data factory pipelines in the synpse Ayanlytics tries to access the SQL pool in the same Synapse workspace.

{ "errorCode": "2200", "message": "Failure happened on 'Sink' side. ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database: 'tcp:xyz.sql.azuresynapse.net,1433', Database: 'xyz', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Cannot open server 'xyz' requested by the login. Client with IP address 'xyz' is not allowed to access the server


I am using a self hosted IR and the subnet of the IR VM have the private endpoints setup for the synapse SQL pool.

This issue doesn't occur all the time but is intermittent.

azure-synapse-analyticsazure-private-link
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered ·

Hello @ChakravarthiLolla-7384 ,
Thanks for the ask and using the Microsoft Q&A platform .

You mentioned

This issue doesn't occur all the time but is intermittent.

This kind of issues needs a deeper look into the logs to check what happned in point in time . I think you can work with Microsoft support to resolution .

I think I suggest you to please add a retry and see if that helps .

104931-image.png


Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members



image.png (49.1 KiB)
· 1
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @HimanshuSinha-MSFT,
,
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 back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·
ChakravarthiLolla-7384 avatar image
0 Votes"
ChakravarthiLolla-7384 answered ·

Hi,

The issue doesnt seem to be specific to synapase as we are facing the issue not only in the pipelines but when conecting to the Synpase SQL or other Azure SQL from SSMS as well. It appears the issue is with the private endpoints

10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.