[BizTalk] BAM Tool - Cannot open database "BAMPrimaryImport"

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.

Solution:

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