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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Simon_HJ
New Member

Fabic Lakehouse - SQL Connection

Hey All,

Last week I created my first Datalake using Fabric. After getting some data in it I wanted to start altering the data using SSMS but here I faced an issue. After fetching the SQL string from the endpoint object I get the error message below. I've tried to connect with Azure Data Studio instead, and also to create a new Lakehouse, still the same error.

What should I do?

Greatfull for any responses!!

Simon_HJ_0-1687172272790.png

 

1 ACCEPTED SOLUTION
GeethaT-MSFT
Community Support
Community Support

HI, @Simon_HJ Thanks for posting your question in Microsoft Fabric CommunityI hope you followed the steps correctly

Copy the Sql connection string from the Wharehouse 

GeethaTMSFT_0-1687192651943.png

Open the data engine from SSMS and if there is any previously used server name I recommend clear the data and past the above-copied connection string

GeethaTMSFT_3-1687193683661.png

 

And was able to connect to SSMS successfully 

GeethaTMSFT_4-1687194022749.png

Please let me know at which step you are facing the issue

Regards

Geetha

 

 

 

 

 

 

 

View solution in original post

4 REPLIES 4
MaxBronder
Frequent Visitor

Hi Simon, I have the same issue, could you explain how you solved it? 
thank you very much

Hey Max, sure thing!

So my issue was that the internal zScaler from my company was blocking a specific port needed to connect to the SQL string outside of fabric. I could access it from the office or when I turned of zScaler for a few minutes. The issue was resolved quite easily with a few changes to the rules in zScaler itself.

Simon_HJ
New Member

Hey!

Thank you for this explanation. I followed these exact steps when I got the error before.
It's now solved though! Was an internal issue with whitelising over VPN....

GeethaT-MSFT
Community Support
Community Support

HI, @Simon_HJ Thanks for posting your question in Microsoft Fabric CommunityI hope you followed the steps correctly

Copy the Sql connection string from the Wharehouse 

GeethaTMSFT_0-1687192651943.png

Open the data engine from SSMS and if there is any previously used server name I recommend clear the data and past the above-copied connection string

GeethaTMSFT_3-1687193683661.png

 

And was able to connect to SSMS successfully 

GeethaTMSFT_4-1687194022749.png

Please let me know at which step you are facing the issue

Regards

Geetha

 

 

 

 

 

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024  FBC Gallery Image

Fabric Monthly Update - March 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Kudoed Authors