Unable to access OnPrem Sql Server Through Pipeline

[chandukasani]

Hi Team , 

we are unable to access the data which is available in the SQL Server (On-Prem), Are there any Integration RunTime Limitations on this One ? 

[sergej_og]

@chandukasani 
Do you have a SHIR in use? I hope so, you (will) need one.
Hope communication (firewall rules established?) between SQL Server host to SHIR host is available.

In my experience so far (for enabling connection to on-prem SQL DB) you have to share your SHIR with your ADF, after that you are able zo connect to on-prem SQL Server.
Please check firewall rules and sharing SHIR with your ADF.

[chandukasani]

Hi @sergej_og Are you suggesting for the fabric pipelines or with adf pipelines ,just to get clarity because in fabric it will managed in the backend right 

[sergej_og]

Hi @chandukasani,
in this specific case I meant an ADF pipeline (beacuse fabric components are still in preview).
I assume that fabric pipelines have same functionality like ADF pipelines.

Not sure what you mean by "in fabric it will manged in the backend".

[chandukasani]

Yes @sergej_og They will be managed in the backend

[chandukasani]

Hi , @GraceGu Thanks For Reply ,Is there any ETA For That One ?

[GraceGu]

This is not there yet. Can you vote this Fabirc idea Support for on-prem connectivity within Pipelines in Fabric?