Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
chandukasani
Regular Visitor

Unable to access OnPrem Sql Server Through Pipeline

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 ? Screenshot 2023-07-19 150944.jpg

 

6 REPLIES 6
sergej_og
Super User
Super User

@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.

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 

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".

Yes @sergej_og They will be managed in the backend

chandukasani
Regular Visitor

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

 

GraceGu
Employee
Employee

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.