BAM can configure only Analysis Services 2005 or 2008

Question

Does anyone know what is the problem? I've tried to deploy an activity and view from XML into BAM and got this trace:

Deploying Activity... Done.
Deploying View... ERROR: The BAM deployment failed.
BAM can configure only Analysis Services 2005 or 2008.

I have installed MSSQL Server 2008 r2 and MSSQL Server 2005 Analysis Services ADOMD.NET. Analysis Services log on as local system account.

Answer 1

Looks like you're missing BAMStarSchema and BAMAnalysis.

Open BizTalk Server Configuration, go to the BAM Tools tab, and make sure you have those options configured and deployed.

See this blog for some more information on configuring that (related to a different error, but same configuration process). It's got pretty pictures and everything.

Answer 2

Try unchecking the RTA in the Excel it will work, because the RTA need the SQL Enterprise edition. See this Blog for more information : BAM! Deployment Problem Solved!

Also check whether the Database are mapped correctly in the BizTalk Config,