Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Project Server OLAP Cube

Posted on 2008-06-10
Last Modified: 2013-11-15
I want to process an create an OLAP for Project Server. The problem is that by default Project Server installed on SQL Server Express, but for the OLAP Cube i want to use another server with Analysis Services. How should I configure it, and how should I configure the OLAP Cube in Project Server?
Question by:iulianchira
  • 3
  • 2
LVL 13

Expert Comment

ID: 21756211
Hello iulianchira,

I haven't tried it, but I can't think of any reason it shouldn't work.

You will definitely need to install the DSO 9.0 components on the project server (and possibly on the SQL server if they are not already installed).  The following article should lead you through this:


After this is done log into your PWA site, select Server Settings, select Cube Build Settings and fill in the name of your SQL Server and the database name you want to create.  Then start the cube build.

Bob Segrest, PMP
Microsoft Project Blackbelt

Author Comment

ID: 21757895
I was actually following the steps described in this guide http://technet.microsoft.com/en-us/library/cc197552(TechNet.10).aspx. My problem is adding the SSP account to the to the OLAP users local group. The SSP service runs on NT Authority\Network Service which of course is not available on the machine running SQL Server Analysis Services.
I would like some guidance on how to proceed to change the SSP user account and add it to the OLAP Cube users group?
LVL 13

Expert Comment

ID: 21758404
Hello iulianchira,

I apologize for my oversight.  Your current configuration will not work because there is no way for your SQL server to authenticate a local account on your project server.  No authentication, no trust, no work.  This is one of many reasons why you should not use the Basic project server installation option.

You can rebuild your Project Server and avoid this problem.

  First install Windows Server 2003, enable IIS and apply all of the updates.
  Then install Windows SharePoint Services (It is free with Windows Server).
  Then install Project Server; this time select the advanced rather than basic option
    and specify your database server when configuring PWA.

This should resolve several problems with the Basic installation.  

First, installing the WSS kit should install the Embedded version of SQL rather than the Express version.  A key difference being that your database doesn't die when you try to exceed 4 GB.  (For most people this is really a ticking time bomb.)  I think it may also be possible to simply use your SQL server instead.

Second, you will be able to specify which account is used to manage the Project Server and which is used to connect to your SQL database system.  You must use a domain account.  The account does NOT need any special domain priveledges, but it will need administrative privileges on the project server and to the SQL database.

The following page describes the installation process:


What you need is a "2-Tier" or "small farm" deployment.

Bob Segrest, PMP
Microsoft Project Blackbelt
LVL 13

Accepted Solution

bobsegrest earned 500 total points
ID: 21761080
Hello iulianchira,

I had some time so I tried a few things in my lab this morning and I am afraid the results were not very encouraging.  The WSS approach that I outlined in my previous entry isn't going to get you where you want to be.  The problem is that WSS is a single server only resource and you can not create a two server farm.

If you install WSS on a machine that is already running SQL Server Standard, it will use the existing SQL Server.  You should then be able to install Project Server and use analysis services on the local machine.  For lab work this is fine.  My experience has been that any organization that purchases a SQL server license is probably going to prohibit the installation of other services on the same machine.

What it boils down to is that you really need to deploy a proper SharePoint farm with Microsoft Office SharePoint Services.  Then install Project Server on this machine and use your existing SQL Server for database services.

Bob Segrest, PMP
Microsoft Project Blackbelt

Author Comment

ID: 21792658
You are right. The only way i was able to get the cube to build was by installing in a farm configuration and explicitly specifying the database server.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question