SQL Server Reporting Services 2008 Not Responding

Question

I have reporting services 2008 running on a windows server 2008 machine.  I have it working on my production machine, but we had to redue the development server and I for the life of me cannot seem to get the settings right.  It is installed and if I go to the http://<servername>/webreports directory I can run my reports from there.  However, I am trying to run the report from the ReportViewer through my internal website.  The ReportViewer.aspx page is setup as follows:

<rsweb:ReportViewer ID="rptViewer" runat="server" Width="900px"
                    Font-Names="Verdana" Font-Size="8pt" Height="500px"
                    ProcessingMode="Remote" onreporterror="rptViewer_ReportError" ZoomPercent="100" SizeToReportContent="True">
                    <ServerReport ReportPath=""
                        ReportServerUrl="" />
                </rsweb:ReportViewer>

Code Behind for Above Page:

        protected override void Page_Load(object sender, EventArgs e)
        {
            try
            {
                base.Page_Load(sender, e);
                //read an load menu for user
                if (!IsPostBack)
                {
                    rptViewer.Attributes.Add("style", "margin-bottom: 175px;");

                    rptViewer.ServerReport.ReportServerUrl = ReportsUtils.getReportServerUrl();
                    rptViewer.ServerReport.ReportPath = ReportsUtils.getReportPath("MasterJobTicket");

                    string rptParams = (string)Session[ReportsUtils.SESSION_SERVICE_ORDERS];

                    rptViewer.ServerReport.SetParameters(ReportsUtils.GetJobTiketsParameters(rptParams));

                    rptViewer.ServerReport.Refresh();
                }
            }
            catch (Exception ex)
            {
                logger.Error(ex.ToString());
                logger.Error(ex.StackTrace);
            }
        }

        protected void Page_PreRender(object sender, EventArgs e)
        {
            string report = rptViewer.ServerReport.ReportPath.ToString().Substring((rptViewer.ServerReport.ReportPath.ToString().IndexOf("s/") + 2), rptViewer.ServerReport.ReportPath.ToString().Length - (rptViewer.ServerReport.ReportPath.ToString().IndexOf("s/") + 2));
            Session["Report"] = report;
        }

       
        protected void rptViewer_ReportError(object sender, Microsoft.Reporting.WebForms.ReportErrorEventArgs e)
        {

            logger.Error(e.Exception.ToString());
            logger.Error(e.Exception.StackTrace);

        }

Here is the log file error:

<Header>
  <Product>Microsoft SQL Server Reporting Services Version 2007.0100.5500.00 ((Katmai_PCU_Main).110921-2358 )</Product>
  <Locale>English (United States)</Locale>
  <TimeZone>Central Standard Time</TimeZone>
  <Path>C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__02_27_2012_10_06_04.log</Path>
  <SystemName><ServerName></SystemName>
  <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>
  <OSVersion>6.0.6002</OSVersion>
  <ProcessID>3852</ProcessID>
</Header>rshost!rshost!f38!02/27/2012-10:06:04:: i INFO: CLR runtime is initialized.
rshost!rshost!f38!02/27/2012-10:06:04:: i INFO: Derived memory configuration based on physical memory as 2097024 KB
appdomainmanager!DefaultDomain!a34!02/27/2012-10:06:04:: i INFO: Entered managed ServiceMain in DefaultDomain.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing AuthenticationTypes to '5'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
library!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.
configmanager!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Using report server internal url http://localhost:80/ReportServer.
configmanager!DefaultDomain!e90!02/27/2012-10:06:04:: i INFO: Using report server external url http://<ServerName>:80/ReportServer.
appdomainmanager!DefaultDomain!e90!02/27/2012-10:06:05:: i INFO: Appdomain:2 WindowsService_0 started.
resourceutilities!WindowsService_0!e90!02/27/2012-10:06:05:: i INFO: Reporting Services starting SKU: Enterprise
resourceutilities!WindowsService_0!e90!02/27/2012-10:06:05:: i INFO: Evaluation copy: 0 days left
resourceutilities!WindowsService_0!e90!02/27/2012-10:06:05:: i INFO: Running on 2 physical processors, 2 logical processors
rshost!rshost!5fc!02/27/2012-10:06:05:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer.
rshost!rshost!5fc!02/27/2012-10:06:05:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
rshost!rshost!59c!02/27/2012-10:06:05:: i INFO: Registered url=http://+:80/WebReports/, vdir=/WebReports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager.
rshost!rshost!59c!02/27/2012-10:06:05:: i INFO: Currently registered url http://+:80/WebReports/ on endpoint 3
rshost!rshost!59c!02/27/2012-10:06:05:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
resourceutilities!DefaultDomain!e90!02/27/2012-10:06:05:: i INFO: Reporting Services starting SKU: Enterprise
resourceutilities!DefaultDomain!e90!02/27/2012-10:06:05:: i INFO: Evaluation copy: 0 days left
rshost!rshost!e90!02/27/2012-10:06:05:: i INFO: Derived memory configuration based on physical memory as 2097024 KB
servicecontroller!DefaultDomain!59c!02/27/2012-10:06:05:: i INFO: Total Physical memory: 8588464128
rpcserver!DefaultDomain!dbc!02/27/2012-10:06:05:: i INFO: Process monitoring started.
library!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: Catalog SQL Server Edition = Enterprise
crypto!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: Initializing crypto as user: <ServerName>\Administrator
crypto!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: Exporting public key
crypto!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: Performing sku validation
crypto!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: Importing existing encryption key
dbpolling!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: EventPolling polling service started
dbpolling!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: NotificationPolling polling service started
dbpolling!WindowsService_0!5fc!02/27/2012-10:06:05:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.
dbpolling!WindowsService_0!144!02/27/2012-10:06:05:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.
dbpolling!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: SchedulePolling polling service started
dbpolling!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: UpgradePolling polling service started
dbpolling!WindowsService_0!f98!02/27/2012-10:06:05:: i INFO: PollingMaintenance: Polling started
runningjobs!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds.  Cycle: 600 seconds
runningjobs!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
runningjobs!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
runningjobs!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 57234 seconds.  Cycle: 86400 seconds
runningjobs!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: SQM timer timer enabled: Next Event: 60834 seconds.  Cycle: 86400 seconds
rpcserver!DefaultDomain!ae8!02/27/2012-10:06:05:: i INFO: RPC Server started.
servicecontroller!DefaultDomain!ae8!02/27/2012-10:06:05:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10.MSSQLSERVER'
appdomainmanager!WindowsService_0!ae8!02/27/2012-10:06:05:: i INFO: Appdomain:2 WindowsService_0 initialized.
servicecontroller!DefaultDomain!59c!02/27/2012-10:06:06:: e ERROR: Error searching the SPN for service account System.Runtime.InteropServices.COMException (0x8007203A): The server is not operational.

   at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
   at System.DirectoryServices.DirectoryEntry.Bind()
   at System.DirectoryServices.DirectoryEntry.get_AdsObject()
   at System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne)
   at System.DirectoryServices.DirectorySearcher.FindAll()
   at Microsoft.ReportingServices.Library.ServiceAppDomainController.LogServiceAccountSPN()
library!DefaultDomain!ae8!02/27/2012-10:06:06:: i INFO: Catalog SQL Server Edition = Enterprise
appdomainmanager!DefaultDomain!6c4!02/27/2012-10:06:44:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-129748324040362070 started.
appdomainmanager!ReportServer_0-1!6c4!02/27/2012-10:06:44:: i INFO: RS authentication mode is 5; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
appdomainmanager!DefaultDomain!6c4!02/27/2012-10:06:44:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-129748324040362070 initialized (#1).
webserver!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Reporting Web Server started
resourceutilities!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Reporting Services starting SKU: Enterprise
resourceutilities!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Evaluation copy: 0 days left
resourceutilities!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Running on 2 physical processors, 2 logical processors
runningjobs!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
runningjobs!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
library!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Catalog SQL Server Edition = Enterprise
crypto!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Initializing crypto as user: <ServerName>\Administrator
crypto!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Exporting public key
crypto!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Performing sku validation
crypto!ReportServer_0-1!6c4!02/27/2012-10:06:48:: i INFO: Importing existing encryption key
library!WindowsService_0!e90!02/27/2012-10:16:05:: i INFO: Call to CleanBatch()
library!WindowsService_0!e90!02/27/2012-10:16:05:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings.
library!WindowsService_0!e90!02/27/2012-10:16:05:: i INFO: Call to CleanBatch() ends
library!WindowsService_0!a34!02/27/2012-10:26:05:: i INFO: Call to CleanBatch()
library!WindowsService_0!a34!02/27/2012-10:26:05:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings.
library!WindowsService_0!a34!02/27/2012-10:26:05:: i INFO: Call to CleanBatch() ends

The EventViewer Says:

Failed to unload app domain DefaultDomain. The following exception occurred: Error while unloading appdomain. (Exception from HRESULT: 0x80131015).

Any help is greatly appreciated.

Thanks.

Answer 1

Hi crusso1,

From your information, I get that you want to display the report deployed on the report server via reportviewer control in remote module, could you please refer to this thread about this scenario http://forums.asp.net/t/1660761.aspx/1

For more information about Configuring ReportViewer for Remote Processing, please see: http://msdn.microsoft.com/en-us/library/ms252075.aspx

Thanks,

---

Challen Fu

TechNet Community Support