Windows SQL Server 2014

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

CategoryConfiguration requirements
Operating system
  • Microsoft Windows Server 2016.
  • Microsoft Windows Server 2012 R2 x64 Essentials, Standard, and Datacenter.
Computer
  • Industry-standard server or virtual machine.
  • Processors:
    • Recommended: Intel® Xeon® E5 v3 or later, E7 v3 or later
    • AMD OPTERON™ or EPYC™
    • Avoid low energy processors, best performance with a clock speed above 2.4 GHz
RAM
  • 2 GB for the OS + 2 to 6 GB per database instance (average) + 60 MB per connected user.
Disk space
  • SQL server 2014: 3 GB.
  • 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 softwareMicrosoft SQL Server 2014 R2 x64 Enterprise Edition, installed with the following options:
  • You can use a standard instance but a named instance is recommended. 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, the 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 2.4 must be installed on the application server: Download link
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 8) must be installed.