Post reply

Looking for information on SSRS Reports

  • July 29, 2015 at 10:35 pm

    #306204

    My SSRS reports are deployed on a server owned by a different team and now they are planning to upgrade their server. Should i manually take a copy of all reports and note down the schedules etc or should i take a backup of the reportserver db of that server and keep it?

  • July 29, 2015 at 10:37 pm

    #1815998

    Duplicate post - please direct all answers here.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • July 29, 2015 at 11:43 pm

    #1816004

    I have restored the reportserver database along with the encryption keys on my local machine. I see that everything except the subscriptions. Is there any way to restore the subscriptions?

  • July 30, 2015 at 3:29 am

    #1816033

    Resolution Steps :

    -> I verified the report logs and below was the error logged :

    extensionfactory!ReportServer_0-4!20f8!07/30/2015-13:15:03:: e ERROR: Exception caught instantiating Report Server Email report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. .

    library!ReportServer_0-4!20f8!07/30/2015-13:15:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Email Provider has no server or pickup directory specified, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

    ->I have updated the <SMTPServerPickupDirectory> parameter in the rsreportserver config file and it worked.

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

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