Cant build OLAP cube in prod 07

[Brian B]

I have got a real head scratcher, I have built out a test server, and built
the cube with no problems, I followed the same procedures, which does include
putting the ssp admin in the olap group, and I keep get an error after it
creates the DB, while it is processing the OLAP db. it says
Cube build failed during an OLAP Processing operation Error: OLE DB error:
OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

again I have the exact setup in test and it buids fine, that is why I am so
frustrated.

Thanks for your help.

 

[Manmeet Chaudhari]

Hi Brian
You can try the steps given in the following site
http://www.pptspaces.com/msprojectreporterblog/Lists/Posts/Post.aspx?ID=25

I tried it and it works for me.

Thanks,

Manmeet Chaudhari
EPM Consultant

 

[Brian B]

Manmeet, yes I have tried this, I aslo have tried the other method of
creating th database, and instead of using the jet db, I use the native
client. I believe I have stumbled onto my fix though, I used an alias on my
db server, and I believe that to be causing my issue, but still working it.

Thanks