question

Ken 1 avatar image
Ken 1 asked

SQL Server 2008 Reporting Services and SQL Server 2000 Analysis Services Error

Hi, I am trying to generate a report in SQL Server 2008 Reporting Services which will get its data from a cube in SQL Server 2000 . It keeps on failing with the following error:

'An error occurred during client rendering. An error has occurred during report processing. Cannot create a connection to data source 'KPIDailyNetSalesCovers_Current'. A connection cannot be made. Ensure that the server is running. No connection could be made because the target machine actively refused it ..*.**:2383

Why do i keep on getting this error? Is it possible that SSRS 2008 cannot access data from a cube built in SQL Server 2000 Analysis Services. Please help advise. Thanks

sql-server-2008ssrssql-server-2000
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.