Hardware Requirements - MagmaGroup/SFOL-Public GitHub Wiki

General

Servers - Usually 4 are required

  1. one Build server -IIS, UDI, OPC, SQL Server
  2. one Test server -IIS, UDI, OPC, SQL Server
  3. Production environment - One IIS/UDI/OPC Server and one SQL Server

Additional Requirements

  1. VPN
  2. User Accounts
  3. Label Printing (If applicable)
  4. Internet Access

Production

The following table specifics the hardware and software requirements of a standard SFOL production environment. Requirements may change depending on the specific solution provided

Database Server Web Server Client PC
OS Windows 2012 Windows 2012 Windows 7 + (not CE or embedded)
RAM 64 GB 32 GB 4 GB
CPU cores 8 4 2
DISK OS Disk 100GB OS Disk 100 GB Requirements for OS and IE
Data/Log Disk preferably fast storage * 200 GB 50 GB support disk
Software SQL Server 2014/2016 *** standard or enterprise edition IIS, MSMQ IE version 11.0**
.NET Framework 4.62 4.62

* The speed of the disk is the bottleneck of the database performance (which is the bottleneck of the whole system) - physical server disks are usually not enough as the database gets bigger. you will need some SSD or enterprise storage solution.

** for SFOL version 7 (HTML 5.0) a webkit browser is required (i.e Chrome, Safari, Firefox, Edge)

*** - Collation for SQL Server must be Latin1_General_CI_AS

Build and Test (not stress) environments

As part of the development and testing process, two more environments are required - Build and Test. These environments are not used for stress therefore we may settle for a single server (for web and db) per environment which may have less resources. Software versions of OS and SQL must be the same as the production environment

Test/Build Server
OS Windows 2012
RAM 16 GB
CPU cores 4
DISK OS Disk 100GB
Data/Log Disk preferably fast storage * 200 GB
Software SQL Server 2014/2016 (Same as production) (may use developer free edition if available), IIS, MSMQ
.NET Framework 4.62

*** - Collation for SQL Server must be Latin1_General_CI_AS

VPN

Some remote connection option should be provided that meets the following criteria as the action development work is done on Magma's computers (containing all the tools - VS, Prompt, etc.)

  1. Enable database access through SSMS - meaning port 1434 must be open in firewall
  2. Enable browsing to SFOL - meaning port 80 must be open in firewall
  3. Enable file access to the server using UNC paths
  4. Enable RDP to servers with multiple connections - as several team members work on a project normally
  5. Port 13000 must be open in firewall to enable OPC Client access

User Accounts

username Type Purpose Requirements
sfolservice Active Directory The Service account for all SFOL components (IIS, UDI) Member of the local Administrators group on every SFOL server
Database administrator on SFOL SQL Server. DB_OWNER on each SFOL database.
Full control on file systems on each SFOL server
Full Control on MSMQ
Password must never expire
magma Active Directory Interactive uses for Magma's engineers Member of the local Administrators group on every SFOL server
Database administrator on SFOL SQL Server. DB_OWNER on each SFOL database.
sfol SQL Server Will be used to connect to the SFOL database through Microsoft SSMS from remote computers Database administrator on SFOL SQL Server. DB_OWNER on each SFOL database

Label Printing

BarTender

  1. BarTender must be installed on a separate server (not SFOL) that should have an OS which is capable of running .NET framework 4.62 (which means Server 2012+)
  2. At this point - only the 32 bit version of BarTender is supported
  3. All network printers that will be used should be defined on this server for all users.
  4. It is up to you whether to create several such servers (for build/test/Production)

Loftware

Internet Access

In General, SFOL doesn't require a constant internet connection. However we will require internet connection for the downloading and activation of software (SFOL, Kepware, etc).

SFOL is downloaded via FTP so port 21 should be open.