how to connect Just in time DB in D365F&O / Connect UAT Database with Dev machine in D365 F&O

 Connect UAT with the Dev Environment

Step 1: Go to LCS and select your UAT/ Tier 2 Environment 

Path: Click on your Project Name from the Top of the LCS screen.


Select your Environment full detail page


Step 2: you should have to enable access for you VM to connect UAT DB.

Click on Maintain -> Enable access


Now Modify firewall rules form is open.




Click on Plus button to add your VM ip address.

Now go to your VM and find your ip address by just checking on chrome with "what is my ip"


put your ipv4 ip address in the last open form "Add an Inbound Allow rule" in LCS
put anything in the Name field and select Confirm.

Now, you will get a popup from LCS.

Step 3: Go to Database accounts table 

field : Reason for access
select Performance tuning for AX (Write to AX)

field : Details
put any comment

Click on Request Access


Refresh your page and you can see the DB detail on the "DATABASE ACCOUNTS" Tab


copy all 4 keys to any notepad++ for clear readability.

How to Connect UAT with SSMS

open SSMS in your VM

click on the connected DB name in the Top left corner and click on connect

Connect to server form will open


put SERVER NAME, and USERNAME into the login field and password.
click on options and  
copy DB name and put it into the CONNECT TO DATABASE  field

and click on connect Now your SSMS successfully connected with UAT and you read or write data from here

How to connect your D365f&o Dev UI with UAT Database.

Goto webconfig and update all these parameters.
path : (Local Drive)K ->  AosServices -> WebRoot -> webconfig 

open it in notepad++ as a administrator

Note: 
Make sure you take a backup of your dev webconfig file

Search DataAccess.Database fron ctrl+F


Search sqlpwd


Reset your iis services through cmd and launch your D365f&o client.






























Comments

Post a Comment

Popular posts from this blog

How to remove deployed model in Tier2 environment in D365FO

 How to remove deployed model in Tier2 environment Dear all, I have an issue with the deployed model in the D365FO Tier2 environment. I have some models in the development environment: Model A Model B Model C Model D I want to apply only Models A, B, and C for the Tier2 environment, For the first time for deployment, I created a deploy package(including Model A, B, and C) in development and applied an update for the Tier 2 environment. However, yesterday, developer X on my team deployed a new deployment package(Model A,B,C,D). So today I could not deploy the package in Tier 2 with Models A, B, and C. Solutions: 1. Download the same package from Asset Library which was previously deployed. Add File ModuleToRemove.txt (with model listed). Reupload to Asset Library and deploy to UAT. When I do this,  there's a warning on LCS that "it will first reinstall the model and then delete it. In order to not reinstall, delete the model from package." 2. Create a new package (on dev m...
Read more

How to Create Auto Lookup Using EDT with Table Reference in D365 F&O

Image
  How to create a lookup in D365FO using X++? Lookups are the standard way to display a list of possible selection values to the user. For a user, while editing or creating database records, a lookup makes the data entry easy and errorless. In Microsoft dynamics 365 finance and operations, there are many ways of creating lookups. EDT and Table Relation Type lookups are the simplest forms of lookups in Microsoft dynamics 365 finance and operations. In this article, I will describe the very simplest type of lookup, which is EDT lookup, for making an EDT type lookup, a developer does not need to worry more about writing x++ coding,   Normally, standard lookups are created automatically by the system in Dynamics 365 for Finance and Operations and are based on the extended data types and table setup.  They are based on table relations and appear automatically. No additional modifications are required. Setting Up an EDT Lookup If you are a beginner use  Microsoft's free ...
Read more