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.
  • Processor Intel Xeon Quad Core X5570 2.93GHz or above recommended to manage up to 50 users simultaneously in a single-tier architecture.
  • 1 core per group of 40 sessions.
RAM memory
  • 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 software
  • Microsoft SQL Server 2014 R2 x64 Enterprise Edition, installed with the following options:
    • A named instance is recommended, but you can use a standard instance. This 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 a SMTP/POP3 server accessible from the server.
Publication server
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.