Install the Microsoft Dynamics AX database on SQL Server

Use one of the following procedures to install the Microsoft Dynamics AX database on a server running SQL Server.

Before installing the database, verify that you have completed the tasks in Prerequisites for installing the database on SQL Server.

Install the database using the Setup wizard

Use this procedure to install the Microsoft Dynamics AX database on Microsoft SQL Server. If you are installing other Microsoft Dynamics AX components at the same time, the installation screens will vary based on the components you are installing.

  1. Start Microsoft Dynamics AX Setup.

  2. Step through the initial wizard pages.

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

  4. On the Select components page, select Database (Microsoft SQL Server), and then click Next.

  5. On the Create new SQL Server database page, in the Server name box, type or select the name of the SQL Server computer to connect to. To connect to a named instance of SQL Server, enter it in the format ServerName\InstanceName.

    In the Database name box, type a name for the new database.

    Note

    We recommend that you use a uniform naming convention for all aspects of the installation, including the database name, the AOS name, and the application file instance name. For example, you might use a name like Fabrikam_DYNAX09_Live, which includes a shortened form of your business name, the Microsoft Dynamics AX version, and a code for the purpose of the installation.


    If you're installing multiple databases, provide a different name for each instance.

  6. Click Next until the component has been installed.

Install the database manually

If you want to create a SQL Server database manually for Microsoft Dynamics AX, you must first create a database using Setup as a template.

  1. Follow the procedure above to create a SQL Server database using Setup.

  2. Manually create a second SQL Server database using SQL Server Management Studio.

  3. Copy all objects, users, and user permissions from the template database to the new database.

  4. Configure an AOS instance to connect to the new database. Installing an AOS instance sets the appropriate rights for the AOS service account on the selected database server and creates stored procedures used for session management.

    If you want an existing AOS instance to connect to the manually created database, you must set the appropriate rights for the AOS account. Set the following permissions in the database:

    • Make the account a login on the database server. (This login already exists if you are installing on the same SQL Server computer as the first database.)

    • Assign the user to the db_ddladmin, db_datareader, and db_datawriter database roles.

    • Grant the user execute rights on the createserversessions and createusersessions stored procedures.