SQL MP 09.0.2047.0000 Reports fail

  • Article

You may have noticed that when you import the latest SQL MP (09.0.2047.0000) Reports .XML file from MS downloads page to your MOM reporting server, the reports when executed might fail with:

"The report server cannot process the report. The data source connection information has been deleted."

This could be some problem with this MP, I'm still investigating that. To workaround it you need to manually create the data source called SCDW with the connection string "data source = .; initial catalog = SystemCenterReporting" (provided you are running on the default instance, otherwise use .\InstanceName). Then for every report you need to change the Data source to use the new one either through GUI or re-import the reports with rptutil pointing to the right data source.