web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Connect to Cloud-hosted environment database

(0) ShareShare
ReportReport
Posted on by 8

Hi,


I have a dev Cloud-hosted environment, my question is, can I connect from outside the vm to the sql server from outside the machine (when the machine is running..)? And how do I do that?


Thanks

I have the same question (0)
  • Suggested answer
    huijij Profile Picture
    19,811 on at
    RE: Connect to Cloud-hosted environment database

    Hi,

    In a Microsoft managed sandbox, test, and acceptance testing environments, you are not allowed to remote desktop into the machine. Therefore instead, you need to use sql management studio from another machine to connect to the D365 database:

    docs.microsoft.com/.../database-just-in-time-jit-access

    dynamics365musings.com/.../

  • André Arnaud de Calavon Profile Picture
    300,217 Super User 2025 Season 2 on at
    RE: Connect to Cloud-hosted environment database

    Hi Astrid,

    What is the business requirement to access the database? Is it for troubleshooting purposes, for integrations, or something different? If you want to make integrations, you should be aware that there is no direct access to the production database. You then need to consider the options for integrations provided by Microsoft, like data management, web services or OData. There are also ISV solutions available for more advanced integrations.

  • AstridMalanka Profile Picture
    8 on at
    RE: Connect to Cloud-hosted environment database

    Good morning,

    Here is my case scenario.

    I did all the process to do the export to data lake and deployed the CDMUtil function app to read the csv and create the schema of the views.

    I am having issues reading the schemas of the views, I am not sure why.

    We need to add the following parameters to the configuration files.

    <add key="ProcessSubTableSuperTables" value ="true"/>

    <add key="AXDBConnectionString" value ="Server=DBServer;Database=AXDB;Uid=youruser;Pwd=yourpassword"/>

    I know that I can request an 8 hours access to the database, but those details need to be requests as needed and probably the password will change every time.

    So I am trying to find a solution to connect to my cloud environment, as when I asked for the permission to connect to the DB on UAT and I added the connection it did not read the schema of the entity.

    Any ideas how to use that AXDBConnectionString connection or better said, where to connect it?

    Thanks

    Astrid

  • André Arnaud de Calavon Profile Picture
    300,217 Super User 2025 Season 2 on at
    RE: Connect to Cloud-hosted environment database

    Hi Astrid,

    I would suggest to contact Microsoft Support and explain you have issues reading the schemas. The direct DB access is for troubleshooting only; not for making any configuration changes.  

  • Alex Panait Profile Picture
    170 on at
    RE: Connect to Cloud-hosted environment database

    If you want to connect from outside vm you need to setup the firewall ports inside vm and the network security group permission in azure so that the traffic can connect to sql probably port 1433

    see link https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver16

    This is however a security risk depending on the data you have in your vm environment.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 701 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 588 Most Valuable Professional

#3
Sumit Singh Profile Picture

Sumit Singh 544

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans