Cannot create a connection to data source 'TfsOlapReportDS'

Question

When I open my project dashboard on my TFS project portal web page, I get the following error.

Reporting Services Error

Cannot create a connection to data source 'TfsOlapReportDS'. (rsErrorOpeningConnection) A connection cannot be made. Ensure that the server is running. No connection could be made because the target machine actively refused it

SQL Server Reporting Services

What can I do to resolve this error?

Answer 1

I had checked that SQL Server Analysis Services was running in

Control Panel → Administrative Tools → Services

The service was running. The solution to this was that I needed to go into

Start → Programs → Microsoft SQL Server 2008 R2 → SQL Server Configuration Manager → SQL Server Services.

That instance of SQL Server Analysis Services wasn't Running. I started it, and this prevented the error message above.