Export (0) Print
Expand All
4 out of 7 rated this helpful - Rate this topic

Install the Microsoft Dynamics AX databases [AX 2012]

Updated: October 22, 2013

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

This topic describes how to install the Microsoft Dynamics AX databases and model files.

There are three database components: the Microsoft Dynamics AX transaction database, the model store, and the baseline model store. The Application Object Server (AOS) connects to the Microsoft Dynamics AX database to process transactions. The AOS connects to the model store to display forms and reports. The baseline model store is used to upgrade X++ code to Microsoft Dynamics AX 2012, and to analyze application updates before they are applied.

Beginning with Microsoft Dynamics AX 2012 R2, the model store and the transaction data are stored in separate databases. In other versions of Microsoft Dynamics AX 2012, the model store and transaction data are stored in a single database.

NoteNote

If you are upgrading databases between Microsoft Dynamics AX 2012, Microsoft Dynamics AX 2012 Feature Pack, and Microsoft Dynamics AX 2012 R2, you should review Scenario: Perform in-place upgrade to Microsoft Dynamics AX 2012 R2.

Model files contain metadata information about application objects and are stored in the model store. For more information about model files, see Models, Layers, and the Model Store.

Caution noteCaution

If you plan to enable database mirroring in Microsoft SQL Server, you must enable it after you install the Microsoft Dynamics AX database and AOS. If you enable database mirroring before you install Microsoft Dynamics AX components, warnings are generated when the AOS is installed.

Verify that the following steps are completed before you install the Microsoft Dynamics AX databases.

The default models that are available in Setup vary based on the release of Microsoft Dynamics AX 2012 that you are installing.

If you are installing the original release of Microsoft Dynamics AX 2012, the following models are available in Setup by default.

Model

Description

Foundation

The base Microsoft Dynamics AX model, which contains the application framework and the application foundation. This model also contains functionality for the discrete manufacturing industry. This model is required.

Foundation Upgrade

The model that is used to upgrade from Microsoft Dynamics AX 2009 or Microsoft Dynamics AX 4.0.

Foundation Labels

Application labels for the foundation model. This model includes labels for the following languages:

  • Danish (Denmark)

  • Dutch (Netherlands and Belgium)

  • English (Canada, Ireland, Malaysia, New Zealand, Singapore, United Kingdom, United States, Australia, and South Africa)

  • French (France, Canada, Belgium, and Switzerland)

  • German (Germany, Austria, and Switzerland)

  • Italian (Italy, Switzerland)

  • Spanish (Spain, Mexico)

Process Manufacturing

The model that contains features for Process manufacturing production and logistics for Microsoft Dynamics AX. You can use these features to manage production, inventory, and costs in a process-controlled environment, such as in the food, chemical, and pharmaceutical industries.

Process Manufacturing Upgrade

The model that is used to upgrade Process manufacturing production and logistics from Microsoft Dynamics AX 2009 or Microsoft Dynamics AX 4.0.

Public Sector

The Public Sector model for Microsoft Dynamics AX. This model addresses the special controls, rules, and regulations of Public Sector organizations.

Project Management

The model that contains additional project-related features for Microsoft Dynamics AX. You can use these features to invoice customers for various billing scenarios, such as billing per unit of delivery and billing when a milestone is completed. You can also use these features to create customer and vendor retentions, and to manage workers on projects.

Project Management Upgrade

The model that is used to upgrade Project Management from Microsoft Dynamics AX 2009 or Microsoft Dynamics AX 4.0.

If you are installing Microsoft Dynamics AX 2012 Feature Pack, the following models are available in Setup by default.

Model

Description

Foundation

The base Microsoft Dynamics AX model, which contains the application framework and the application foundation. This model also contains functionality for the discrete manufacturing industry. This model is required.

Update for Foundation

Cumulative update for the Foundation model. If you selected to install the Foundation model, this model is installed automatically.

Foundation Upgrade

The model that is used to upgrade from Microsoft Dynamics AX 2009 or Microsoft Dynamics AX 4.0.

Update for Foundation Upgrade

Cumulative update for the Foundation Upgrade model. If you selected to install the Foundation Upgrade model, this model is installed automatically.

Foundation Labels

Application labels for the foundation model. This model includes labels for the following languages:

  • Danish (Denmark)

  • Dutch (Netherlands and Belgium)

  • English (Canada, Ireland, Malaysia, New Zealand, Singapore, United Kingdom, United States, Australia, and South Africa)

  • French (France, Canada, Belgium, and Switzerland)

  • German (Germany, Austria, and Switzerland)

  • Italian (Italy, Switzerland)

  • Spanish (Spain, Mexico)

Foundation Labels II

Application labels for the foundation model. These labels are for languages that were released after Microsoft Dynamics AX 2012 was made generally available. This model includes labels for the following languages:

  • Arabic (Saudi Arabia)

  • Finnish (Finland)

  • Icelandic (Iceland)

  • Norwegian Bokmal (Norway)

  • Swedish (Sweden)

  • Thai (Thailand)

SYP labels

Cumulative update of labels that were added by software updates in the SYP layer.

Extensions

Microsoft Dynamics AX extensions for the following industries:

  • Process Manufacturing - Process manufacturing production and logistics for Microsoft Dynamics AX. Allows you to manage production, inventory, and costs in a process-controlled environment, such as in the food, chemical, and pharmaceutical industries.

  • Public Sector - Addresses the special controls, rules, and regulations of Public Sector organizations.

  • Project Management – Allows you to invoice customers for various billing scenarios, such as billing per unit of delivery and billing when a milestone is completed. You can also create customer and vendor retentions, and manage workers on projects.

  • Retail - Provides mid-market and large retailers a complete head office and point of sale (POS) solution.

ImportantImportant

This model is required when you install Microsoft Dynamics AX 2012 Feature Pack. If the model includes functionality that you do not plan to use, turn off the appropriate license codes and configuration keys. Do not uninstall this model to remove unwanted functionality. Uninstalling models that are released by Microsoft will put the system in an unsupported state. If you have uninstalled this model, you must reinstall it using the instructions found in How to: Export and Import a Model.

Extensions Upgrade

The model that is used to upgrade Process Manufacturing, Public Sector, Project Management, or Retail from Microsoft Dynamics AX 2009 or Microsoft Dynamics AX 4.0.

If you are installing Microsoft Dynamics AX 2012 R2, the following models are available in Setup by default.

Model

Description

Foundation

The base Microsoft Dynamics AX model, which contains the application framework, the core application, extensions for industries, and localizations for countries/regions. This model is required.

Foundation Upgrade

The model that is used to upgrade from Microsoft Dynamics AX 2009 or Microsoft Dynamics AX 4.0.

Foundation Labels

Application labels for the foundation model. This model includes labels for the following languages:

  • Arabic (Saudi Arabia)

  • Chinese (China)

  • Czech (Czech Republic)

  • Danish (Denmark)

  • Dutch (Netherlands and Belgium)

  • English (Canada, India, Ireland, Malaysia, New Zealand, Singapore, United Kingdom, United States, Australia, and South Africa)

  • Estonian (Estonia)

  • Finnish (Finland)

  • French (France, Canada, Belgium, and Switzerland)

  • German (Germany, Austria, and Switzerland)

  • Hungarian (Hungary)

  • Icelandic (Iceland)

  • Italian (Italy, Switzerland)

  • Japanese (Japan)

  • Latvian (Latvia)

  • Lithuanian (Lithuania)

  • Norwegian Bokmal (Norway)

  • Polish (Poland)

  • Portuguese (Brazil)

  • Russian (Russia)

  • Spanish (Spain, Mexico)

  • Swedish (Sweden)

  • Thai (Thailand)

When you install the databases, you must identify any additional model files that are required for your environment.

During installation, Setup displays models from the CD\Models\ folder and all its subfolders. To import additional layers or customizations, you can add other model files to this folder.

Follow these steps to include additional models in the installation:

  1. Browse to the directory where the files from the Microsoft Dynamics AX DVD are shared. For more information, see Create a shared directory for installation.

  2. Create a subfolder in the CD\Models\ folder. We recommend that you create different folders to store the models that are received from different sources. For example, create a folder for each independent software vendor (ISV) or each value-added reseller (VAR).

  3. Copy the additional .axmodel files to the folders that you created.

    Caution noteCaution

    Do not copy your model files to the Standard folder. The Standard folder must be used only for models that are mandatory, such as the Foundation model (Foundation.axmodel).

Use this procedure to install the Microsoft Dynamics AX databases and model files. If you install other Microsoft Dynamics AX components at the same time, the installation pages vary, depending on the components that you are installing.

  1. Start Microsoft Dynamics AX Setup. Under Install, select Microsoft Dynamics AX components.

  2. Advance through the first wizard pages.

  3. If the Setup Support files have not yet been installed on the computer, the Select a file location page is displayed. The Setup Support files are required for installation. Enter a file location or accept the default location, and then click Next. On the Ready to install page, click Install.

  4. On the Select installation type page, click Custom installation, and then click Next.

  5. On the Select components page, select Databases, and then click Next.

  6. On the Prerequisite validation results page, resolve any errors. For more information about how to resolve prerequisite errors, see Check prerequisites. When no errors remain, click Next.

  7. On the Select databases page, select whether you want to create new databases by using Setup, or whether you want to configure existing databases. If you are upgrading, you should select to configure existing databases.

  8. If you want Setup to create the databases, on the Create new databases page, in the Server name list, select the name of the computer that runs SQL Server. Provide database names or accept the default database names. By default, the transaction database is named MicrosoftDynamicsAX. The baseline database is optional. By default, the baseline database is named MicrosoftDynamicsAX_baseline.

    If you created the databases manually, or if you are upgrading a database, on the Configure existing databases page, select the name of the computer that runs SQL Server, and then select the names of the existing databases that you want to configure.

    ImportantImportant

    The database name must not include any spaces or any of the following characters: backslashes (\), slashes (/), periods (.), commas (,), colons (:), brackets ([ ]), parentheses (( )), or hyphens (-). For more information about characters that are allowed by SQL Server, see the Identifiers topic on MSDN.

    Click Next.

  9. On the Select additional models page, select models in the Available Models list. Setup lists all the models that are contained in the Models folder and its subfolders. Required models are selected by default, and you cannot clear the selection.

    Security noteSecurity Note

    You may have models, or .axmodel files, that are not electronically signed. The Setup program cannot verify the publisher of an unsigned model file. If you import an unsigned model file into the model store, you create a security risk. Setup displays an error message if a selected model file does not have a digital signature. Before you decide whether you want to continue or cancel the installation, carefully review the models that you have selected.

    If you install models other than the Foundation models, you must complete the Compile application task when you run the initialization checklist. If you do not complete the Compile application task, you encounter errors when you run the Synchronize database task in the initialization checklist. For more information about the initialization checklist, see Initialize Microsoft Dynamics AX.

    Click Next to continue.

  10. On the Prerequisite validation results page, resolve any errors. When no errors remain, click Next.

  11. On the Ready to install page, click Install.

  12. After the installation is completed, click Finish to close the wizard.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.