Tuesday, June 09, 2009

Configurating Data-Analysis in Project Server 2007 with SQL Server 2008

Configurating Data-Analysis in Project Server 2007 with SQL Server 2008

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$$MSSQLSERVER. You must add the SSP account to this group.


Everything else in the KB should be good to follow.

No comments: