Windows SQL Server 2016

This document describes the minimum configuration requirements when installing the Software package application and data servers on a Microsoft® Windows - SQL Server 2016 server.

CategoryConfiguration requirements
Operating system
  • Microsoft Windows Server 2016.
  • Microsoft Windows Server 2012 R2 x64 Essentials, Standard, and Datacenter.
Computer
  • Processor x64 2.0GHz or faster.
RAM memory
  • 2 GB for the OS + 2 to 6 GB per database instance (average) + 60 MB per connected user.
Disk space
  • SQL server 2016: 6 GB minimum.
  • For Sage X3 (reference folder and software): 4 GB.
  • For the demo folder: 4 GB.
  • For the exploitation folder: Depends on the data managed. A sizing tool is available to calculate the size requirements.
Database software Microsoft SQL Server 2016 x64 Standard or Enterprise Edition, installed with the following options:
  • A named instance is required. It will be used to create the product database.
  • Regardless of the instance type, it must have the following characteristics:
    • Sorting (collation) order should be Latin1_General_BIN
    • Mixed mode is mandatory to support authentication both by Windows and by SQL Server.
    • Access to the sa user.
  • By default, communication by TCP/IP or Namepipe is not activated. It must be enabled for these two modes.
  • The SQL Server Browser service must be launched.
Mail server
  • The workflow engine used in "Classic" mode requires an SMTP/POP3 server accessible from the server.
Publication server
  • An Apache server version 2.2 or later must be installed on the application server:
    • Download link
    • Select the no_ssl MSI installer package: httpd-2.2.25-win32-x86-no_ssl.msi.
User accounts
  • For the actual software users, it is recommended to define a user group and assign the access to the different software folders after the software component installation.
Others
  • A SAFE X3 ADXADMIN administration runtime must be installed on the server.
  • A JDK or java runtime environment (version 7 or later) must be installed.
  • SSMS version 16.5.3 must be installed. Later versions should not be used.
  • SAFE X3 Management Console CFG.239 must be installed.