Web Workbench provides a web browser based user interface for accessing the Workbench database. It has additional server requirements over the standard Workbench server installation.
Server Operating System
The supported server operating system are:
- Windows Server 2012
- Windows Server 2012 R2
- Windows Server 2016
- Windows Server 2019
- Windows Server 2022
.NET Framework
Web Workbench requires .NET framework 4.8. This is not installed by default before Windows Server 2022 and will need to be downloaded and installed separately.
Internet Information Services (IIS)
IIS is the built-in Web Server included with Windows Server Operating Systems. Web Workbench is compatible with the following versions:
- IIS 8.0
- IIS 8.5
- IIS 10
Windows Features
The following Windows Features need to be installed as part of the IIS role installation:
Web Server (IIS)
Web Server
Common HTTP Features
Default Document
Directory Browsing
HTTP Errors
Static Content
HTTP Redirection
Health and Diagnostics
HTTP Logging
Logging Tools
Request Monitor
Performance
Static Content Compression
Dynamic Content Compression
Security
Request Filtering
Basic Authentication
Client Certificate Mapping Authentication
Digest Authentication
IIS Client Certificate Mapping Authentication
IP and Domain Restrictions
URL Authorization
Windows Authentication
Application Development
.NET Extensibility 4.5 or higher
ASP.NET 4.5 or higher
ISAPI Extensions
ISAPI Filters
Management Tools
IIS Management Console
IIS Management Scripts and Tools
Hardware Requirements
Even though IIS can run on the same server as the SQL Server and/or the Workbench Server, it is recommended to host IIS on its own separate, secure server if Web Workbench is made accessible over the internet.
Recommended specifications for a physical stand-alone Web Server:
- 4+ Cores Intel Xeon E5-2600 v1 series or similar AMD processors *
- 8GB DDR4 RAM
- Hard Disk OS + Application > 70GB (recommended: RAID 1 SSD)
- 2 Network Cards
- Redundant Power Supplies
* Cores are specified as Workbench can run on a Virtual Machine.
SQL Server Reporting Services (SSRS)
Web Workbench uses SSRS 2016 or higher to render reports in the web browser. In most cases SSRS is installed on the same host as the SQL Server, although it may also be installed on a separate server if using non-Express editions of SQL Server.
Web Workbench can work without SSRS except users will not be able to view reports via the web browser.
See the Microsoft SQL Server section information about SSRS requirements.
Since version 4.2 Report Server Local Mode has been introduced to remove the need for SSRS to render web reports. With this mode turned on, the web application renders reports locally with Microsoft ReportViewer Controls. However it may be significantly slower than SSRS depending on the environment. Therefore SSRS is still recommended for on-premise installations where Report Server Local Mode performance is not satisfactory.
Workbench MDE Version
Web Workbench requires Workbench MDE version of at least 7.41.3.0.
PowerShell
PowerShell v5.0+ is required by the Workbench administrator for deployment.
External Access
Web Workbench is a .NET web application. A public domain name and a valid web certificate are required to enable secure HTTPS protocol that allows secure external access to Web Workbench on public networks. For on-premise installations, it is up to client IT to organise and manage the domain name and certificate, as well as the network infrastructure that directs user requests to the web server.