Cube Build error

[Paul]

I am certain I have the correct pemissions and have followed the latest build
guides but come up with this error, Any suggestions appreciated Thanks in
advance Paul

===== Initiating cube build process =====
[29/08/2007 6:43 PM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[29/08/2007 6:43 PM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[29/08/2007 6:43 PM] Cube build initialization started
[29/08/2007 6:43 PM] OLAP database and cube structure was determined
successfully
[29/08/2007 6:43 PM] Failed to create the internal OLAP database structure.
Error: The SELECT permission was denied on the object
'MSP_TimeByDay_OlapView', database 'ProjectServer_Reporting', schema 'dbo'.
===== Process Completed =====
[29/08/2007 6:43 PM] Failed to build the OLAP cubes. Error: Failed to create
the internal OLAP database structure. Error: The SELECT permission was denied
on the object 'MSP_TimeByDay_OlapView', database 'ProjectServer_Reporting',
schema 'dbo'.

 

[Gary L. Chefetz [MVP]]

Paul:

I can tell that you're using 2007 from the error message, but I can't tell
which version of SQL server you're using. Clearly, this is a permissions
problem. It either has to do with permissions on the SSP account or the SQL
Service account. You need to review all of the steps listed here:
http://technet2.microsoft.com/Offic...67e1-4e5b-9119-62f7ff6b83861033.mspx?mfr=true

Alternately, you can painstakingly document the steps you took in your next
post so that we might be able to figure out where in the process you took a
wrong turn. Make sure that you sepcify the SQL version.

--

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