Attach Middleware

The SQL Server middleware must be attached to all servers that will be hosting M3 databases.

Verify that the SQL Server instances are configured to use a static port.

  1. Click Actions > Attach Product.
  2. Select the Microsoft SQL Server from the list. Click Next.
  3. Select the Location (the LifeCycle Manager Service) where the middleware is installed. Click Next.
  4. Enter the following:
    Name

    Enter a name for your middleware.

    Description

    Enter a description for your middleware

    SQL Server version

    Select Microsoft SQL Server version to attach.

    Default log directory

    Specify a folder for the system transaction logs.

    For example: X:\SQLLogs

    Note: 

    This field is optional and is only applicable if installing M3 Business Engine database on this server.

    If you have selected to attach the middleware on an external host, then this field will be disabled (greyed out).

    Default table directory

    Specify a folder for the tables.

    For example Y:\SQLData

    Note: 

    This field is optional and is only applicable if installing M3 Business Engine database on this server.

    If you have selected to attach the middleware on an external host, then this field will be disabled (greyed out).

    Default index directory

    Specify a folder for the indexes.

    For example Z:\SQLIndexes

    Note: 

    This field is optional and is only applicable if installing M3 Business Engine database on this server.

    If you have selected to attach the middleware on an external host, then this field will be disabled (greyed out).

    Note: 

    For more information about logs, tables and indexes, see M3 Business Engine and Microsoft SQL Server - Best Practices" (SQL Server BPG) on Xtreme Documentation Portal.

  5. Click Next.
  6. On the Summary screen, verify the property values, and click Finish to start the task.
  7. When the task is finished, a dialog appears. Click OK.

    To view the log file, either click View log or go to the Logs view.

    Note: 

    To change the default folders for the database files for a M3 BE environment before you install the environment: Right-click the SQL Server instance and select Change default root directory for database files.