Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007

    Unanswered: SSRS 2005 connecting to AS2000 issue

    Sorry if this is old problem, newbie to these forums.

    I have SSRS 2005 trying to connect to cube on AS2000. Getting an error of
    "Unable to recognize the requested property ID 'ReturnCellProperties'".
    Did google a little and tried a suggested workaround of adding ConnectTo=8.0
    to the datasource with no resolution.
    1. Has anyone been able to get it to work ?
    2. Would it be possible to have SSRS2005 connect to SSAS2005 while the cube points to the tables on sql server 2000 ?

    All servers/software are at the latest SP levels including hotfixes.
    (windows 2003 servers sp1, sql200 sp4, sql2005 sp2 + hotfix)
    Any help or suggestions are appreciated.


  2. #2
    Join Date
    Mar 2007


    With Microsoft's help the issue is resolved.

    Must change connection type to 'OLEDB'
    and add 'Provider=MSOLAP.3' to the datasource within ReportingServices.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts