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
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.