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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
BeyzaKzlky
Frequent Visitor

Cannot Connect to On-prem SQL Server from Data Pipeline

Hi all,

I have a problem with conenction to SQL from datapipeline in Fabric. 

I don't see my data gateway, and it doesn't let me to connect SQL with any other connection. 

I see only basic authentication kind. When I want to edit existing conenction, I can choose authentication kind as organizational, but again it doesn't let me to connect. 

I have read in community that is not possible to connect to SQL from Fabric pipelines but I'm not sure.

Is there anyone who faced with this issue?

Thanks.

6 REPLIES 6
v-nikhilan-msft
Community Support
Community Support

Hi @BeyzaKzlky 
Thanks for using Fabric Community.
How are you trying to connect to SQL server using pipeline? Are you using Copy data activity? Are you trying to connect to an on-premises SQL Server or an Azure SQL database?
Can you share more details about the community discussion you referenced? If you are getting any error while connecting the SQL server please provide the error details, so that I can help you better.
Thanks.

Hi @v-nikhilan-msft 

Like I have mentioned above, I'm trying to connect on-prem SQL server. 

I cannot see gateway to trying to get data with copy data activity. 

And again like I have mentioned above, I can only see authentication kind basic. 

Error says that you can not reach your server, yes that's right, because I don't want to open my server, I want to use data gateway like I did in Power BI previously. 

After this error, I'm trying to edit connection, at that part I can see the authentication options, I choose organizational, but after a while it says we couldn't update. 

I have made some research and saw that data gateway is not available for Fabric pipeline. I thinks there is no any other solution to wait for a development about this part. 

Hi @BeyzaKzlky 
Yes, currently this feature is on roadmap.

vnikhilanmsft_0-1705578812906.png

You can refer to this link for more info: What's new and planned for Data Factory in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Thanks

 

Hi, I am experiencing the same issue. Is this update still scheduled for Q1 2024?

Hi @BeyzaKzlky 
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the query.
Otherwise, will respond back with the more details and we will try to help.
Thanks

Hi @BeyzaKzlky 
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the query.
Otherwise, will respond back with the more details and we will try to help.
Thanks

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

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

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.