Error while creating Data Analysis OLAP cubes

[Huckey]

Hi all,
I have been trying to build OLAP cubes for Data Analysis on my MS
Project Server 2007. I can not get them to be built; the job ends with
the following error message: "Analysis Services session failed with
the following error: Failed to connect to the Analysis Services server
TestServer\OfficeServers. Error: Your permissions on the server
computer do not allow you to administer this Analysis server."

Shared Services are set up to be using NT AUTHORITY\NETWORK SERVICE
user. This user account seems to have all possible authorizations on
the server machine (WSS and SQL Server are running on the same
machine).

I have the following questions:
1. Does the error message relate to the Shared Services user or does
it relate to the user who creates the job?

2. What authorization settings are needed for NETWORK SERVICE in order
to get the cubes built?

3. I have tried changing the user used by Shared Services to a domain
user name but then I got "Unexpected error" when trying to access PWA.
I found out on some website that one should execute stsadm with
options to update user change to all services but that didn't help
much. If it should be easier to get a domain user to build the cubes
compared with NETWORK SERVICE, how should I change the settings for
user account used by Shared Services to get it working?

4. In your environments how do you have the Windows services
corresponding to WSS and SQL set up: are they logged on as Local
account, NETWORK SERVICE or a domain user?

Thanks!

Best regards

Jacek

 

[Huckey]

Hi again,
I have managed to solve the problem

Below I describe the steps I took - maybe it helps someone.

1. Change the settings for Shared Services log. Change the settings
according to the description at
http://www.epmfaq.com/ssanderlin/qu...-allow-you-to-administer-this-analysis-server.

2. Having gone through the logs I discovered that the error message
was related to the domain user who was executing the cube building job
0 then I knew I wouldn't have to bother about NETWORK SERVICE
permissions.

3. I already did play with the settings in MS SQL, so I do not know
which settings are necessary but make sure this domain user you use
has access to Analysis Services Repository database. In my case, even
though I thought these permissions should be somehow available through
the group, I explicitely added dbo permissions for this database to
the domain user. Of course, the user you use has to be added to the
list in Security for your Analysis Services in SQL Server Management
Studio.

4. Make sure the domain user you use has Full Control rights to
MSOLAPREPOSITORY$ share on the server. In my case I was pretty sure I
set it up but when I looked again, these permissions were gone so I
set them up again.

Hope that helps someone.

Best regards

Jacek