Dropping datasources

• Raul Undreiner

  SSCommitted

  Points: 1554

  More actions

  January 8, 2016 at 7:31 am

  #314843

  Hello all,

  We have been having a problem that we have not been able to identify the cause. Our reports have been dropping the datasources sporadically and when there is a subscription then that too. It does not happen to all reports and it happens for a few days and then it gets fixed by itself. We think that it has something to do with the synchronization between SharePoint and SSRS but not sure. Unfortunately we do not have an expert on either one so we have been just re-linking the reports to their datasource manually (daily for some reports). Fortunately there is only about 20-30 reports with this problem out of 600+ but some of them have subscriptions that take more effort to re-create and it is a pain having to do it everyday.

  We have sharepoint 2010 with SSRS 2008 R2 on Integrated mode.

  Thanks in advance for any help.