Summary
This article details an error, "Cannot execute as the server principal because the principal 'bi360ruleuser' does not exist" and how to resolve it.
Article sections:
Symptoms
When a user runs a business rule, the user gets the following error message:
Cannot execute as the server principal because the principal "bi360ruleuser" does not exist
Cause
The customer is using the Execute As statement in the failing business rule, which requires sysadmin permission to execute the query.
This error is occurring because the user who runs the rule, or the principle "bi360rulesuser" (as shown above) does not have sysadmin permission.
Resolution
The Execute As has a declared user.
When using Execute as, the user you have declared must be a sysadmin or the user defined in the connection string must be a sysadmin. .
https://msdn.microsoft.com/en-us/library/ms181362.aspx Once the IT person grant the user sysadmin permission it will resolve this error message.
This resolution only applies to customers who use the Execute As statement in their business rule.
Properties
Applies to:
- Data Warehouse Manager 4.x