Cascade Skyline - with Microsoft Logo and Project Support header - author Brian Smith

Project Server 2007: Analysis Services issues when using Reporting Services Add-in for SharePoint

Project Server 2007: Analysis Services issues when using Reporting Services Add-in for SharePoint

  • Comments 1

My friend Carl posted this as a comment to one of the longer threads on Analysis Services and Project Server with the ActiveX Component Can't Create Object. error  – but thought it worthy of top billing and a fresh post, as I know others have struggled with this one.  Your mileage may vary and I know there are plenty of permutations of versions that might still catch you out – but over to Carl;

So we resolved our particular issue of installing EPM & configuring CBS into an existing MOSS 2007 / SQL2008 / RS2008 environment where the SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies (correction) Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies is installed....

Installed SQL 2005 components from December 2008 feature pack on app server

  • Native client
  • Backwards compatibility

* note: Management Objects not installed due to SQL 2008 reporting services add-in for SharePoint wouldn’t let it (Higher version already installed)

Then we installed these bits on app server to get things working

  • SQL 2008 native client (needed as we got the issue "Cannot connect to Repository" when we only had the 2005 native client installed)
  • XMO 2005 cu5 - to get around the previous issue noted re RS Add-in (BriSmith – I think this is the link - http://support.microsoft.com/kb/972511/en-us, but Carl can correct me)

... we went around the houses a few times to get to this end point.  Hope it helps someone else :)

http://carldalton.tumblr.com/

Technorati Tags:
Leave a Comment
  • Please add 1 and 4 and type the answer here:
  • Post
  • Thanks a lot for this post! After 5 hours googling I found it and will try installing XMO 2005 cu5 soon to have coexisting Project Server 2007, SQL 2008 reporting add-in for Sharepoint and SS Analisys services 2008.

Page 1 of 1 (1 items)