Connect SSMS or BI tool to Fabric Database

[sbalani17]

Hello,

I am new to Microsoft Fabric but have worked with SQL Server and Azure databases before. I currently have the free trial of Microsoft Fabric and have set up a databse (preview). I am trying to connect to the SQL Analytics endpoint of the database from SSMS and my BI tool (not Power BI) but it doesn't seem to be working for me. Any ideas or suggestions?

Thanks.

[sbalani17]

Hi Dave,

It turns out I had an outdated version of SSMS which did not support authentication with Microsoft Entra. I updated my version of SSMS and logged in with MS Entra password and that worked with no issues.

Thanks.

[dlevy · Accepted solution]

 Hi @sbalani17 - Sorry to hear you are having trouble! 

Let's start with the easiest things and work our way up. In Fabric, in the browser, when you go into a database or analytics endpoint by clicking on it, you will be in the editor. You should see a button that says "Open in" in the top ribbon. 

Click on that button and select open in SSMS to get the connection string information to paste into SSMS. Paste the server name in, select your Entra authentication type and finally paste the database name in on the second tab. SSMS will reset the database name to <default> every time you change the authentication type. If you get an error about connecting to master then just paste your database name back into the second tab and try again.

If that works, please mark this as the answer so I know that you are good. Otherwise let me know what error message you are getting.

Thanks,

Dave