Dear Friends,
In this Article I will show you how to enable UAT database access for Development machine using just-in-time (JIT). Many times when something is not working as expected case in a Microsoft Dynamics 365 Finance and Operation environment and it would helpful to look at the underlying data that may not be visible on a form or report etc. Here are the detailed steps of How to enabling Just-In-Time(JIT) Database Access over Development Machine?
- Go to the LCS and select project -> Full detail menu of Standard acceptance test section from right sidebar.
- Go to Maintain Dropdown and select Enable access for using mentioned pc access only.
- Add for access of those network public IP because of firewall rules.
- Select AzureSQL Source and mention Name for access purpose. Google your public IP address and add in Source address prefix.
- Now little Scroll down and add Database Account. Select Performance tuning for AX (write to AX) for read and write access of UAT database. Mention detail purpose for access of database. Submit Request Access.
- Copy SQL Server\Database Name, Username, Password.
- Open SSMS and setup all details as per notepad like Server name Login username and password in Login Tab. Add Database in Connection Properties Tab.
- If you want also to connect your UAT database with your Dynamics 365 Finance and Operation. Go to K:/Service Volume ->AosService ->WebRoot. First backup copies your default Web.config file. Open Web.config file as a administrator to make save changes.
- Ctrl F and then find DataAccess.SqlPwd. Then find four line for changing the data access. Change Database, DbServer, SqlUser and SqlPwd as per notepad.
- Restart your World Wide Web Service from Services and reload your dynamics 365 Finance and Operation you have loaded all data as per UAT. Now you can easy to debug your customization with UAT data.
Happy DAXing ... 😀
