InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 00:26:05 GMT20http://www.sqlservercentral.com/Forums/Topic1402826-162-1.aspxThanks for your help! Is there any other cause for this problem?Fri, 04 Jan 2013 09:16:23 GMTsram24_mcahttp://www.sqlservercentral.com/Forums/Topic1402826-162-1.aspxRestoring 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.Fri, 04 Jan 2013 07:48:03 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1402826-162-1.aspxWe first cleaned up the transaction logs - 20 days back and restored the encryption keys recently - 2 days before.Regards,RamFri, 04 Jan 2013 06:44:40 GMTsram24_mcahttp://www.sqlservercentral.com/Forums/Topic1402826-162-1.aspxHas anything changed recently?Report server migrationDatabase server migrationEncryption keys been restoredCan you run through the SSRS config tool to ensure it is set up as it should be?Fri, 04 Jan 2013 06:04:15 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1402826-162-1.aspxHi, 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,RamFri, 04 Jan 2013 05:46:19 GMTsram24_mca