WebWorkbench 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 WebWorkbench supported server operating system should be:are:
Windows Server 2012
Windows Server
20082012 R2
Windows Server 2016
Windows Server
20122019
Windows Server
2012 R22022
.NET Framework
WebWorkbench Web Workbench requires at least .NET framework 4.58. 2. This This is not included with Windows 2008 or 2012 R2 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. WebWorkbench 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:
...
Application Development
.NET Extensibility 4.5 or higher
ASP.NET 4.5 or higher
ISAPI Extensions
ISAPI Filters
...
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, however, it is recommended to host IIS on it's its own separate, secure , server if WebWorkbench Web Workbench is made accessible from over the internet.
Recommended specifications for a physical stand-alone IIS Web Server:
4+ Cores Intel Xeon E5-2600 v1 series
(and above)or similar AMD
Processor *processors
- 4GB
8+
DDR3 /GB DDR4 RAM
(recommended: 8GB+) Hard Disk OS + Application > 70GB (
recommended:RAID 1 SSD recommended)
2 Network Cards- Redundant Power Supplies
* Cores are specified as Workbench can run on a Virtual Machine.
SQL Server Reporting Services (SSRS)
WebWorkbench requires SSRS 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 versions of SQL Server.
WebWorkbench can work without SSRS being setup except users will not be able to view reports via the web browser.
See the Microsoft SQL Server section information about SSRS requirements..
Workbench Version
WebWorkbench requires Workbench version of at least 7.34.
PowerShell
...
Workbench MDE Version
Workbench database schema (MDE) version must be updated to 7.41.3.0 before Web Workbench can be installed.
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.