Friday, March 9, 2012

Report Service failed to start

New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'LocalSystem' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

The service (and SQL server) is configured to use Local System as the account.

In RsReportServer.config change your WebServiceAccount to be the actual account the web service runs as, for instance ASPNET or Network Service. If you empty it, we will use a default for the OS.

Thanks
Tudor|||Dear Tudor,
I have similar problem. I've just installed the final version of sql 2005 (reporting services as well, side by side with the original sql 2000 + reporting services pair) and the Reporting Services (the old one) service doesn't start after the boot process. My error message is the following:

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Schedule and Delivery Processor does not exist.

at Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init()

at Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app)

at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()

at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)

at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

In my browser I got the following message instead of my report folders:
Unable to communicate with report server. Please verify that the report server is operational.

The RS'2005 service works fine but all my reports are on the old installation and I really need them. Each service uses Local system account except server-agents which use a domain account.
Please help me!
Thanks in advance,
marcell|||

Tudor,

Many thanks. Your pointer solved my problem also.

Regards,

Arun Philip

|||

anyone please help.... Im unable to start report server...Im not sure if this is similar with the problem posted by Dillon.....Thanks

Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!4/26/2007-09:40:01:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)

|||I get the Same Error RE LocalSystem account. Funny thing is, when i open the report server config file, there is NO NODE in the XML for the WebServiceIdentity. I treid to add it myself with NT AUTHORITY\System as per the MS KB Article but it is still not working... any ideas ?|||

This node doesnt exist in case you are woking on SQL 2000 Reporting services.

Hope This helps.

No comments:

Post a Comment