Thursday, April 03, 2008

Cannot create a connection to data source 'TfsOlapReportDS'. (rsErrorOpeningConnection)

If you ever see an error like below when trying to render a Report in TFS, make sure MS SQL Analysis Services is started under Control Panel > Services. Since we're running a duel server install, our MS SQL Analysis Service is running (or not running when we get this error) on the Data Tier.

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'TfsOlapReportDS'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

2 comments:

Ashwin said...

Analysis service is running what to do now?

Mac Noland said...

This is probably not very helpful, but can you make sure the accounts and passwords are correct?