SQL Server 2008 R2: SSRS Service won't start.

Question

SQL Server 2008 R2: SSRS Service won't start.

thepotplants

Hall of Fame

Points: 3079
More actions
January 21, 2014 at 9:07 pm

#303437

I just fixed a problem, and i'd like to share what I found.
The error message/syptoms are very similar to this post:
I had an existing Installation of SSRS on a Win2008 R2 Server, Running SQL Server 2008 R2 (10.50.4000). This had been running fine and then 3 days ago it refused to start. The error message said:
The SQL Server Reporting Service (MSSQLSERVER) service on Local Computer started and then stopped. Some Services stop automatically if they are not in use by other services or programs
The Windows event viewer Application Log said:
The description for Event ID 133 from source Report Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\RSReportServer.config
Followed by:
Service cannot be started. System.Exception: Default appdomain failed to initialize.
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
at Microsoft.ReportingServices.Library.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
I tried repairing the install but that didn't help, and I attempted to uninstall and reinstall, but SQL wouldn't let me 'uninstall'.
I was suspicious of the first warning and the reference to the config file.
I started by comparing the config file from my problem server with a good file from another server side by side using notepad++. It highlighted that 1 line was missing from my config file from my problem server. The line was actually there, but for some reason Notepad++ was ignoring it.
I then looked at the file using visual studo, and that line showed the the xml nodes weren't closed correctly. In Visual studio it looked like this:
I don't know how it happened but 2 <> brackets in my reportserver.config file has been altered and were not being recognised by SSRS.
All I did was overwrite the offending characters and saved the file. And hey presto now it works!! 😀

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

vaibhav.tiparadi SSC Rookie Points: 43 More actions · Answer 1

Hi,

I am facing the exact same problem, as you did. I see same error messages you mentioned. However, the difference is, the rsreportserver.config file is completely messed up at my end i.e. the first tag <dsn> itself is empty wherein it contains some encrypted value and lot of tags are missing valuable information after comparing with other working config file.

I tried running rsconfig utility from command line, but getting following error. Don't know how to move ahead. tried lots of things but nothing works man!! 🙁

Error: HRESULT=0x8004023F For more information, see the event log in the Event Viewer.

Can u please help me resolve it?

Thanks,

Vaibhav

thepotplants Hall of Fame Points: 3079 More actions · Answer 2

Hi.

That doesn't sound good. :blink:

Personally I'd be trying to restore the file to a working version rather than trying to fix it. Do you have a backup of the server? If so any file from a few days prior should be ok.

I don't know if a sql repair could be performed. (work looking at)

Otherwise I think you'll be looking at unistall and reinstall.

I don't know if you'll have to redeploy reports again (or if security/permissions will be affected) as they're stored in the reportserver db. (make sure you have a backup).