Project Server Help, FAQs, Blogs, and HowTos
This is The Header Then

Cube Build Failure: Your permissions on the server computer do not allow you to administer this Analysis server

posted December 22nd, 2007 by Stephen Sanderlin
1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 3.5 out of 5)
Loading ... Loading ...

When building a cube for the first time,  a deployer will sometimes see an error similar to the following error message in the Cube Status screen:

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to delete the Olap database: PWA_AnalysisServices. Error: Your permissions on the server computer do not allow you to administer this Analysis server. Error:

Typically, this error is caused by failing to correctly or completely follow the directions outlined in this article on configuring Analysis Services 2005 to work with Project Server 2007. It can also caused by not restarting Analysis Services after you give the SSP account administrative permissions to Analysis Services — this does not appear in the aforementioned article, but it is sometimes required.

However, you may see this error message even though you have done everything correctly. Since this error indicates a permissions problem, the easiest way to test is to run SQL Server Management Studio under the credentials of the SSP account using RunAs. If you can successfully connect to Analysis Services and administer Analysis Services by viewing its configuration, this should be your first indication that something is amiss with this error. The aforementioned error seems to be a “fall through” message, meaning that if something is going wrong with the build and Project Server doesn’t understand an error it recieves, then it seems to display this error by default.

In these cases, it is best to rebuild the cube after adjusting the Diagnostic Logging settings in Central Administration for the Project Server - General category to Verbose for the Trace Log and Information for the Event Log. This will increase your visibility into precisely what is going on behind the scenes in the server. Be warned that you will likely have to sift through a significant amount of information after doing this, and that you should be sure to reset these back to their defaults of Medium for the Trace Log and Warning for the Event Log (or whatever your custom setting was) after you are done troubleshooting to ensure that you don’t chew up all of your hard disk space with unnecessary logs.

Should this not yield any significant insight, your next step should be to rerun the cube build after attaching the SQL Profiler to the Analysis Services instance you are using to build the cube. This will allow you to see precisely what commands are being issued to Analysis Services by the SSP. You may also want to consider attaching the Profiler to SQL Server as well. However, you are advised to filter the DBName column to the name of your Project Server Reporting database in order to exclude data from other databases on the server.

Stephen Sanderlin is Vice President of Technology for MSProjectExperts and a Microsoft Project MVP. His earlier writings on Project Management and Microsoft Project can be read at EPMFAQ.
He is actively posting new content at ProjectServerHelp.

Popularity: 28%

Discuss this post on the EPMFAQ Blog Posts Forum.

Related Posts

Next Entry »

Please discuss this post on the EPMFAQ Blog Posts Forum.

2 Responses to “Cube Build Failure: Your permissions on the server computer do not allow you to administer this Analysis server”

  1. […] Cube Build Failure: Your permissions on the server computer do not allow you to administer this Anal… […]

  2. […] 1. Change the settings for Shared Services log. Change the settings according to the description at http://www.epmfaq.com/ssanderlin/qui…nalysis-server. 2. Having gone through the logs I discovered that the error message was related to the domain […]

The opinions expressed on this site by the authors and those providing comments are theirs alone, and do not reflect the opinions of the respective employers of the authors or any employee thereof. Our respective employers are not responsible for the accuracy of any of the information supplied by on this site.

Terms of Use | Privacy Policy | Publishers

All content on this website is covered by the
Creative Commons Attribution-Share Alike 3.0 United States License.
Theme ©2007 The Heckerped WordPress Theme created by JTk of Doc5 under the Creative Commons Attribution License.