When a user runs a business rule, the user gets the following error.
"Cannot execute as the server principal because the principal "bi360ruleuser" does not exist."
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.
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. .
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.
- Data Warehouse Manager 4.x