Error: OLE DB or ODBC error.Errors in the high-level relational engine

Symptoms

When attempting to deploy and execute the OLAP server within the Jet Data Manager, you encounter the following error message:

"OLE DB error: OLE DB or ODBC error.Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWH', Name of 'DWH'.Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer', Name of 'Customer' was being processed.Errors in the OLAP storage engine: An error occurred while the 'CountryRegionCode' attribute of the 'Customer' dimension from the 'CronusOLAP' database was being processed.Internal error: T"

Cause

This error is caused by the service SQL Server Analysis Services running under a network account that does not have the proper permissions.

Resolution

To resolve this error, ensure the service SQL Server Analysis Services is running with a proper Log On As user.

This user should have administrator permission on Analysis Services and the proper permissions on the database engine.

See Setting Permissions for Log On As user for more detailed information regarding how to set the proper permissions.