Project Server technical bits

SQL 2008 analysis services for mops2007 Well we sorted it It’s a bank holiday today but here’s the route we took Installed SQL 2005 components from dec2005 feature pack on app server Native client Bacwards compatibility note: xmo not installed due to SQL 2008 reporting services addon for sharepoint wouldn’t let it Installed the following bits on app server to get things working SQL 2008 native client Xmo 2005 sp 3 cu5 - to get around the previous issue noted KB 972511 Ta daaa everything worked!!! Only took a week :( edit - postback to Brian Smith’s blog http://blogs.msdn.com/b/brismith/archive/2010/06/15/project-server-2007-analysis-services-issues-when-using-reporting-services-add-in-for-sharepoint.aspx

Update: so we are getting the "cannot connect to repository" error. Having rummaged around I have just seen reference to the need for SQL 2008 Native Client install also... gonna check this out next So, i am seriously stuck on something... hopeing to work this through today but thought I would share: Consider.... Server Architecture: Server 1 : DB server SQL 2008 / AS2008 / rS2008 Server 2: App server MOSS2007, Project Server 2007, 2008 Reporting Services addin for SharePoint Server 3: WFE including 2008 RS addin for SharePoint Configuring Server 2 for CBS - install Native Client - OK - Install Management Objects (XMO/AMO) - Failed (higher version aleady availble) - Install BC Cube run fails due with Unable to Create ActiveX component... error http://support.microsoft.com/kb/972694 Ran the hotfix package mentioned for XMO and got the error "unable to connet to analysis services repository" - relates to native client So as we are now in an unknown state I am now r...