OLAP build error in PS 2007

N

Nach

Hi, I'm trying building an OLAP cube using SQL Server 2005 Analysis server. I
have folled the reuirements for building OLAP cube" from MSDN. But I'm not
sure why am getting this error.

-----------
===== Process Completed =====
[3/27/2008 1:04 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
 
J

Jimbo4Prez

Hi, I'm trying building an OLAP cube using SQL Server 2005 Analysis server.. I
have folled the reuirements for building OLAP cube" from MSDN. But I'm not
sure why am getting this error.

-----------
===== Process Completed =====
[3/27/2008 1:04 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
-------------------

I have given the SSP account permission to the analysis server, added it to
the OLAP administrator group and gave it a data reader permission to the
repository and reporting database.

http://forums.epmfaq.com/epmfaq-blo...dministrator-account-during-provisioning.html
I had this issue too and it was resolved by adding the SSP account to
the Administrators group within Project Server.
 
N

Nach

Hi People,

I founf the solution by digging deep into Google. Somebody has said that we
have to create DSO9 fodler and share it. I thought it was to be done only
when using SQL 2000 or something...it wasn't explicitly mentioned in the
requirements doc at MSDN. So I did that and included that in the Properties
of Analysis Server...and it's building now!

Here's the link to the page that helped me :

http://netsleeper.spaces.live.com/Blog/cns!2D6B305EBBD50AA5!190.entry

Thanks
Nach


Jimbo4Prez said:
Hi, I'm trying building an OLAP cube using SQL Server 2005 Analysis server.. I
have folled the reuirements for building OLAP cube" from MSDN. But I'm not
sure why am getting this error.

-----------
===== Process Completed =====
[3/27/2008 1:04 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
-------------------

I have given the SSP account permission to the analysis server, added it to
the OLAP administrator group and gave it a data reader permission to the
repository and reporting database.

http://forums.epmfaq.com/epmfaq-blo...dministrator-account-during-provisioning.html
I had this issue too and it was resolved by adding the SSP account to
the Administrators group within Project Server.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top