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