Project Server Reporting Database Not Creating
while creating a test environment, I found that Project Server 2007 was giving me a difficult time, with errors that were not altogether very helpful, at least for my limited experience of Analysis Services and Cube Building.
Such things as:
Error: Cannot connect to the repository.
No process is on the other end of the pipe.
Frustratingly, none of the above links helped solve my problem (though they are informational). What seemed to me to just need to create the Repository database after setting up the DSO information, was more than that. I needed to created the olapobjects table with the correct schema. That’s where this MS article comes to the rescue. after creating the necessary table structure here for my SQL 2005 Repository db, my cubes now successfully build.
