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.

Advertisements

~ by alipka on December 7, 2006.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: