No Cube Built on Installation

G

Gary Mitchell

I have done a Single Server Install on Windows Server 2003 (local accounts,
not AD) more than 10 times. I followed the Microsoft Single Server
Installation Guide relentlessly. Every time I have installed, everything work
BUT NOT CUBE IS BUILT. Is this a known error? Is there a way to build a cube
by hand and have the installation recoginze it? Surely this must work some
how, some where. I would really appreciate any help resolving this problem.

Thanks in advance.
 
J

JP Hindley

After 3 days of hard work running SP3a for SQL Server 2000 in debug mode to
prevent errors, we finally got all of our services up and running today. Just
in case it is any help with your issue we:
- installed sp3a first
- installed analysis services
- installed sp3 for analysis services (available from msdn because sp2 says
it isn't Server 2003 compatible)
- used pscomplus in the 1033\Bin folder to configure access - needs an admin
windows account in format domain\username and the password
- migrated the repository to the projectserver database using analysis manager
- added the windows account from before as a database owner on the
projectserver database
- added the windows account and my own windows account to the OLAP
Administrators group in local security
- specified the analysis server name (usually the servername) in the "manage
enterprise features" in web access, selected the "Yes.....and build a cube"
option and clicked "Update Now" which built our cube for us.

Hope this resolves your issue, I shall keep an eye on here just in case...
 
Top