Finance | Project Operations, Human Resources, ...

Connect to Cloud-hosted environment database

(0) Share

Report

Posted on by AstridMalanka

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)

All responses (5)

Answers (0)

Suggested answer

huijij 19,811 on at

Like (1)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 300,731 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 300,731 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Alex Panait 170 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Connect to Cloud-hosted environment database

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Connect to Cloud-hosted environment database

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates