Page Comparison

...

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 following server operating system may be any Windows Operating System capable of hosting SQL Server. This includes:are supported.

• Windows Server 2012

• Windows Server

  2008

  2012 R2

• Windows Server

  2012

  2016

• Windows Server

  2012 R2

  2019

• Windows Server

  2016

  2022

Microsoft SQL Server

Workbench will work with any version of Microsoft SQL Server after (and including) SQL Server 2008 R2. This includes:the following SQL Server versions.

• SQL Server

  2008 R2

  2014

• SQL Server

  2012

  2016

• SQL Server

  2014

  2017

• SQL Server

  2016

  2019

• SQL Server

  2017

  2022

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:

• has a character set compatible with English

• is case insensitive

• is not binary

The default collation settings on the SQL Server installation are an appropriate configuration.

...

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:

• 4+ Cores Intel Xeon E5-2600 v1 series (and above) or similar AMD

  Processor

  Processors *

• 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

  or 10 Gbps FC adapter to equivalent SAN)

• Gigabit Network Interface
• Redundant Power Supplies

* 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.

Microsoft SQL Server Reporting Services (SSRS) is packaged with each version of SQL. It is installed as a separate component from the SQL Server database engine. The version of SQL Server and SSRS do not need to be the same.

The following versions are supported:

• SQL Server 2008 R2 Express with Advanced Services
• SQL Server 2008 R2
• 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

SSRS is often deployed on the same server as SQL Server, but can be on it's own server.

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..

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.