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

Subscriptions for reports are hung in Status 'Pending' Expand / Collapse
Author
Message
Posted Friday, February 1, 2013 5:33 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 11, 2014 4:23 PM
Points: 471, Visits: 1,308
So - learned the hard way that there are Symmectric Encryption keys in the ReportServer. Was able to get it reattached and reencrypted, but now all the subscriptions have been wiped out.

When we put them back together - They are hanging in status as 'Pending' and I need to get this resolved asap, but have not been able to find anything on it.

This is a SQL Server 2008 R2 SSRS configuration. Databases are on one server, and the SSRS services are on another.

Thank you for any and all help, and please let me know if I may provide you with any other specifics (I am very inexperienced with SSRS and may not know everything you want to know to understand my situation here better).

Thanks,

SQL_ME_RICH
Post #1414874
Posted Thursday, February 7, 2013 8:51 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 11, 2014 4:23 PM
Points: 471, Visits: 1,308
Anyone?
Post #1417132
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse