Edit

Share via

Apply demo data to a Finance Cloud-hosted environment

Applies To: Project Operations Integrated with ERP

Important

This article is only applicable only Microsoft Dynamics 365 Finance version 10.0.13 and can be performed only on a Cloud-hosted environment. Complete the steps in this article BEFORE you apply quality updates to the environment.

  1. In your LCS project, open the Environment details page. Notice that it includes the details needed to connect to the environment by using Remote Desktop Protocol (RDP).

Environment Details.

The first set of highlighted credentials are the local account credentials and contain a hyperlink to the remote desktop connection. The credentials include the environment admin username and password. The second set of credentials are used to log in to SQL Server in this environment.

  1. Remote to the environment by the hyperlink in Local Accounts, and use the Local Account credentials to authenticate.
  2. Go to Internet Information Services > Application Pools > AOSService and stop the service. You are stopping the service at this point so that you can continue to replace the SQL database.

Stop AOS.

  1. Go to Services and stop the following two items:
  • Microsoft Dynamics 365 Unified Operations: Batch Management Service
  • Microsoft Dynamics 365 Unified Operations: Data Import Export Framework

Stop Services.

  1. Open Microsoft SQL Server Management Studio. Log in with SQL server credentials and use the axdbadmin user and password from the LCS Environments details page.

SQL Server Management Studio.

  1. In Object Explorer, Databases and locate AXDB. You will replace database with a new database that is located in the Download Center.
  2. Copy the zip file to the VM you are remoted into and extract zip contents.
  3. In SQL Server Management Studio, right-click AxDB, and then select Tasks > Restore > Database.

Restore Database.

  1. Select Source Device and navigate to the file extracted from zip you copied.

Source Devices.

  1. Select Options, and then select Overwrite the existing database and Close existing connections to destination database.
  2. Select OK.

Restore Settings.

You will receive confirmation that the AXDB restore was successful. After you receive this confirmation, you can close SQL Services Management Studio.

  1. Go back to Internet Information Services > Application Pools > AOSService and start the AOSService.

  2. Go to Services and start the two services you stopped earlier.

  3. Locate the AdminUserProvisioning tool on this VM. Look under, K:\AosService\PackagesLocalDirectory\bin\AdminUserProvisioning.exe.

  4. Run the .ext file using your user address in the Email Address field.

  5. Select Submit.

Admin User Provisioning.

This takes a couple of minutes to complete. You should receive a confirmation message that the Admin user was successfully updated.

  1. Lastly, run Command Prompt as Administrator and perform iisreset

IIS Reset.

  1. Close the remote desktop session and use the LCS Environment details page to log in to the environment to confirm it is working as expected.

Finance and operations.