Cube buiding error - Analysis Services permissions

[rt]

We get the following errors when trying to build the OLAP cubes in
EPM2007. I searched this group and found only one brief message from
September last, with no usable solution. Has this problem been tackled
in more detail in the mean time?

Error Message 1:

Failed to build the OLAP cubes. Error: Analysis Services session
failed with the following error: Failed to connect to the Analysis
Services server DJIGOUAPSPPSSQL. Error: Your permissions on the server
computer do not allow you to administer this Analysis server. Error:


Error Message 2:

===== Initiating cube build process =====
[3/10/2008 2:55 PM] Cube build request message has been added to the
Project Server queue

===== Verifying and running pre-build server event handler =====
[3/10/2008 2:56 PM] Verifying and running pre-build server event
handler

===== Determining database and cube structure =====
[3/10/2008 2:56 PM] Cube build initialization started
[3/10/2008 2:56 PM] OLAP database and cube structure was determined
successfully

===== Building database and cubes =====
[3/10/2008 2:56 PM] Cube build session started
[3/10/2008 2:56 PM] Analysis Services session started
[3/10/2008 2:56 PM] Analysis Services session failed with the
following error: Failed to connect to the Analysis Services server
DJIGOUAPSPPSSQL. Error: Your permissions on the server computer do not
allow you to administer this Analysis server.

Error:

===== Process Completed =====
[3/10/2008 2:57 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to connect to
the Analysis Services server DJIGOUAPSPPSSQL. Error: Your permissions
on the server computer do not allow you to administer this Analysis
server.

Error:

 

[Ben Howard]

Are the AS Services on a different server to the PS2007 application - I
expect so?
Check out this KB http://technet.microsoft.com/en-us/library/cc197552.aspx.
I had a lot of grief with this a couple of weeks ago, but it turned out that
restarting the AS service, followed by the PS Queues worked. also recreated
teh AS repository DB from scratch and reassigned permissions etc.

 

[rt]

Are the AS Services on a different server to the PS2007 application - I
expect so?
Check out this KBhttp://technet.microsoft.com/en-us/library/cc197552.aspx. 
I had a lot of grief with this a couple of weeks ago, but it turned out that
restarting the AS service, followed by the PS Queues worked.  also recreated
teh AS repository DB from scratch and reassigned permissions etc.
--
Thanks,  Ben.http://appleparkltd.spaces.live.com/

We get the following errors when trying to build the OLAP cubes in
EPM2007. I searched this group and found only one brief message from
September last, with no usable solution. Has this problem been tackled
in more detail in the mean time?

Error Message 1:

Failed to build the OLAP cubes. Error: Analysis Services session
failed with the following error: Failed to connect to the Analysis
Services server DJIGOUAPSPPSSQL. Error: Your permissions on the server
computer do not allow you to administer this Analysis server. Error:

Error Message 2:

===== Initiating cube build process =====
[3/10/2008 2:55 PM] Cube build request message has been added to the
Project Server queue

===== Verifying and running pre-build server event handler =====
[3/10/2008 2:56 PM] Verifying and running pre-build server event
handler

===== Determining database and cube structure =====
[3/10/2008 2:56 PM] Cube build initialization started
[3/10/2008 2:56 PM] OLAP database and cube structure was determined
successfully

===== Building database and cubes =====
[3/10/2008 2:56 PM] Cube build session started
[3/10/2008 2:56 PM] Analysis Services session started
[3/10/2008 2:56 PM] Analysis Services session failed with the
following error: Failed to connect to the Analysis Services server
DJIGOUAPSPPSSQL. Error: Your permissions on the server computer do not
allow you to administer this Analysis server.

Error:

===== Process Completed =====
[3/10/2008 2:57 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to connect to
the Analysis Services server DJIGOUAPSPPSSQL. Error: Your permissions
on the server computer do not allow you to administer this Analysis
server.

Error:- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

Thanks, we'll give it a try. I'm not the techie myself (just the
functional consultant) but yes, there's a lot of different locations
and networks involved, as well as a Citrix environment.

 

[rt]

Are the AS Services on a different server to the PS2007 application - I
expect so?
Check out this KBhttp://technet.microsoft.com/en-us/library/cc197552.aspx.  
I had a lot of grief with this a couple of weeks ago, but it turned out that
restarting the AS service, followed by the PS Queues worked.  also recreated
teh AS repository DB from scratch and reassigned permissions etc.

We get the following errors when trying to build the OLAP cubes in
EPM2007. I searched this group and found only one brief message from
September last, with no usable solution. Has this problem been tackled
in more detail in the mean time?
Error Message 1:
Failed to build the OLAP cubes. Error: Analysis Services session
failed with the following error: Failed to connect to the Analysis
Services server DJIGOUAPSPPSSQL. Error: Your permissions on the server
computer do not allow you to administer this Analysis server. Error:
Error Message 2:
===== Initiating cube build process =====
[3/10/2008 2:55 PM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[3/10/2008 2:56 PM] Verifying and running pre-build server event
handler
===== Determining database and cube structure =====
[3/10/2008 2:56 PM] Cube build initialization started
[3/10/2008 2:56 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[3/10/2008 2:56 PM] Cube build session started
[3/10/2008 2:56 PM] Analysis Services session started
[3/10/2008 2:56 PM] Analysis Services session failed with the
following error: Failed to connect to the Analysis Services server
DJIGOUAPSPPSSQL. Error: Your permissions on the server computer do not
allow you to administer this Analysis server.
Error:
===== Process Completed =====
[3/10/2008 2:57 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to connect to
the Analysis Services server DJIGOUAPSPPSSQL. Error: Your permissions
on the server computer do not allow you to administer this Analysis
server.
Error:- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

Thanks, we'll give it a try. I'm not the techie myself (just the
functional consultant) but yes, there's a lot of different locations
and networks involved, as well as a Citrix environment.- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

Well, we've found the error and it's pretty lame. When configuring the
SQL Analysis Services to enable repository use, you have to enter an
SQL query as explained on p. 191 of Dale and Gary's book (Implementing
and administering...). Turns out this code is case sensitive and we
wrote [olapObjects] instead of [OlapObjects] on line 1.

Hope this helps somebody in the future.