This page outlines the steps required to update MP Web
Before proceeding with the update please ensure the web server has the following prerequisites installed;
- Ensure .NET Framework 4.8 is installed.
- Ensure .NET Framework 6.0 Hosting Bundle
- Ensure URL Rewrite Module is installed.
Firstly you'll need to visit https://www.ehsdata.com/support/downloads-for-administrators and download the MP Web ZIP file for the version you are wishing to update to. You'll also need to download the related SQL scripts. If you're unsure of your login details please contact your assigned account manager or send an email to support@ehsdata.com
The SQL scripts zip will contain a DataDB_Update.sql and GatewayDB_Update.sql file. The GatewayDB_Update.sql file will need to be run against the MP5WebGateway MSSQL database for your installation. This may be a task that a DBA has to do depending on your level of access.
Once you've downloaded the MP Web ZIP file you'll need to extract it somewhere on the server of the MP Web installation.
Next locate the folder that contains the existing MP Web and create a copy as a backup. Now open the folder that contains the existing MP Web install:
Delete all the files from this folder except for the 'Reports' Folder and the appsettings.json file. Once deleted rename appsettings.json to appsettings_old.json as we'll need this in a couple of steps time. Note, if you're updating from a version prior to 19.0 you will not have an existing appsettings.json, instead keep the web.config file and rename it to web_old.config.
Locate the ZIP file you've just extracted and copy/paste the new files into the directory of the MP Web installation. Once you've done this open the new appsettings.json and old appsettings_old.json (or web_old.config if it's pre 19) file and copy across the details in the connection strings from the old to the new file. 
Depending on your setup you'll need to update the following fields;
Server=SERVERNAME - Replace SERVERNAME with your SQL server name and ensure to include the instance name or port number if a custom instance or port is in use e.g. EHSSQL01\EHSDBSERVER or EHSSQL01,12345
Database=MP5WebGateway - Replace MP5WebGateway with the name of your gateway database. If EHS Data has set this up it will typically be just MP5WebGateway so this may not need changing.
Trusted_Connection=False - Change this value to True if using WinAuth to connect to the database or leave this as False if using a SQL User
User id=ENTER_USERNAME - Replace this with the username of your SQL user if using SQL Authentication to connect to the gateway database
Password=ENTER_PASSWORD - Replace this with the password for the SQL user being used to connect to the gateway database"
If you're website is not utilising an SSL certificate you'll need to change the EnableSSL flag from 'True' to 'False' in the Settings section.
Once the appropriate details have been copied across save and close the file. Before starting the website ensure .NET 4.8, .NET 6.0 Hosting Bundle and URL Re-write module 2.0 are installed on the web server.
Back in IIS expand the folder structure of the MP Web website, look for the folder called Reporting, right click and select Convert to Application. On the Add Application screen leave the default settings and click OK. The icon of the reporting folder should then change as shown below;
Once the above has been complete browse to the installation in a web browser by either hitting browse in IIS or if you know the URL navigating to it: