How to get rid of Security Warning in PME 9.0, PME 2020 when trying to connect to Web Application?

Issue
In PME 9.0 and PME 2020 when trying to open Web Application locally(directly on PME server) or remotely(through Web Client) a Warning Message pops up indicating:

"There is a problem with this website's security certificate."

The warning message provides two options either close the the webpage or continue to the website by acknowledging the warning message which causes inconvenience.

Product Line
Power Monitoring Expert (PME) 9.0, PME 2020

Environment
Web Application

Cause
By default PME 9.0 and PME 2020 use HTTPS between the servers and web clients which help to secure the system. PME is installed with a self-signed certificate, which is untrusted by internet browsers.

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

In order to get rid of this security warning message there are two options:

1. Replace the self-signed certificate(which is recommended) with a Security Certificate from a Certificate Authority(CA). Plan to have IT install an authority issued security certificate. For more information, please refer to PME 9.0 or PME 2020 System Guide FA358303 or FA401436 section: 'Installing and binding security certificates'.

2. Disable HTTPS. By default PME uses HTTPS between the server and the Web clients. To configure PME to use HTTP instead of HTTPS, follow the 3-step process shown below.

A - Configure Internet Information Services (IIS)
To remove the HTTPS binding:

1. Open IIS Manager on the PME server.
2. In the Connections pane (left pane) expand server name > Sites > Default Web Site. Right click Default Web Site and select Edit Bindings... from the context menu.
3. In the Site Bindings dialog remove any bindings to port 443 (https).
4. Click Close.

B - Configure PME for HTTP
Application Modules Database update

1. Open SQL Server Management Studio and connect to the PME SQL server.
2. Navigate to Databases -> ApplicationModules -> Views
3. Right-click on Configuration.ConfigurationSettings and selectEdit Top 200 Rows
4. Find the entry in the result set with the following values:
   1. ItemType = Web Framework
   2. Item = Server
   3. Key = LocalServerAddress
5. Update the Value column to http://localhost/.
6. Find the entry in the result set with the following values:
   1. ItemType = Web Framework
   2. Item = Server
   3. Key = IsSecureConnectionRequired
7. Update the Value column to be False.

ION_Network Database update

1. Open SQL Server Management Studio and connect to the PME SQL server.
2. Navigate to Databases -> ION_Network -> Views
3. Right-click on dbo.vCFG_ConfigItems and select Edit Top 200 Rows
4. Find the entry in the result set with the following values:
   1. Module = Reporting
   2. Category = General Settings
   3. Item = WebServiceUrl
5. Update the Value column to http://localhost/ionreportdataservice/ReportDataService.asmx.
6. Open a windows Command window (cmd.exe) and run iisreset.
7. Open the windows Services console, and restart the following service: ION Application Modules Core Services Host. Click Yes when asked to restart the ION Application Modules services.

Default Web Application link update

1. Open a Windows explorer window and navigate to: Desktop -> Power Monitoring Expert
2. Right-click on Web Applications and select Properties
3. Update the URL value with the updated url.

1. Open a windows Command window (cmd.exe) and run iisreset

Released for:Schneider Electric Canada