That may seem like a strange title, but for Project Server 2007 users of the Analysis Services features this is good news indeed! Along with the release of SP3 (see Christophe’s blog for more details) is the release of the latest Feature pack for SQL Server 2005. This includes the update to Management Object Collection which enables connectivity from a Project Server 2007 application server to a SQL Server 2008 Analysis Services machine to build cubes. We will get the TechNet article updated at http://technet.microsoft.com/en-us/library/dd285466.aspx but for now I have added some community content. So if you load the Native Client, Decision Support Objects (from the Backward Compatibility Components) and Management Objects Collection from the December Feature pack release all will be good. If your repository is in SQL Server 2008 also, then you may need the SQL Server 2008 Native client too, which can be found here.
I’ll just repeat the error messages from my earlier post – just to give the search engines something to do.
Failed to connect to the Analysis Services server brismithSQL08. Error: Cannot connect to Analysis Services version ‘10.0.1600.22’ (or Analysis Services version ‘10.0.1763.0’ if you have loaded the Cumulative Update 1 for SQL Server 2008)