Answered Installing BAM Client

  • 2012年5月3日 上午 12:42
     
     

    Hi, I've installed BizTalk Server 2010 Developer Edition on a dev environment and I'm trying to run some samples for BAM. I can't see the Excel Add-in in the add-ins list if I try and enable it.

    The document "Installing BizTalk Server 2010 on Windows Server 2008 R2 and 2008" says this

    BAM Client

    The following are the software requirements when using the BAM client:

    • For the Web client, you need Internet Explorer 8.0 or later and Office Web Components 11 version 4.0 or later.
    • If you are running the Web client and using SQL Server 2008 R2/2008 SP1 Analysis Services, you must install Microsoft SQL Server 2008 R2/2008 SP1 Analysis Services 10.0 OLE DB Provider.
    • For the Excel client, you need Microsoft Excel® 2010/2007 and the BAM Excel Add-in provided with BizTalk Server 2010.

    In my BizTalk config I've got all the BAM tools configured. Do I need to install the BAM Client separately? In the Pro BAM book it says 

    Do you see the BAM Add-In in Excel? If the BAM Add-In for Excel is missing, check to see whether you can find a file called C:\Program Files\Microsoft Office\Office12\Library\BAM.xla. If you have this file, you should be able to enable the BAM Add-In for Excel using the Add-In Management dialog box. If you don’t have it, the BAM tools are not installed. Use Add/Remove Programs to check the BizTalk Server installation and ensure the BAM client, which is found under Additional Software, is installed.

    I can't see BAM client in the installed programs list. Where is the installer?

    Thanks

所有回覆

  • 2012年5月3日 上午 02:19
     
     已答覆

    Had to manually copy the file Bam.xla to C:\Program Files (x86)\Microsoft Office\Office14\Library. Also, when I installed office excel I just ignorantly didn't install anything other than Excel. So I needed to Add or Remove features on Office and add Office Shared Features -> Visual Basic for Applications.

    Thanks

    • 已標示為解答 DukeDickinson 2012年5月3日 上午 02:19
    •  
  • 2012年5月8日 上午 07:31
    版主
     
     

    Glad to see you have solved your issue. Thanks for sharing the solution.

    Regards.


    Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact msdnmg@microsoft.com. Microsoft One Code Framework

  • 2012年5月16日 上午 09:02
     
     

    If you have checked BAM client in the BizTalk installation but BAM is not listed under the Excel (File -> Option -> Addins) then you click Manage Excel Add-ins -> Browse. Browse to BAM.xla under C:\Program Files\Microsoft BizTalk Server 2010\ExcelDir.

    You will see BAM is now listed under Add-ins.

    rgds,
    sazul