Install the Microsoft Dynamics AX databases
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.
Huomautus
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.
Varoitus
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.
Before you install the Microsoft Dynamics AX databases
Verify that the following steps are completed before you install the Microsoft Dynamics AX databases.
Configure SQL Server. For more information, see Configure SQL Server and storage settings.
On the computer where you plan to install the databases, run the prerequisite validation utility to verify that system requirements have been met. For information about how to run the prerequisite validation utility, see Check prerequisites.
For more information about the hardware and software requirements for Microsoft Dynamics AX, see the system requirements.
Make sure that you have the required permissions to install the database. For more information, see Verify that you have the required permissions for installation.
Make sure that the appropriate firewall ports are open. For more information, see Firewall settings for Microsoft Dynamics AX components.
Default models
The default models that are available in Setup vary based on the release of Microsoft Dynamics AX 2012 that you are installing.
Default models in Microsoft Dynamics AX 2012
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:
|
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. |
Default models in Microsoft Dynamics AX 2012 Feature Pack
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:
|
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:
|
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:
Huomautus 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. |
Default models in Microsoft Dynamics AX 2012 R2
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:
|
Include additional model files in the installation (optional)
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:
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.
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).
Copy the additional .axmodel files to the folders that you created.
Varoitus
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 (axsys.axmodel).
If models must be installed in a specific order, modify the ModelFileInstallOrder.xml file that is located in the Models folder. Models are installed in the order in which they appear in this file.
Tärkeä
The Foundation model (axsys.axmodel) must always be the first model that is listed in the ModelFileInstallOrder.xml file.
Install the Microsoft Dynamics AX databases
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.
Start Microsoft Dynamics AX Setup. Under Install, select Microsoft Dynamics AX components.
Advance through the first wizard pages.
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.
On the Select installation type page, click Custom installation, and then click Next.
On the Select components page, select Databases, and then click Next.
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.
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.
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.
Tärkeä
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.
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.
Huomautus
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.
On the Prerequisite validation results page, resolve any errors. When no errors remain, click Next.
On the Ready to install page, click Install.
After the installation is completed, click Finish to close the wizard.