SQL MP 09.0.2047.0000 Reports fail

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.

Comments

• Anonymous
  December 07, 2006
  I don't have this problem but I have seen this before. Most on sql 2000 and if i imported it on sql 2005 sp1 then there is no problem.

• Anonymous
  December 08, 2006
  Hi Robert, I had this problem on SQL 2005 SP1 test lab, and a colleague of mine had it on SQL 2000 SP4, so I assumed this is a general issue. Are you sure you are running that latest MP (9.0.2047.0)? If yes, then that means that this problem happens only sometimes (interesting would be to find out when).

• Anonymous
  December 11, 2006
  The comment has been removed

• Anonymous
  December 11, 2006
  I resolved it manually since the SQL MP had only a few reports. You I think you can just as well use rptutil with this switch: /fromdsref: Name of the "from" datasource reference to fixup.             Valid only when action=import             (Default=SCDW) To point the reports to a new, correct SCDW data source.