topic Re: Connect Fabric Pipeline to On Premise SQL Server in Pipelines

Connect Fabric Pipeline to On Premise SQL Server

RajanLSEG — Wed, 24 Apr 2024 07:28:00 GMT

Hi ,

I am trying to connect my Fabric Pipeline to OnPremise SQL Server. But i got the below error

I used the on Premises data way, here is the link i referred https: //datavibe.co.uk/getting-on-premises-sql-server-data-to-fabric-lakehouse/

Error details, when i test the connection in a copy data activity i got the below error.

Error code: InternalError

Details:

Internal error has occurred.

Activity ID :

32077a7b-d251-4745-aca5-2bbf981361b5

Please help for this connection issue.

Thanks

Rajan

Re: Connect Fabric Pipeline to On Premise SQL Server

Anonymous — Wed, 24 Apr 2024 09:53:00 GMT

Hi RajanLSEG

Thanks for using Fabric Community.

Can you please provide the screenshot for the error?

This might be an intermittent issue sometimes. So please try again and let me know.

Thanks

Re: Connect Fabric Pipeline to On Premise SQL Server

RajanLSEG — Wed, 24 Apr 2024 10:20:48 GMT

Now i am getting the below error

Error code : 11062
Details : Please check your network connectivity to ensure your on-premises data gateway can access ncu.frontend.clouddatahub.net and restart the service to retry the connection again once the connectivity issue has been resolved.
Activity ID : 02d33a38-3d6f-4f6b-b7a0-9bc6b28ad

Re: Connect Fabric Pipeline to On Premise SQL Server

Anonymous — Wed, 24 Apr 2024 20:13:22 GMT

Hi RajanLSEG
As per the screenshot , there are some blanks specified with a red warning. Please fill all the details and retry. Please let me know if the issue still persists.

Re: Connect Fabric Pipeline to On Premise SQL Server

RajanLSEG — Thu, 25 Apr 2024 03:32:18 GMT

Hi,

I filled up my database name and table ("Loading Failed") is the error in the drop down.

Thanks

Rajan

Re: Connect Fabric Pipeline to On Premise SQL Server

Anonymous — Mon, 29 Apr 2024 10:23:06 GMT

Hi RajanLSEG
Are you still facing this issue? Please let me know if the issue still persists.
Will surely help.

Thanks

Re: Connect Fabric Pipeline to On Premise SQL Server

Anonymous — Tue, 30 Apr 2024 16:01:22 GMT

Hi RajanLSEG
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

Re: Connect Fabric Pipeline to On Premise SQL Server

Anonymous — Thu, 02 May 2024 10:14:07 GMT

Hi @RajanLSEG
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

Re: Connect Fabric Pipeline to On Premise SQL Server

jake_BIV — Wed, 08 May 2024 23:16:30 GMT

Anonymous I am facing the same issue. Any ideas why this error is?

Please check your network connectivity to ensure your on-premises data gateway can access ncu.frontend.clouddatahub.net and restart the service to retry the connection again once the connectivity issue has been resolved.