I'm having a problem with getting the cubes setup. I deployed the Adventure Works DW 2008 SE to my local machine and when I connect to the Analysis Server I can see the Adventure Works DW 2008R2 SE database. And I can drill down and see the Adventure Works cube, and drill further I see Measure Groups.

But when I highlighted the AW cube and clicked New Query I get a message: "Error loading metadata. No cubes were found". So I clicked the Process and get an error 'The datasource, "Adventure Works DW', contains an ImpersonationMode that is not supported for processing operations."

This is the same set of errors I was getting when I initially tried to deploy from BIDS. I found a post on here about this and changed the Deployment option to 'Do not process' and the Impersonation Information of the Data Source to 'Use the credentials of the current user'.

What security settings do I need to process these cubes?

*************************************************************************************

Well, one of the errors from some setting on the Inheritance tab referred to NT Network Authority. So, I gave that account db_owner on the AWDW2008R2 and I was able to process the project in BIDS. And I have items in the Measure Group of the query window.

Now the question is whether I have to always give NT AUTHORITY\NETWORK SERVICE db_owner rights to the databases I want to participate in AS?

Thanks.