installing the contoso test dataset

Microsoft Dynamics

AX 2012 R2

Installing the Contoso test

dataset

January 2013

http://www.microsoft.com/en-us/dynamics/erp-ax-overview.aspx

Send suggestions and comments about this document to

[email protected]. Please include the title with your feedback.

2 INSTALLING THE CONTOSO TEST DATASET

Table of Contents

Load the Contoso sample data .................................................................... 3

Load sample data for Retail ........................................................................ 3

Access the multiple-partition sample data .................................................. 3 Provision the administrative user for all partitions ........................................................................... 3 Access the partitions .............................................................................................................. 4 Change the partition that you log on to ....................................................................................... 6

3

INSTALLING THE CONTOSO TEST DATASET

Load the Contoso sample data

Load the Contoso sample data into Microsoft Dynamics AX by using the Microsoft SQL Server backup file provided in the Microsoft Dynamics AX 2012 Demo Images, Tools and Materials section of the Microsoft Dynamics AX 2012 R2 Release page.

1. After you complete the initialization checklist and create the required partitions, stop the AOS.

2. Restore the databases by using the backup file. Make sure to overwrite any existing databases. Remember to restore both databases that are included in the package.

3. Restart the AOS.

Before you continue, wait until the status of the AOS is Started in the Services Control Panel. The

restarting process may take several minutes, and you may receive a timeout message. Refresh the information in the Services Control Panel periodically to get the latest status.

4. Log on to the application via the client as the administrative user.

Load sample data for Retail

Sample retail data is created when you install and configure the components of the Retail system. To get started, see Install retail components on TechNet.

Access the multiple-partition sample data

The sample data includes multiple partitions. To access to the partitions and to set up users for each partition, you must complete the steps that are described in the following sections of this document.

Provision the administrative user for all partitions Before you can access data partitions, you must provision the administrative user for the partitions

that are included in the sample data.

1. Stop the AOS.

2. Run the following SQL script in SQL Server Management Studio:

DECLARE @NetworkDomain nvarchar(255);

DECLARE @NetworkAlias nvarchar(80);

DECLARE @SID nvarchar(124);

DECLARE @InitialPartition bigint;

select @InitialPartition=Recid from PARTITIONS where PARTITIONKEY=N'Initial'

select @NetworkAlias=NETWORKALIAS,@NetworkDomain=NETWORKDOMAIN,@SID=SID from USERINFO where PARTITION=@InitialPartition AND ID = N'Admin'

UPDATE USERINFO SET NETWORKDOMAIN=@NetworkDomain,NETWORKALIAS=@NetworkAlias,SID=@SID WHERE

PARTITION != @InitialPartition AND ID = N'Admin'


Access the partitions To access the different partitions, you must modify the client configuration.

1. Open the Microsoft Dynamics AX 2012 Configuration utility.

2. To edit the client configuration, click Manage.

3. Select Create Configuration, and then enter a name for the configuration.

4. In the Partition field, type the ID of the partition of your choice.

The following partitions are included in the sample data:

initial (Contoso Company)

ext (extended test data only)

ps (Public Sector data)

Note: If you dont provision the other partitions, you will always log on to the initial partition.

5


5. Save the changes.

6. Start the AOS.

7. Log on as the administrative user for the partition. You should see the data for only the partition that you selected. The name of the partition is displayed in the menu bar at the top of the

Microsoft Dynamics AX client.


Change the partition that you log on to To switch partitions, edit the client configuration again. You do not need to restart the AOS.

Alternatively, you can create a set of desktop shortcuts for the Microsoft Dynamics AX client, and set up each shortcut to open the program in a different partition. To set the partition in a desktop

shortcut, right-click an existing client shortcut, select Properties, and then enter the following text:

\Microsoft Dynamics AX\60\Client\Bin\Ax32.exe partition=ps

7


This document is provided as-is. Information and views expressed in this document, including URL and other Internet Web site references, may change without notice. You bear the risk of using it.

Some examples depicted herein are provided for illustration only and are fictitious. No real association or connection is intended or

should be inferred.

This document does not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and

use this document for your internal, reference purposes. You may modify this document for your internal, reference purposes. 2013 Microsoft Corporation. All rights reserved.

Microsoft Dynamics is a line of integrated, adaptable business management solutions that enables you and your people to make business decisions with greater confidence. Microsoft Dynamics works like and with familiar Microsoft software, automating and streamlining financial, customer relationship and supply chain processes in a way that helps you drive business success.

U.S. and Canada Toll Free 1-888-477-7989

Worldwide +1-701-281-6500

www.microsoft.com/dynamics

Load the Contoso sample dataLoad sample data for RetailAccess the multiple-partition sample dataProvision the administrative user for all partitionsAccess the partitionsChange the partition that you log on to

installing the contoso test dataset

Documents