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
...
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
...
It is not necessary for the collation sequence of the Workbench database to be the same as that of the SQL Server instance in which it is installed.
Hardware Requirements
Although SQL Sever will run on laptops and PCs, for anything more than one or two users, an appropriately specified server box is required:
...
* Cores are specified as Workbench can run on a Virtual Machine.
Microsoft SQL Server Reporting Server (SSRS)
Starting from WebWorkbench version 4.2, SSRS is optional.
...
SQL Server 2008 R2 Express with Advanced Services(End of Life imminent)SQL Server 2008 R2(End of Life imminent)- SQL Server 2012 Express with Advanced Services
- SQL Server 2012
- SQL Server 2014 Express with Advanced Services
- SQL Server 2014
- SQL Server 2016 Express with Advanced Services
- SQL Server 2016
...
Reporting Mode needs to installed in 'Native' mode and NOT SharePoint mode.
PowerShell
PowerShell v5.0 or above should be usable by the Workbench administrator.
...