Hi all,
I am trying to add a cube that is already present Analysis Server into my model.When I run the Metadata Wizard and after selecting the data source,I get the following error:
MO-ERR-0028 The user starting the process doesn't have the correct privileges.
How do I check and correct these user privileges in Analysis Manager?
Thank you...
Is it MSAS2005?
I dont know it will be helpful or not but try these steps.
the Cognos 8 service needs to be started as a domain account.
the credentials for the datasource connection has to be "Cognos 8 service credentials"
Steps:
1. the Cognos 8 service needs to be started as a domain account. If there is no domain to startup as, start the service as a domain using a local account:
Example:
username: .\local_user
password: password
Replace "local_user" with a local account user that has OLAP Administrator privileges
Replace "password" with the proper password
2. Go to Control Panel/Administrative Tools/Local Security Policy/
3. Once there, go to Security Settings\Local Policies\User Rights Assignments and look for the policy named "Act as part of the operating system".
4. Add the local user to that policy
Example:
LOCALMACHINE\local_user
5. Create the datasource to the MS Analysis Services in either Cognos Connection or Framework Manager
6. Set the signon to be "Cognos 8 service credentials
... the reason being that MS AS 2005 accepts ONLY Integrated Windows Authentication ... My 5 cents.