Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Not able to start SSRS service Expand / Collapse
Author
Message
Posted Thursday, September 19, 2013 5:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 14, 2014 3:11 AM
Points: 19, Visits: 170
Hi,
We have recently installed SQL Server security update SQLServer2005-KB948109-x86-ENU
on our SQL server 2005 SP2 instance(-32bit) after that we started getting below message from event viewer:


.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002

Not able to start SSRS service. Please advice how can we start the SSRS service

We tried rebooting the server and also restarting service ".NET Runtime Optimization Service v2.0.50727_X86" but could not start SSRS service
Post #1496322
Posted Friday, September 20, 2013 8:07 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 9:37 AM
Points: 612, Visits: 2,146
Is there anything in the logs? Or in the reporting services logs?
Post #1496905
Posted Friday, September 20, 2013 8:13 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 9:37 AM
Points: 612, Visits: 2,146
I just found this connect item.

It doesn't look good.
Post #1496909
Posted Friday, September 20, 2013 8:16 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 9:37 AM
Points: 612, Visits: 2,146
Sorry to spam you about this. i just noticed you're at SP2. Is there a reason you're staying at that SP level. There's a SP 3 & 4 too. Othere people with this problem have said that the problem went away after other updates.
Post #1496910
Posted Saturday, September 21, 2013 4:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 14, 2014 3:11 AM
Points: 19, Visits: 170
Thanks Steven for your reply.

We could resolve the issue by restoring back SSRS encryption key and than starting SSRS service.
Post #1497130
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse