SSRS 2008 R2 failing to restart
We upgraded our SQL Server Reporting services to the new SSRS 2008 R2 version from SSRS 2008 just last February. Since then we have been randomly having problems restarting the service. Any help or suggestion is greatly appreciated. Server Specs: Windows Server 2003 R2 64bit Total memory of 16GB SQL Server 2008 R2 (10.50.1600) When looking at the log, this is what I see.... dbpolling!WindowsService_0!1f30!04/08/2011-07:20:05:: i INFO: EventPolling polling service started dbpolling!WindowsService_0!1f30!04/08/2011-07:20:05:: i INFO: NotificationPolling polling service started dbpolling!WindowsService_0!1f30!04/08/2011-07:20:05:: i INFO: SchedulePolling polling service started dbpolling!WindowsService_0!1f30!04/08/2011-07:20:05:: i INFO: UpgradePolling polling service started dbpolling!WindowsService_0!1e38!04/08/2011-07:20:05:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started. dbpolling!WindowsService_0!15e0!04/08/2011-07:20:05:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started. dbpolling!WindowsService_0!1668!04/08/2011-07:20:05:: i INFO: PollingMaintenance: Polling started resourceutilities!WindowsService_0!1668!04/08/2011-07:20:05:: i INFO: Maximum memory limit is 2097152Mb rpcserver!DefaultDomain!1f30!04/08/2011-07:20:05:: e ERROR: RpcServerUseProtseqEp failed. Status=1740. appdomainmanager!DefaultDomain!1928!04/08/2011-07:20:05:: i INFO: The UserAccountControl value for the service account is 66048 rshost!rshost!113c!04/08/2011-07:20:05:: e ERROR: Failed to register url=http://+:80/ReportServer/ for endpoint 2, error=b7. rshost!rshost!113c!04/08/2011-07:20:05:: w WARN: Endpoint 2 is enabled but no url is registered for vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer. servicecontroller!DefaultDomain!1928!04/08/2011-07:20:06:: e ERROR: Error creating HTTP endpoint. System.Runtime.InteropServices.COMException (0x800700B7): Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7) at Microsoft.ReportingServices.HostingInterfaces.IRsUnmanagedCallback.CreateHttpEndpoint(RsAppDomainType application, String[] urlPrefixes, Int32 cPrefixes, String[] hosts, Int32 cHosts, Boolean wildCardPresent, String virtualDirectory, String filePath, Int32 authType, Int32 logonMethod, String authDomain, String authRealm, Boolean authPersist, Int32 extendedProtectionLevel, Int32 extendedProtectionScenario, Boolean enabled) at Microsoft.ReportingServices.Library.ServiceAppDomainController.SetWebConfiguration(RunningApplication rsApplication, Boolean enabled, String folder) servicecontroller!DefaultDomain!1f30!04/08/2011-07:20:06:: e ERROR: Exception caught starting RPC server: System.Runtime.InteropServices.COMException (0x800706CC): The endpoint is a duplicate. (Exception from HRESULT: 0x800706CC) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at RSRemoteRpcServer.RpcServer.StartServer(String rpcEndpointName, Byte[] webServiceUserSid, Object pNativeDelegation, Object pUnmanagedHost, String dumpLocation, String instanceName, String serviceName, Int32 dumperFlags, Boolean firstTime) at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime) appdomainmanager!DefaultDomain!1928!04/08/2011-07:20:06:: i INFO: The UserAccountControl value for the service account is 66048 rshost!rshost!914!04/08/2011-07:20:06:: e ERROR: Failed to register url=http://+:80/Reports/ for endpoint 3, error=b7. rshost!rshost!914!04/08/2011-07:20:06:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager. servicecontroller!DefaultDomain!1928!04/08/2011-07:20:06:: e ERROR: Error creating HTTP endpoint. System.Runtime.InteropServices.COMException (0x800700B7): Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7) at Microsoft.ReportingServices.HostingInterfaces.IRsUnmanagedCallback.CreateHttpEndpoint(RsAppDomainType application, String[] urlPrefixes, Int32 cPrefixes, String[] hosts, Int32 cHosts, Boolean wildCardPresent, String virtualDirectory, String filePath, Int32 authType, Int32 logonMethod, String authDomain, String authRealm, Boolean authPersist, Int32 extendedProtectionLevel, Int32 extendedProtectionScenario, Boolean enabled) at Microsoft.ReportingServices.Library.ServiceAppDomainController.SetWebConfiguration(RunningApplication rsApplication, Boolean enabled, String folder) rshost!rshost!166c!04/08/2011-07:20:06:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder. resourceutilities!DefaultDomain!1928!04/08/2011-07:20:06:: i INFO: Maximum memory limit is 2097152Mb rshost!rshost!1928!04/08/2011-07:20:06:: i INFO: Derived memory configuration based on physical memory as 16771724 KB library!WindowsService_0!1204!04/08/2011-07:20:06:: i INFO: Schedule 59d035f5-da30-439d-9ea5-c100e26571ba executed at 04/08/2011 07:20:06. library!WindowsService_0!1c44!04/08/2011-07:20:06:: i INFO: Schedule af16b59b-9f99-4700-917c-b79d0c513ccb executed at 04/08/2011 07:20:06. library!WindowsService_0!16b0!04/08/2011-07:20:06:: i INFO: Schedule ab1d6d21-6862-493d-8543-8063e41361a8 executed at 04/08/2011 07:20:06. schedule!WindowsService_0!1c44!04/08/2011-07:20:06:: Creating Time based subscription notification for subscription: 477aeadd-f2ae-4ad0-b81b-a575bab9167c schedule!WindowsService_0!16b0!04/08/2011-07:20:06:: Creating Time based subscription notification for subscription: d9de7aa8-eed6-4d3b-b2b9-4cb245ad9e18 schedule!WindowsService_0!1204!04/08/2011-07:20:06:: Creating Time based subscription notification for subscription: 6e9348c1-453d-41c0-8086-fbd990f090d9 servicecontroller!DefaultDomain!1cd0!04/08/2011-07:20:06:: i INFO: Total Physical memory: 17174245376 rpcserver!DefaultDomain!18d8!04/08/2011-07:20:06:: i INFO: Process monitoring started. appdomainmanager!DefaultDomain!1928!04/08/2011-07:20:06:: e ERROR: Either another process ReportingServicesService instance is already running or another application with the RPC endpoint ReportingServices$MSRS10_50.MSSQLSERVER is running. appdomainmanager!DefaultDomain!1928!04/08/2011-07:20:06:: e ERROR: Appdomain:1 DefaultDomain failed to initialize. Error: System.Exception: RPC Server failed to start. at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartInternal(Object parentThread). appdomainmanager!WindowsService_0!1f30!04/08/2011-07:20:06:: e ERROR: Appdomain:2 WindowsService_0 failed to initialize. Error: The endpoint cannot be created. appdomainmanager!DefaultDomain!f18!04/08/2011-07:20:06:: e ERROR: Windows service failed to start. Exception: System.Exception: Default appdomain failed to initialize. at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start() at Microsoft.ReportingServices.Library.ReportService.OnStart(String[] args) library!WindowsService_0!1204!04/08/2011-07:20:06:: i INFO: Schedule 59d035f5-da30-439d-9ea5-c100e26571ba execution completed at 04/08/2011 07:20:06. library!WindowsService_0!16b0!04/08/2011-07:20:06:: i INFO: Schedule ab1d6d21-6862-493d-8543-8063e41361a8 execution completed at 04/08/2011 07:20:06. library!WindowsService_0!1c44!04/08/2011-07:20:06:: i INFO: Schedule af16b59b-9f99-4700-917c-b79d0c513ccb execution completed at 04/08/2011 07:20:06. rpcserver!DefaultDomain!18d8!04/08/2011-07:20:06:: i INFO: Process monitoring stopped. rpcserver!DefaultDomain!1a18!04/08/2011-07:20:06:: i INFO: RPC Server stopped. servicecontroller!DefaultDomain!1a18!04/08/2011-07:20:06:: i INFO: RPC Server stopped. servicecontroller!WindowsService_0!1a18!04/08/2011-07:20:06:: i INFO: Service controller exiting. dbpolling!WindowsService_0!1594!04/08/2011-07:20:06:: i INFO: EventPolling polling service stopped dbpolling!WindowsService_0!1594!04/08/2011-07:20:06:: i INFO: NotificationPolling polling service stopped dbpolling!WindowsService_0!1e38!04/08/2011-07:20:06:: i INFO: HeartbeatThread(EventPolling): Exited. dbpolling!WindowsService_0!1594!04/08/2011-07:20:06:: i INFO: SchedulePolling polling service stopped dbpolling!WindowsService_0!1594!04/08/2011-07:20:06:: i INFO: UpgradePolling polling service stopped appdomainmanager!DefaultDomain!1a18!04/08/2011-07:20:06:: i INFO: Appdomain:2 WindowsService_0 unregistered. appdomainmanager!DefaultDomain!1a18!04/08/2011-07:20:06:: i INFO: Appdomain:2 WindowsService_0 unloading. appdomainmanager!DefaultDomain!1e38!04/08/2011-07:20:06:: i INFO: AppDomain:2 0 pending unload(s) library!WindowsService_0!1c44!04/08/2011-07:20:06:: e ERROR: Queue item has unhandled exception. System.Threading.ThreadAbortException: Thread was being aborted. at Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item) at Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item) at Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object state) dbpolling!WindowsService_0!1c44!04/08/2011-07:20:06:: e ERROR: Queue worker thread caught unhandled exception: System.Threading.ThreadAbortException: Thread was being aborted. at Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object state) appdomainmanager!DefaultDomain!1ce8!04/08/2011-07:20:06:: i INFO: Appdomain:2 unregistered. rshost!rshost!1ce8!04/08/2011-07:20:06:: i INFO: Application domain type WindowsService statistics: created: 1, unloaded: 1, failed: 0, timed out: 0. servicecontroller!DefaultDomain!1a18!04/08/2011-07:20:06:: i INFO: Service shutting down.NM
April 8th, 2011 10:00am

Hi, Not sure if you installed secuirity Patches or what. Check some link below for some reasons that may cause this. http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/c50a8797-8df8-4da0-8f74-4518476d4ad8 & http://blogs.msdn.com/b/emilianb/archive/2009/08/10/ssrs-service-might-not-start-after-installing-windows-security-patches-and-rebooting-the-machine.aspx Regards, PS
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2011 9:34am

Hi NM, To the issue of SetUp and Upgrade, I think it will be better if you could post the issue at SQL Server SetUp and Upgrade forum at this link http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads they are the best resources to supply the professional troubleshooting and assistance. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
April 10th, 2011 10:44pm

Can you please help in this issue? I am also getting the same problem in SSRS 2008.Thanks, Gaurav http://gauravsqlserver.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2011 8:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics