none
SQL Server Reporting Services 2008 Not Responding

    Frage

  • 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.


    • Bearbeitet crusso1 Dienstag, 28. Februar 2012 14:20
    • Verschoben Challen FuModerator Mittwoch, 29. Februar 2012 07:00 for better support (From:SQL Server Reporting Services)
    Montag, 27. Februar 2012 16:39

Antworten