Note: Below migration case is Old SharePoint 2010 Farm to New SharePoint 2010 Farm.
- After deploying and Integrating SQL Server Reporting Services 2012 with SharePoint 2010
- Make safe control entries as per this link. http://social.msdn.microsoft.com/Forums/sqlserver/en-US/90db82a2-3eef-469b-8dce-ca148820a75c/sqlserver-2012-upgrade-breaks-ssrs-reportviewerwebpart?forum=sqlreportingservices This is to support reports built and deployed in previous version of SSRS i.e. SQL Server Reporting Services 2008
- Switch on Enable Remote Error options in Service Application as well as in Site Settings. This will show under lying error message while running reports. Further debugging is possible this way. http://msdn.microsoft.com/en-us/library/aa337165.aspx
- After Farm migration, use the following steps to re-configure reports
- Change Data Connection Settings, enter new database settings, user name, password and enable it by checking Availability check box at the bottom.
- After migrating reports and their datasets to new Farm, the link between shared data source and report is broken(reason unknown yet). This needs correcting manually by going in each report and changing data source settings as per screen below.
No comments:
Post a Comment