Forum Discussion

JGrant8708's avatar
JGrant8708
Frequent Visitor
4 years ago

Datamart (SQL) Server Connection String Details - Port number? Share email?

Dear Community,  I have created a small testing Datamart based on this brand-new functionality. Works really well in the service/browser.  Would love to test that I can connect to my PBI Datamart t...
Need Help
robarivas's avatar
robarivas
Post Patron
4 years ago

So in addition to Excel I've managed to connect with Azure Data Studio but cannot connect with SSMS (despite following the steps in Microsoft's official Datamart documentation) nor with any other tool.

marekr's avatar
marekr
Microsoft Employee
4 years ago

Can you please confirm that you're using the latest version of SSMS? Only a few tools are supported right now, but SSMS is one of them and should work if you're on a recent version.

  • robarivas's avatar
    robarivas
    Post Patron
    4 years ago

    Thanks marekr . SSMS did not work with v19 Preview. When I switched to the Generally Available version 18 it worked. Is there a way to find out what tools are supported (and any connection instructions for each)?

    • marekr's avatar
      marekr
      Microsoft Employee
      4 years ago

      Thanks for letting us know about the v19 Preview issue. I've been using version 18 and that is the only supported version of SSMS right now. We'll look into why v19 Preview doesn't work.

      • marekr's avatar
        marekr
        Microsoft Employee
        4 years ago

        SSMS v19 Preview uses a different Azure Active Directory application id than the one that is enabled for SSMS v18 by datamarts. We've already started the work for enabling the new application id last week. For now please use SSMS v18.