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
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
This is however a security risk depending on the data you have in your vm environment.
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.
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
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.
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:
#1
André Arnaud de Cal...
291,735
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
