Errors when setting up Cube from Project Server 2007 in Analysis Server

We try to setup a cube from Project Server in our (seperated) Analysis Server.

Even though following all the instructions which can be found and equally we setup the repository in the SQL 2005 Server or use the .mdb, we run into the following errors:

[26.07.2007 12:19 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server SERVER. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
Error:
===== Process Completed =====
[26.07.2007 12:19 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server SERVER. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

The Project Server Queue Service user is a) SQL sysadmin and b) SQL Server Admin group member - at least it became this after everything else didn't work out..

The correct shares etc. on filebase are given, even it is checked that the Queue Account can connect to the share from another computer, ...

So now I wonder whether someone else had this issue and can help out here?

Thanks in advance.

Hello! In order to set up an SSAS2005 cube you will need to have administrators permissions on SSAS2005.

I assume that SSAS2005 and SQL Server 2005 run on the same server.

Connect to SSAS2005 with Management Studio and right click on the server. Choose properties and the security tab(server wide security privileges) and the add the user who shoul have rights to deploy and process the cube.

HTH

Thomas Ivarsson

|||

I am having similar problems.

I have added the shared service provider to AS box. I restarted AS and I am still gettting the same error.

Any help would be greatly appreciated....

Here is the event log:

"Standard InformationSI Entry Point:
Project User: <domain\server name>
Correlation Id: 4f990c61-13e6-49b3-949e-2867e681c38b
PWA Site URL: <server name>
SSP Name: SharedServices1
PSError: CBSASConnectionFailure (17003)
Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=<IP Address> ASDBName=OLAPCUBE ASExtraNetAddress=<IP Address> RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=08/01/2007 12:11:58 ToDate=08/01/2007 12:11:58 HighPriority=True

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

"