How to: Access Just In Time Self-service UAT database for Dynamics 365 Finance and Operations

 In recent changes by Microsoft, you can't access the VM for Tier2+ environments. The only access you have is access to the Azure SQL database using Just In Time access.

You get temporary access to different databases of UAT according to your need. This is access is only for 8 hours, post that you need to request access again.

Let's access the AX database:

Login to LCS

Go to UAT environment -> Full details.

You should see request access controls like below:


you can get access as read-only or read-write depending on your request. 'AX troubleshooting' will give read-only access and 'Performance tunning for AX' will give read-write access to Azure SQL.

Once you click on Request access, refresh the page you should see 'Database accounts' section:



In the above screenshot, I requested both access. 

The next step is to enable access using IP whitelisting.

Go to Maintain -> Enable access


You need to add the public IP address from where you are going to access the Database. 
As you can see, you will add the firewall rule to access the 'Azure SQL' service for a particular IP address.

If you don't do this step you will below screen when trying to access the database and even if you sign in, you won't be able to access it.



Once both things are done you can use SSMS to access the database.



The server name is the SQL server name from LCS.
String in LCS will have XXXXXX.XXXX.XXX.database.windows.net\DB_NAME
Copy only the server name before '\' in server name

add user name and password from LCS.
Click on Options >>
on the next screen, change the default values in 'Connect to database' to the database name from the above string which is string after '\' section.
Click connect, now you can access the database.




 


 




Comments

  1. ferasDecember 16, 2020 at 2:59 PM

    Thanks man, this was helpful

    ReplyDelete
  2. Jagdeep SinghMay 3, 2021 at 5:53 AM


    The UAT testing process is taken up before planning to release the software into the market. This step ensures whether the software is complete according to the functional specifications defined by the product owner or not.

    ReplyDelete
  3. Digital TransformationMay 12, 2021 at 7:00 AM

    Thanks for providing great information and looking beautiful blog.
    Microsoft Dynamics 365 for Finance and Operations

    ReplyDelete
  4. Allen MarryMarch 6, 2022 at 9:15 PM

    IT's very informative blog and useful article thank you for sharing with us , keep posting learn more about Product engineering services | Product engineering solutions.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to : get the Deep URL for a particular form with filter in Dynamics 365 Finance and Operations

Image
 If you are a developer and need to generate the Deep-link then you can follow the code mentioned in MS docs at https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/create-deep-links But if you want to share a few URLs with filters already applied to other users then you can use the feature of  'Get a link' in D365FO. Suppose I want to share the list of all sales orders for customer 'US-001'. Go to Account Receivable -> Orders -> All sales orders  Filter by customer account 'US-001' Then in the navigation ribbon, go to Options and click on 'Get a link'   Copy all and paste the URL into new browser window. You will only see the sales orders for US-001. If you want to generate lot of deep URLs then you can also enable  'Automatically update query parameter' Once you enable this, as soon as you apply a filter on forms URL will be updated with the query parameters like below: You can copy and share the link directl
Read more

How to: Solve issue when DVT script for service model MRApplicationService on machine XXX failed

Image
I was running binary update from LCS when my deployment failed. The step which failed had a description " DVT script for service model MRApplicationService on machine XXX failed" When I checked the log, It was showing "Financial Reporting DVTs ran with 2 failures". To resolve it, I just reset the DataMart and resumed the deployment from LCS which then completed successfully. Those who do not know how to reset DataMart, We have to run the following command in Windows PowerShell. cd J:\MROneBox\MRInstallDirectory\Server\MRDeploy Import-module .\MRDeploy.psd1 Reset-DatamartIntegration -Reason OTHER -ReasonDetail "DB Refresh" 1st line is to change the directory where MRDeploy.psd1 script exists. depending on the environment typologies  some other common places where it can be found is G:\MRApplicationService\MRInstallDirectory\Server\MRDeploy K:\MROneBox\MRInstallDirectory\Server\MRDeploy 2nd line is to import the Script 3rd line is for
Read more

How to: Display individual financial dimension value in grid control

Image
To display inventory dimensions in the grid we have control of dimension display which can be set up as per the requirement.  But there is no control in D365FO to display financial dimensions in grid control.  There are 2 ways it can be done.  1. Create display methods to display particular financial dimensions like the below method which displays division. I have seen many examples on the internet using multiple find methods but I prefer it by doing one query with joins to improve performance issues. public display DimensionValue getDimensionDivision() {         DimensionAttributeValueSetItem  dimensionAttributeValueSetItem;         DimensionAttributeValue                dimensionAttributeValue;         DimensionAttribute                        dimensionAttribute;               select DisplayValue from dimensionAttributeValueSetItem             join dimensionAttributeValue             join dimensionAttribute             where dimensionAttributeValueSetItem.DimensionAttributeV
Read more