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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Administration » Error in Reporting Services - Event Error...

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

Rate Topic

Display Mode

Topic Options

Author

Message

sram24_mca

Posted Friday, January 04, 2013 5:46 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 17, 2013 3:01 AM
Points: 83, Visits: 320

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

Post #1402826

anthony.green

Posted Friday, January 04, 2013 6:04 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1402833

sram24_mca

Posted Friday, January 04, 2013 6:44 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 17, 2013 3:01 AM
Points: 83, Visits: 320

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

Post #1402851

anthony.green

Posted Friday, January 04, 2013 7:48 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1402884

sram24_mca

Posted Friday, January 04, 2013 9:16 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 17, 2013 3:01 AM
Points: 83, Visits: 320

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

Post #1402951

« Prev Topic | Next Topic »

Permissions