Forum Discussion
Connect SSMS or BI tool to Fabric Database
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
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