When processing SSAS Data Mining Structure which is based on a Cube (DataSource is Used as Cube) in such a case Analysis Services uses service Startup Account while processing Mining Structure.
If Analysis Services Startup Account doesn’t have Full Permission on OLAP Cube then processing will fail with below mentioned error:
Errors and Warnings from Response
Internal error: The operation terminated unsuccessfully.
OLE DB error: OLE DB or ODBC error: The UseTransaction and MasterTransaction request properties are reserved for database administrators..
Errors in the OLAP storage engine: An error occurred while processing the ‘Internet ~1 ~MG’ partition of the ‘Internet ~1 ~MG’ measure group for the ‘Customer Clusters ~MC’ cube from the Adventure Works DW 2008R2 database.
Server: The operation has been cancelled.
Errors in the OLAP storage engine: An error occurred while processing the ‘~CaseDetail ~MG’ partition of the ‘~CaseDetail ~MG’ measure group for the ‘Customer Clusters ~MC’ cube from the Adventure Works DW 2008R2 database.
To work around this issue –
Ensure that <ServiceAccountIsServerAdmin> Property in msmdsrv.ini file is set to 1 (True)
Default – Location of msmdsrv.ini file (C:\Program Files\Microsoft SQL Server\MSAS10_50.SQL2008R2\OLAP\Config)
Create a Role in Database – Grant Full Control to this Role and Add Service Account Member of this Role