ReportViewer works remote from my PC but not server

Discussion in 'ASP.NET 2.0' started by shakasha, Dec 18, 2007.

  1. Hello!

    I have the reports working great from the Report Server Managemnet console, and I can use the ReportViewer in web pages that run from my PC using the remote server reports. However, when I try to run the same pages from the server on the live website, I get this error:
    (I've compared and sharedthe web.config and no luck.)
    Any ideas??? Thank you!


    Server Error in '/' Application.


    The specified module could not be found. (Exception from HRESULT: 0x8007007E) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)

    Source Error:





    Code:
    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
    Stack Trace:





    Code:
    [FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)]
       System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) +0
       System.Management.ManagementScope.InitializeGuts(Object o) +873
       System.Management.ManagementScope.Initialize() +213
       System.Management.ManagementObjectSearcher.Initialize() +145
       System.Management.ManagementObjectSearcher.Get() +34
       Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine) +273
       Microsoft.ReportingServices.Diagnostics.WebRequestUtil.get_LocalIPAddresses() +138
       Microsoft.ReportingServices.Diagnostics.WebRequestUtil.IsLocalIPAddress(String ipAddress) +37
       Microsoft.ReportingServices.Diagnostics.WebRequestUtil.IsClientLocal() +79
       Microsoft.Reporting.WebForms.ErrorControl.WriteStackTrace(HtmlTextWriter writer) +10
       Microsoft.Reporting.WebForms.ErrorControl.Render(HtmlTextWriter writer) +58
       System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
       System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
       System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
       Microsoft.Reporting.WebForms.ReportViewer.Render(HtmlTextWriter writer) +293
       System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
       System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
       System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
       System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
       System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +59
       System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +68
       System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
       System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
       System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +37
       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
       System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
       System.Web.UI.Page.Render(HtmlTextWriter writer) +26
       System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
       System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
       System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2558
    

    Version Information:Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    This error usually means that the InterOp component cannot find the COM object on the server.


    can you post your web.config?


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. Yes, thanks:







    <!--


    Note: As an alternative to hand editing this file you can use the


    web admin tool to configure settings for your application. Use


    the Website->Asp.Net Configuration option in Visual Studio.


    A full list of settings and comments can be found in


    machine.config.comments usually located in


    \Windows\Microsoft.Net\Framework\v2.x\Config


    -->


    <configuration>


    <appSettings>


    <add key="ReportingServiceUser" value="*********"/>


    <add key="ReportingServicePassword" value="*********"/>


    <add key="ReportingServiceDomain" value="artsineduco.web138.discountasp.net"/>


    </appSettings>


    <connectionStrings>


    <remove name="LocalSqlServer"/>


    <add name="LocalSqlServer" connectionString="Data Source=sql2k504.discountasp.net;Integrated Security=false;Initial Catalog=;User ID=SQL2005_418282_********_user;Password=********" providerName="System.Data.SqlClient"/>


    <add name="SQL2005_418282_artsineduConnectionString" connectionString="Data Source=sql2k504.discountasp.net;Initial Catalog=SQL2005_418282_artsinedu;Persist Security Info=True;User ID=SQL2005_418282_*****_user;Password=********" providerName="System.Data.SqlClient"/>


    </connectionStrings>


    <system.web>


    <!--


    Set compilation debug="true" to insert debugging


    symbols into the compiled page. Because this


    affects performance, set this value to true only


    during development.


    Visual Basic options:


    Set strict="true" to disallow all data type conversions


    where data loss can occur.


    Set explicit="true" to force declaration of all variables.


    -->


    <httpHandlers>


    <add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>


    </httpHandlers>


    <roleManager enabled="true"/>


    <compilation debug="false" strict="false" explicit="true">


    <assemblies>


    <add assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />


    <add assembly="Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />


    </assemblies>





    <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />


    <add extension=".rdl" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />


    </buildProviders>


    </compilation>


    <pages>


    <namespaces>


    <clear/>


    <add namespace="System"/>


    <add namespace="System.Collections"/>


    <add namespace="System.Collections.Specialized"/>


    <add namespace="System.Configuration"/>


    <add namespace="System.Text"/>


    <add namespace="System.Text.RegularExpressions"/>


    <add namespace="System.Web"/>


    <add namespace="System.Web.Caching"/>


    <add namespace="System.Web.SessionState"/>


    <add namespace="System.Web.Security"/>


    <add namespace="System.Web.Profile"/>


    <add namespace="System.Web.UI"/>


    <add namespace="System.Web.UI.WebControls"/>


    <add namespace="System.Web.UI.WebControls.WebParts"/>


    <add namespace="System.Web.UI.HtmlControls"/>


    </namespaces>


    </pages>


    <!--


    The <authentication> section enables configuration


    of the security authentication mode used by


    ASP.NET to identify an incoming user.


    -->


    <authentication mode="Forms">


    <forms loginUrl="User/permission.aspx" timeout="5000000" slidingExpiration="true"/>


    </authentication>


    <membership defaultProvider="OurMembershipProvider">


    <providers>


    <clear/>


    <add name="OurMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="LocalSqlServer" applicationName="/" enablePasswordRetrieval="True" enablePasswordReset="True" passwordFormat="Clear" requiresQuestionAndAnswer="True" maxInvalidPasswordAttempts="10" minRequiredPasswordLength="4" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression="" requiresUniqueEmail="false"/>


    </providers>


    </membership>


    <!--


    The <customErrors> section enables configuration


    of what to do if/when an unhandled error occurs


    during the execution of a request. Specifically,


    it enables developers to configure html error pages


    to be displayed in place of a error stack trace.


    <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">


    <error statusCode="403" redirect="NoAccess.htm" />


    <error statusCode="404" redirect="FileNotFound.htm" />


    </customErrors>


    -->


    </system.web>


    </configuration>
     
  4. Bruce

    Bruce DiscountASP.NET Staff

    This looks fine to me.


    Can you create a support ticket and send us the URL that reproduce the error? Our sysadmin can check the server and make sure the control is properly installed.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  5. I am haveing the same problem with the report viewer. Please help
     
  6. Bruce

    Bruce DiscountASP.NET Staff

  7. This is the web.config


    <configuration>
    <configSections>
    <sectionGroup name='system.web.extensions' type='System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'>
    <sectionGroup name='scripting' type='System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'>
    <section name='scriptResourceHandler' type='System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' requirePermission='false' allowDefinition='MachineToApplication'/>
    <sectionGroup name='webServices' type='System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'>
    <section name='jsonSerialization' type='System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' requirePermission='false' allowDefinition='Everywhere'/>
    <section name='profileService' type='System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' requirePermission='false' allowDefinition='MachineToApplication'/>
    <section name='authenticationService' type='System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' requirePermission='false' allowDefinition='MachineToApplication'/>
    </sectionGroup>
    </sectionGroup>
    </sectionGroup>
    </configSections>

    <system.web>

    <pages>
    <controls>
    <add tagPrefix='asp' namespace='System.Web.UI' assembly='System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'/>
    </controls>
    </pages>
    <!--
    Set compilation debug='true' to insert debugging
    symbols into the compiled page. Because this
    affects performance, set this value to true only
    during development.
    -->
    <compilation debug='false'>
    <assemblies>
    <add assembly='System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' />
    <add assembly='System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A' />
    <add assembly='System.Web.Extensions.Design, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35' />
    <add assembly='System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089' />
    <add assembly='Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A' />
    <add assembly='Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A' />
    </assemblies>

    <add extension='.rdlc' type='Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' />
    </buildProviders>
    </compilation>
    <httpHandlers>
    <remove path='*.asmx' verb='*' />
    <add path='*.asmx' verb='*' type='System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
    validate='false' />
    <add path='*_AppService.axd' verb='*' type='System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
    validate='false' />
    <add path='ScriptResource.axd' verb='GET,HEAD' type='System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
    validate='false' />
    <add path='Reserved.ReportViewerWebControl.axd' verb='*' type='Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
    validate='false' />
    </httpHandlers>
    <httpModules>
    <add name='ScriptModule' type='System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'/>
    </httpModules>
    </system.web>
    <system.webServer>
    <validation validateIntegratedModeConfiguration='false'/>
    <modules>
    <add name='ScriptModule' preCondition='integratedMode' type='System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'/>
    </modules>
    <handlers>
    <remove name='WebServiceHandlerFactory-Integrated'/>
    <add name='ScriptHandlerFactory' verb='*' path='*.asmx' preCondition='integratedMode' type='System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'/>
    <add name='ScriptHandlerFactoryAppServices' verb='*' path='*_AppService.axd' preCondition='integratedMode' type='System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'/>
    <add name='ScriptResource' preCondition='integratedMode' verb='GET,HEAD' path='ScriptResource.axd' type='System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'/>
    </handlers>
    </system.webServer>
    </configuration>
     

Share This Page