OLAP Error

S

ss028955

I am trying build cube name: ProjectServer_Cube via cube build interface on
Project Server 2007. I received the error below. I logged in as mproject user
and our DBA has given full access to the database.

Can someone help please.
Regards
SS028955

Error:
===== Process Completed =====
[16/01/2008 2:07 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to delete the Olap
database: ProjectServer_Cube. Error: Your permissions on the server computer
do not allow you to administer this Analysis server.

Error:
 
S

ss028955

It is now working. I went through the other OLAP issue mentioned on this
forum site and deleted Custom fields from Cube build configuration then
re-run with the different cube name. It worked fine.
Thanks to all .
 
S

ss028955

I thought it is successfull, But the schedule update has falied. However when
i run it mannually via build cube, it complets successfully.

Any advice?

Regards
SS028955

ss028955 said:
It is now working. I went through the other OLAP issue mentioned on this
forum site and deleted Custom fields from Cube build configuration then
re-run with the different cube name. It worked fine.
Thanks to all .

ss028955 said:
I am trying build cube name: ProjectServer_Cube via cube build interface on
Project Server 2007. I received the error below. I logged in as mproject user
and our DBA has given full access to the database.

Can someone help please.
Regards
SS028955

Error:
===== Process Completed =====
[16/01/2008 2:07 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to delete the Olap
database: ProjectServer_Cube. Error: Your permissions on the server computer
do not allow you to administer this Analysis server.

Error:
Click to expand...
Click to expand...
 
G

Gary L. Chefetz [MVP]

ss:

You should recheck the database and system permissions for the SSP account.
There's probably something missing there. What error do you get on the
automated build?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


ss028955 said:
I thought it is successfull, But the schedule update has falied. However
when
i run it mannually via build cube, it complets successfully.

Any advice?

Regards
SS028955

ss028955 said:
It is now working. I went through the other OLAP issue mentioned on this
forum site and deleted Custom fields from Cube build configuration then
re-run with the different cube name. It worked fine.
Thanks to all .

ss028955 said:
I am trying build cube name: ProjectServer_Cube via cube build
interface on
Project Server 2007. I received the error below. I logged in as
mproject user
and our DBA has given full access to the database.

Can someone help please.
Regards
SS028955

Error:
===== Process Completed =====
[16/01/2008 2:07 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to delete the
Olap
database: ProjectServer_Cube. Error: Your permissions on the server
computer
do not allow you to administer this Analysis server.

Error:
Click to expand...
Click to expand...
Click to expand...
 
S

ss028955

Same Error. This is driving me crazy
:
===== Process Completed =====
[1/02/2008 6:01 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to delete the Olap database:
ProjectServer_Cube. Error: Your permissions on the server computer do not
allow you to administer this Analysis server.


ss028955 said:
It is now working. I went through the other OLAP issue mentioned on this
forum site and deleted Custom fields from Cube build configuration then
re-run with the different cube name. It worked fine.
Thanks to all .

ss028955 said:
I am trying build cube name: ProjectServer_Cube via cube build interface on
Project Server 2007. I received the error below. I logged in as mproject user
and our DBA has given full access to the database.

Can someone help please.
Regards
SS028955

Error:
===== Process Completed =====
[16/01/2008 2:07 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to delete the Olap
database: ProjectServer_Cube. Error: Your permissions on the server computer
do not allow you to administer this Analysis server.

Error:
Click to expand...
Click to expand...
 
J

James Fraser

Same Error. This is driving me crazy
:
===== Process Completed =====
[1/02/2008 6:01 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to delete the Olap database:
ProjectServer_Cube. Error: Your permissions on the server computer do not
allow you to administer this Analysis server.
Click to expand...

Gary has good advice: Check the permissions closely. Particularly make
sure the SSP account is listed in the Security section of the Analysis
Services Properties page. Let us know if you need help finding that.


James Fraser
 
G

Gary L. Chefetz [MVP]

SS:

If you have our book, "Implementing and Administering..."follow through all
the steps in module 5. If not, follow all of the steps in the technet
article that applies to your system below to verify the permissions:

http://technet2.microsoft.com/Offic...67e1-4e5b-9119-62f7ff6b83861033.mspx?mfr=true


--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


ss028955 said:
Same Error. This is driving me crazy
:
===== Process Completed =====
[1/02/2008 6:01 PM] Failed to build the OLAP cubes. Error: Analysis
Services
session failed with the following error: Failed to delete the Olap
database:
ProjectServer_Cube. Error: Your permissions on the server computer do not
allow you to administer this Analysis server.


ss028955 said:
It is now working. I went through the other OLAP issue mentioned on this
forum site and deleted Custom fields from Cube build configuration then
re-run with the different cube name. It worked fine.
Thanks to all .

ss028955 said:
I am trying build cube name: ProjectServer_Cube via cube build
interface on
Project Server 2007. I received the error below. I logged in as
mproject user
and our DBA has given full access to the database.

Can someone help please.
Regards
SS028955

Error:
===== Process Completed =====
[16/01/2008 2:07 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to delete the
Olap
database: ProjectServer_Cube. Error: Your permissions on the server
computer
do not allow you to administer this Analysis server.

Error:
Click to expand...
Click to expand...
Click to expand...
 
S

ss028955

Thanks Gary and James. It is now working. Went through the link Gary
provided. And figured out that it was to do with the step below.

Granting the OLAP Administrators group permissions to the SQL Server 2000
Analysis Services components
The OLAP Administrators group needs to have permissions to all SQL Server
2000 Analysis Services components. You may need to explicitly grant the OLAP
Administrators group full control on the \bin subdirectory of the
Installation directory for SQL Services 2000 Analysis Services. The default
location of this directory is:
C:\Program Files\Microsoft Analysis Services\Bin

Regards
Sovana


Gary L. Chefetz said:
SS:

If you have our book, "Implementing and Administering..."follow through all
the steps in module 5. If not, follow all of the steps in the technet
article that applies to your system below to verify the permissions:

http://technet2.microsoft.com/Offic...67e1-4e5b-9119-62f7ff6b83861033.mspx?mfr=true


--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


ss028955 said:
Same Error. This is driving me crazy
:
===== Process Completed =====
[1/02/2008 6:01 PM] Failed to build the OLAP cubes. Error: Analysis
Services
session failed with the following error: Failed to delete the Olap
database:
ProjectServer_Cube. Error: Your permissions on the server computer do not
allow you to administer this Analysis server.


ss028955 said:
It is now working. I went through the other OLAP issue mentioned on this
forum site and deleted Custom fields from Cube build configuration then
re-run with the different cube name. It worked fine.
Thanks to all .

:

I am trying build cube name: ProjectServer_Cube via cube build
interface on
Project Server 2007. I received the error below. I logged in as
mproject user
and our DBA has given full access to the database.

Can someone help please.
Regards
SS028955

Error:
===== Process Completed =====
[16/01/2008 2:07 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to delete the
Olap
database: ProjectServer_Cube. Error: Your permissions on the server
computer
do not allow you to administer this Analysis server.

Error:
Click to expand...
Click to expand...
Click to expand...
 
Top