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

• sram24_mca

  SSCrazy

  Points: 2633

  More actions

  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

• Ant-Green

  SSC Guru

  Points: 113536

  More actions

  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?

• sram24_mca

  SSCrazy

  Points: 2633

  More actions

  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

• Ant-Green

  SSC Guru

  Points: 113536

  More actions

  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.

• sram24_mca

  SSCrazy

  Points: 2633

  More actions

  January 4, 2013 at 9:16 am

  #1573815

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