Microsoft.BizTalk.Bam.Management.BamManagerException:
The BAM deployment failed. ---> Microsoft.AnalysisServices.OperationException:
OLE DB error: OLE DB or ODBC error: Cannot open database
"BAMPrimaryImport" requested by the login. The login failed.; 42000.
Errors in the high-level relational engine.
A connection could not be made to the data source with the DataSourceID of
'bam_rta_xxxJobXBamView', Name of 'bam_rta_xxxJobXBamView'.
Server:
The current operation was cancelled because another operation in the
transaction failed.
Since BizTalk BAM tool impersonated SSAS service account to deploy some aggregation tasks.
According to MSDN: https://msdn.microsoft.com/en-us/library/aa560569.aspx
The account which executed SSAS service needs to assign the permissions below:
db_datareader to:
- BAMPrimaryImport
- BAMStarSchema
No comments
Post a Comment