Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are planning to do Sharepoint and project server 2007 databases migration.

The share point website also processes cubes.

So we will be moving SSAS cubes from SQL 2005 to 2008 and then re-pointing the location from the sharepoint admin website.

The following document covers “Requirements for using SQL Server 2008 Analysis Services with the Project Server 2007 Cube Building Service”

the document is easy to follow but there is a section which mentions:

“You need to configure the Analysis Services DSO properties so that the repository database is configured to be used from DSO in SQL Server 2008 Analysis Services. Changes made during this process will be reflected in the Analysis Services configuration file (Msmdsrv.ini).” So this involves playing with DSO* properties under the SSAS server.

enter image description here

The existing SSAS server has only sharepoint cubes but the new SSAS server has cubes for other applications too.

I can do the settings following this document but I want to know if there are any risks involved in changing DSO properties on SSAS server.

Can anyone please help or put me in right direction?

share|improve this question
up vote 2 down vote accepted

Answered by An Expert friend:

It wont effect other cubes. DSO component will only be used when a user runs DSO 8.0 application and will have no impact on SQL Server 2008 Analysis Services database.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.