WebReach Historical Access Error on XP SP2

Goals and Symptoms

Summary
Permission Denied error when attempting to view historical data through Webreach on XP SP2 or Win 2003 Server SP1

Symptoms

This problem occurs on systems using Windows XP Service Pack 2 or 2003 Server SP1. The following error pops up when a user tries to View Data on a Data Log Viewer through WebReach:

Error Type:

PEGQuery (0x80040C8E)

Error with provideHTML. Error with GenerateHTML. WebReachHistoricalASP in GetQuery: -2147218290 Cannot execute default connection: An error occurred in GetConnectionStringFromQueryServer while attempting to access Query Server [QUERYSERVER.NITRO] with handle [327952]. The Query Server may not be running. Permission denied

Facts and Changes

Keywords
Webreach

Historical Data

XP SP2

2003 Server SP1

IIS

Permission Denied

Causes and Fixes

Cause
Due to the increased security settings applied in these service packs.

Resolution
There is currently no known resolution.

Workaround
Step 1: Setting Permissions

WebReach requires launch and activation privileges for the accounts used. This is performed using the Component Services applet, which can be found under Control Panel-> Administrative Tools. Once in Component Services proceed with the following steps:

1.       Expand Component Services and Computers respectively
2.       Right-click on My Computer
3.       Select Properties
4.       Choose the COM Security tab
5.       Under Launch and Activation Permissions, select Edit Default
6.       If the following accounts are not displayed, you will need to add them:
<machine name>\IUSR_<machine name>
<machine name>\IWAM_<machine name>



IF THE ACCOUNTS ARE NOT THERE:
To add these accounts, click to Add… button shown above in the Launch Permission window. This will lead to the following screen:



You can add the user(s) under the local host computer name as shown above.
Once you create the users, make sure that the user(s) has/have permission to at least Remote Launch and Local Activation. Full access is advised if the user is the administrator. See below:





Step 2:  Configuring Webreach

1.       Open Control Panel-> Windows Firewall.
2.       Select the Advanced tab
3.       Under Network Connection Settings, select Advanced Settings
Select Web Server(HTTP) as shown below



More Information
The workaround described above may resolve the problem with accessing historical data through WebReach when the error message is displayed such as:

PEGQuery error '80040c8e'
Error with provideHTML. Error with GenerateHTML. WebReachHistoricalASP in GetQuery: -2147218290 Cannot execute default connection: An error occurred in GetConnectionStringFromQueryServer while attempting to access Query Server [LOGSRV.STEADFAST] with handle [327952]. The Query Server may not be running. Automation error Catastrophic failure /ion/Historical/GetLogs.asp, line 40