It is important to understand that the following Microsoft KB Guidance for configuring Data-Analysis needs some important additions and considerations:
http://technet.microsoft.com/en-us/library/dd285466.aspx
First lets look at the following requirements:
"The way to install the DSO library is to get a set of redistributable packages included in the SQL Server 2005 Feature Pack. That set consists of:
Microsoft SQL Server Native Client
Microsoft SQL Server 2005 Management Objects Collection
Microsoft SQL Server 2005 Backward Compatibility Components"
It is important to install the Microsoft SQL Server Native Client for SQL Server 2008. This is due to the "Provider" that we use in the setup of Analysis Services.
The remaining components need to be from the 2005 Feature Pack.
Also, keep in mind that the OLAPUsers Group that we knew in 2005 is now called:
SQLServerMSASUser$
This is important when referencing the following step:
Add the SSP account to the OLAP users group
When you install SQL Server 2008 Analysis Services, a local group is created on the server that allows users to access it. This group is named SQLServerMSASUser$
Everything else in the KB should be good to follow.
