...
It is possible to host the different Workbench components, SQL Server, Workbench Share, and Workbench Client, on the same server, or each component on separate systems.
Windows Server Operating System
The server operating system may be any Windows Operating System capable of hosting SQL Server. This includes:
- Windows Server 2008 R2
- Windows Server 2012
- Windows Server 2012 R2
- Windows Server 2016
Microsoft SQL Server
Workbench will work with any version of Microsoft SQL Server after (and including) SQL Server 2008 R2. This includes:
...
Expression versions are supported if the databases are under 10 GB. It is recommended to install "Express with Advanced Services" which includes SQL Server Reporting Services (SSRS).
Database Collation
Workbench will work with any standard collation sequence that:
...
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.
...
Reporting Mode needs to installed in 'Native' mode and NOT SharePoint mode.
PowerShell
PowerShell v4.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..
...