Multiple cubes for EditSite instances

[Nate]

Hello:

I am trying to build additional cubes for our other EditSite instances. The
primary site builds the default cube correctly. Any other EditSite site will
also build that cube successfully. I have copied the default cubes to another
database in analysis Services, checked the database connections (making sure
they are pointed at the db associated with the other instance), and the other
cubes fail to build.

We are running a front-end server, a machine for views processing and
session management, and one sql server.

Am I missing something basic in my config steps?

Thanks for your help,
Nate

 

[Gary L. Chefetz [MVP]]

Nate:

Your OLAP Admin account must have access to all of instance databases the
same way it has access to the first one. Does that help? It would help us if
you'd post your exact error messages displayed on the cube build page and
the Server Application Event Log.