Monday, 2 December 2013

SharePoint 2010 SSRS Reports in SQL 2012, Migration Case

If your company migrated from SQL Server Reporting Services 2008 to SQL Server Reporting Services 2012 then reports migration will require additional steps of configuration in order to run reports built in previous version successfully.

Note:  Below migration case is Old SharePoint 2010 Farm to New SharePoint 2010 Farm.
  1. After deploying and Integrating SQL Server Reporting Services 2012 with SharePoint 2010
    1. 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
    2.  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 
  2. After Farm migration, use the following steps to re-configure reports
    1. Change Data Connection Settings, enter new database settings, user name, password and enable it by checking Availability check box at the bottom.
    2.  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.
Hope this will help!


No comments:

Iconise ‘Add Picture’ control in PowerApps

Default look you get for ‘Add Picture’ control is not very appealing for end user and there is no OTB way of specifying icon for this con...