From time to time, you may have to debug a copy of the production database, but you are unable to export & import the DB to your dev machine, for example: the DB's size is too large, or it's an urgent issue, or the customer doesn't allow to export their Prod DB... Then you have to debug directly in the UAT environment.
There is an article from Microsoft that describes briefly about this here, but there is no screenshot and the information isn't detailed enough, so the purpose of this post is to guide you step by step to achive this :)
1. Find your ip address at https://nordvpn.com/what-is-my-ip/ and note it down
2. Enable just-in-time database access
Go to LCS > Select the Tier 2 environment > Maintain > Enable access
Click "Confirm" button at the bottom and then you can see a new record is added with your IP info.
Then under the Manage Environment, choose "Performance tuning for AX (write to AX)" as the "Reason for access" and write some descriptions and then click on "Request Access"
After that, refresh the page and you will see the login details under the Database Accounts
3. Change web.config in your DEV environment
In your DEV environment, backup the original web.config file at K:\AosService\WebRoot
Reference: https://stoneridgesoftware.com/how-to-connect-your-dev-and-uat-environments-in-dynamics-365-finance-and-operations/
