Connection issue from Dataflow GEN2 to Fabric WHSE - error: 40 Could not open a connection to SQL

[JS23]

When trying to select an existing Fabric warehouse as a data destination for a dataflow GEN2 I get the following error message. Both artifacts are within the same Fabric workspace. I am currently running on a Trial capacity.  My findings so far:
- Creating a new workspace, warehouse, dataflow and warehouse connetion does not solve the issue

- The SQL endpoint of the warehouse works just fine as I can connect to it from within SSMS

For completeness, this is how i configured my Warehouse connetion:

I found a few posts online but nothing usefull. Any idea what is going on here?

Kind regards,
Jan

[v-prasare]

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?
If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.
Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-prasare]

If your issue still persists, please consider raising a support ticket for further assistance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth

MS Fabric community support

[v-prasare]

Hi @JS23,

Thanks for reaching our MS Fabric community support

Please refer  to below community solved similar thead let me know if this resolves this issue.

Solved: Named Pipes Provider, error: 40 - Could not open a... - Microsoft Fabric Community

Thanks,

Prashanth

Ms Fabric community support

[JS23]

Hi,

i found that tread myself, but is simply states that the issue went away by itself. As far as the checklist goes of things to do:

- SSMS connectc seamless to the SQL endpoint

- Port 1433 is open

Doing the exact same thing in a different tenant, on the same machine and the same network, works just fine. I has to be a Fabric thing, as the only thing I do is trying to select a Fabric warehouse as a data destination, from within a dataflow Gen2 in the very same workspace...