Wednesday, March 7, 2012

Reporting Server on Window Server 2000, IIS 5.1

I have SQL server 2005 with reporting service on a machine with Windows 2000 with IIS 5.1. Now in the Reporting Services Manager I see a big X on Server Status, Web Service Identity and Initialisation.

In Server Status if I click on start I get the error: and if I click on it I get the message:
"The task failed:
System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)"

If I click on Initialization I get:
"There was en error while switching panels. The most likely cause is an error retreiving WMI properties. The exception detailsare:
An error accured when attemting to connect to the report server remote ca (RCP) end point. Verify that the Report Server Windows service is running, and the retry the operation.
Details:
The RCP server is not listening (Exception from HRESULT: 0x800706B3)"

I went and look in the SQL Server Configuration Manager and I can see that the SQL Server Reporting Services is stoped and is set to start automatically. If I try to start it manually I get an error as well:
"The request failed or the service did not respond in a timely fashion. Consult the event log or other application error logs for details.

Now if I look in my Application log I see the following error:
"Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'SERVEUR\ASPNET' 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) "

If one of you have ideas on what I have to do to make this work please let me know.

Thanks

Is there any other forums more specialize where I could ask this question?

Thanks

|||

Ok I think I got a solution. Wow you really have to know it because honestly the error messages provided by windows were not helping at all.

So anyway find the file rsreportserver.config and locate the line <WebServiceAccount></WebServiceAccount>
and replace it with
<WebServiceAccount>NT Authority\System</WebServiceAccount>
Save the file.
Go in the SQL Server Configuration Manager and start the SQL Server Reporting Services.
Now if you go in the Reporting Services Configuration Manager the Initialization should be green instead of a red X.|||

Hey Freedom, thanks for the post. It worked for me.

No comments:

Post a Comment