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

It's the standard port number (1433). Please make sure you use the latest SSMS and ADS versions. It won't connect with older versions. For SSMS please select "Azure Active Directory - Universal with MFA" Authentication.

JGrant8708's avatar
JGrant8708
Frequent Visitor
4 years ago

Thanks marekr 

I've appended ",1433" in ADS (latest version, fresh install on a new PC today) and am now receiving a connection issue: 

 

Still progress as it's a different error at least!
I've also received confirmation that the Share email did go through to one of my colleagues, though I'm unsure if they're able to connect using it (they haven't had the time as yet). 

 

What might loosen this security issue? (it's a Datamart in a Premium workspace that I'm an Admin of and I created/refreshed the Datamart, all using the same personal AD account)

Cheers! James