BAM Configuration Error: BizTalk 2010

Question

OS: Windows 2008 R2 64; Database: SQL 2008 R2 64, BizTalk 2010 64

I followed the installation manual. Everything went smooth till I had to configure BAM. This is the error I see in the Event Log.

Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

- <System>

  <Provider Name="BamManagementUtility" />

  <EventID Qualifiers="0">1047</EventID>

  <Level>2</Level>

  <Task>0</Task>

  <Keywords>0x80000000000000</Keywords>

  <TimeCreated SystemTime="2010-10-02T02:46:49.000000000Z" />

  <EventRecordID>2455</EventRecordID>

  <Channel>Application</Channel>

  <Computer>WIN-MAMATA</Computer>

  <Security />

  </System>

- <EventData>

  <Data>Microsoft.BizTalk.Bam.Management.BamManagerException: Failed to set up BAM database(s). ---> Microsoft.BizTalk.Bam.Management.BamManagerException: There was a failure while executing nscontrol.exe. Error:"Microsoft Notification Services Control Utility 9.0.242.0 c Microsoft Corp. All rights reserved. An error was encountered when running this command. Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. " at Microsoft.BizTalk.Bam.Management.AlertModule.ExecNSControlCommand(String commandArg) at Microsoft.BizTalk.Bam.Management.AlertModule.SetupAlertInfrastructure() at Microsoft.BizTalk.Bam.Management.BamManager.SetupDatabases() --- End of inner exception stack trace --- at Microsoft.BizTalk.Bam.Management.BamManager.SetupDatabases() at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.HandleSetupDatabases() at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.DispatchCommand() at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Run() at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Main(String[] args)</Data>

  </EventData>

  </Event>

I tried to find similar post but was not able to.. Please excuse if it exist and kindly point it out. Thank You.

Answer 1

It looks like SQL Client components (or SQL Server Integrations service) is not installed on the machine from where you are configuring.

---

Regards, Saravana Kumar [MVP BizTalk Server] http://blogs.digitaldeposit.net/saravana/ http://www.biztalk247.com/

Answer 2

I guess, the error seems to be related to notification services used by BAM Alerts. With BT 2009 and SQL 2008 in the past, we had to install SQL 2005 Notification services. A fix  for SQl 2008 is mentioned in the comment on this post, http://kishored.blogspot.com/2009/07/bam-alerts-issue-while-installing.html . I guess, same fix would work for SQL 2008 R2 as well.

Just install the SSNS components described in the installation guide and the BAM Alerts will be up and running in SQL 2008 .

I downloaded the latest release of the components (http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en) and installed them in the following order (as described in the documentation):

1) Microsoft SQL Server Native Client
2) Microsoft SQL Server 2005 Management Objects Collection
3) Microsoft SQL Server 2005 Notification Services Client Components

 Please let us know, if it works. I am also planning to start setting up a VM with similar environment.

---

Please mark it as answer by clicking on "Propose As Answer", if it helps

Answer 3

I ran into exactly the same error and tried to install the notification services as indicated by the installation guide but that didn't help. The setup didn't complete without errors. I guess that you need to install notification services in advance because you run into versioning issues. I'm also interested in a solution.

Answer 4

The assembly it is failing on is Microsoft.SqlServer.Smo which is the SQL Server Management objects. This is one of the 4 hotfixes to download to enable Notification Services: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=953752. Install these before trying to configure BAM.

If your SQL Server is on a separate box than BizTalk you also need the SQL Client & management tools. This blog post I did shows a screenshot of which features in SQL you will need to select: http://msinnovations.wordpress.com/2009/11/05/configuring-bam-tools-on-w2k8-r2/

My blog post was for SQL 2008 R1 but it should be very similar for SQL 2008 R2.

Thanks,

---

If this answers your question, please use the "Answer" button to say so | Ben Cline

Answer 5

Hi,

I have installed BizTalk 2010 in 32 and 64 environment and ran into this problem twice. Installation of Microsoft SQL Server Native Client, Managemebn Object Collections and NS did affect behaviour i.e. still produces this error. I exactly followed procedure as dictated in appropiate installation guides. This is can be a pain, but my thinking is you need to install SQL Server 2005 Notification Services from on of the SQL Server ISO's (MSDN or VLM) and perhaps apply hotfix (see this thread) or apply SP2 (see system requirements for BizTalk 2010 where there is support for Notification Services is mentioned!). All in all an interesting challenge to get BAM Alerts working on 2010.

HTH

Regards,

Steef-Jan Wiggers - MVP & MCTS BizTalk Server
blog: http://soa-thoughts.blogspot.com/
If this answers your question please mark it accordingly

---

BizTalk

Answer 6

SQL Client components (or SQL Server Integrations service) is not installed on the machine from where you are configuring.. install this then try it again.

Answer 7

Hi,

 

Thanks for the your replies. I fixed the problem. 

I failed BAM Configuration when I followed "Installation of SQL notification" as stated in manual “BizTalk 2010 Installation and Configuration Guide – Development and Test Build BizTalk 2010 64-bit, SQL Server 2008 R2 64-bit, Windows 2008 R2 64-bit” I also tried hotfixes but it got complicated and i messed it up. 

I used SQL Server 2005 Developers ISO and Installed Notification services.  Then I also installed Service Pack 3 for SQL 2005.  BAM is Configured. 

Answer 8

Hi,

I have accomplished the same thing on my virtual machine. I installed Notifications Services from SQL Server 2005 Developer ISO. I then installed SP3 for SQL 2005 and BAM is configured.

Regards,

Steef-Jan Wiggers - MVP & MCTS BizTalk Server
blog: http://soa-thoughts.blogspot.com/
If this answers your question please mark it accordingly

---

BizTalk