On each Workbench installation there is one server running Microsoft SQL Server which hosts the main Workbench database and related databases. The data in these databases is shared by all the Workbench client PC's that run Workbench.
...
The server operating system may be any Windows Operating System capable of hosting SQL Server. This includes:
Windows Server 2008 R2(End of Life imminent)- Windows Server 2012
- Windows Server 2012 R2
- Windows Server 2016
- Windows Server 2019
...
Workbench will work with any version of Microsoft SQL Server after (and including) SQL Server 2008 R2. This includes:
SQL Server 2008 R2(End of Life imminent)- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017
...
- 4+ Cores Intel Xeon E5-2600 v1 series (and above) or similar AMD Processor *
- 8GB+ DDR3 / DDR4 RAM (recommended: 16GB+ RAM for servers with SQL Server Standard edition/Enterprise)
- Hard Disk OS > 64GB (recommended: RAID 1 SSD)
- Hard Disk Data > 240GB (recommended: RAID 1 SSD, or RAID 5/10 SAS 10k – 15k rpm, or FC adapter to SAN)
- Gigabit Network Interface
- Redundant Power Supplies
...
PowerShell
PowerShell v5.0 or above should be usable by the Workbench administrator.
SQL Server PowerShell Module
The SQL Server PowerShell module is not required but it is highly recommended for Workbench servers as it speeds up installs and upgrades, plus ensures consistent install / upgrade results..Installing the Client Connectivity SDK during SQL Server 2012+ installation will include all the required assemblies and files to allow the SQL Server PowerShell module to be used. For SQL Server 2008 R2 the SQL Server PowerShell Module can be installed by installing the SQL Server 2014 Feature Pack..