Install Microsoft SQL Server 2016

Note: 

It is recommended to perform Windows Update to enhance the SQL Server security and performance before running the installation.

Preparations

M3 BE SQL Server Instance Requirements

  1. Mount the Microsoft SQL Server 2016 installation media on the server.
  2. Run setup.exe and select Installation/New SQL Server stand-alone installation or add features to an existing installation.
  3. Optionally: Accept installation of Product Updates (if any) and click Next.
  4. Check for warnings or errors in Install Rules, and click Next.
  5. Optionally: Select Perform a new installation of SQL Server in Installation Type, and click Next.
  6. Enter the Product Key and click Next.
  7. Accept the licensing terms in the License Terms window, and click Next.
  8. Select the following options in the window Feature Selection, and accept or change instance root directory and Shared feature directory:
    • Database Engine Services

      Note: 

      SQL Server Management Tools is no longer installed from the main feature tree and must be downloaded separately.

    Click Next.

  9. In the Feature Rules window, check for errors and warnings and click Next.
  10. In the Instance Configuration window, leave the Default instance check box selected, or name the new Named instance. Click Next.
  11. In the Server Configuration window, accept the Virtual account or select a specific, dedicated Windows user account (local or domain) for all SQL Server services and enter passwords ( M3 Business Engine and Microsoft SQL Server - Best Practices, version for M3 BE 15.1 and Microsoft SQL Server 2016). Mark the check box "Grant Perform Volume Maintenance Task privilege".

    In the Collation tab, choose Latin_General (Latin_General_BIN2) binary sort for Database Engine, and click Next.

  12. In the Database Engine Configuration window, select Mixed mode (SQL Server authentication and Windows authentication).

    Specify the sa login password.

    Note

    Always use a strong password for the sa account and change the password periodically.

    Add a (current) User as SQL Server administrator.

    Accept or change data directories in the "Data Directories" tab.

    In the TempDB tab, accept default values or configure the tempdb by following the recommendations in the M3 Business Engine and Microsoft SQL Server - Best Practices, version for M3 BE 15.1 and Microsoft SQL Server 2016 in Infor Xtreme Documentation.

    Do not enable FILESTREAM for Transact-SQL access in the FILESTREAM tab.

    Click Next.

  13. In the Feature Configuration Rules window, check for errors and warnings and click Next.
  14. In the Ready to Install window, check the summary and click Install.
  15. In the Complete window, click Close.