Post reply

Error in Reporting Services - Event Error 107:"Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database."

  • January 4, 2013 at 5:46 am

    #272507

    Hi,

    We are getting error - "Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database." while retrieving the data from the particular database. Can anyone tell us why this problem arise ?

    Regards,

    Ram

  • January 4, 2013 at 6:04 am

    #1573712

    Has anything changed recently?

    Report server migration

    Database server migration

    Encryption keys been restored

    Can you run through the SSRS config tool to ensure it is set up as it should be?

  • January 4, 2013 at 6:44 am

    #1573727

    We first cleaned up the transaction logs - 20 days back and restored the encryption keys recently - 2 days before.

    Regards,

    Ram

  • January 4, 2013 at 7:48 am

    #1573757

    Restoring the encryption keys will have probably caused it as the keys are out of sync.

    Two ways to go it, find the correct encryption key file or delete all encrypted content and then resetup all your data sources and subscriptions.

  • January 4, 2013 at 9:16 am

    #1573815

    Thanks for your help! Is there any other cause for this problem?

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

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