Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
Goals and Symptoms
Permission Denied error when attempting to view historical data through Webreach on XP SP2 or Win 2003 Server SP1
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 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 . The Query Server may not be running. Permission denied
Facts and Changes
2003 Server SP1
Causes and Fixes
Due to the increased security settings applied in these service packs.
There is currently no known resolution.
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 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
It is possible that the workaround described above will 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 . The Query Server may not be running. Automation error Catastrophic failure
/ion/Historical/GetLogs.asp, line 40
Last Revised: 9 July 2007
All content © 1992-2007 Schneider Electric