Forum Discussion
Datamart (SQL) Server Connection String Details - Port number? Share email?
I would also like to know how to make that connection string work in other 3rd party tools. Using the string in Excel (via the SQL Server connector) just works. But not sure what else I need to do or what else I need to know for other tools. Typically other tools ask for the host, port, database (which is not part of the string I suppose), user id, and password. But when I input the string (not sure about port) as the host and my usual id and password I can't seem to get other tools to connect. Is there a general (or specific) guide for properly using the new Dataset string in other tools?
Hey robarivas
I can't get the Datamart connection string to work in Excel via its PQE. You say you can just pop the string in as-is? Can you share a screenshot or any configuration choices you've made?
Cheers! James
No configuration choices made except when given the credential choices between Windows, Database, and Microsoft account I chose Microsoft account.
Interesting. That's what I've selected each time too (use the MS Account).
Elsewhere in the thread MS has noted needing Private endpoints to be configured, reading into it now.Private Endpoints are NOT currently supported for datamart connectivity (documented in limitations), so it might explain why you can't connect, if you have them enabled for the organization.
