Hi,

I am trying to install BizTalk Server in multi-computer environment.

I did install BizTalk Server on primary server smoothly.

On Sencodary Server, I am able to join existing SSO and BizTalk Group.

When I try to configure BAM Tools and BAM Alerts I get an error in BizTalk Log - 

2014-02-06 11:12:39:6987 [Info] BAMTools Source:
2014-02-06 11:12:39:6987 [Info] BAMTools System.ServiceProcess
2014-02-06 11:12:39:6987 [Info] BAMTools Error messages:
2014-02-06 11:12:39:6987 [Info] BAMTools 
2014-02-06 11:12:39:6987 [Info] BAMTools Service BAMAlerts was not found on computer '.'.
2014-02-06 11:12:39:6997 [Info] BAMTools The specified service does not exist as an installed service
2014-02-06 11:12:39:6997 [Info] BAMTools 
2014-02-06 11:12:39:6997 [Info] BAMTools Call stack:
2014-02-06 11:12:39:6997 [Info] BAMTools 
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.GenerateNames()
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.get_ServiceName()
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.GenerateStatus()
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.get_Status()
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.AlertHostHelper.StopService()
2014-02-06 11:12:39:6997 [Info] BAMTools <BizTalk2009> 02/06/2014 11:12:38 1 Microsoft.BizTalk.Bam.Management.AlertModule2012 UpdateConfig Error Exception thrown
2014-02-06 11:12:39:6997 [Info] BAMTools Source:
2014-02-06 11:12:39:6997 [Info] BAMTools System.ServiceProcess
2014-02-06 11:12:39:6997 [Info] BAMTools Error messages:
2014-02-06 11:12:39:6997 [Info] BAMTools 
2014-02-06 11:12:39:6997 [Info] BAMTools Service BAMAlerts was not found on computer '.'.
2014-02-06 11:12:39:6997 [Info] BAMTools The specified service does not exist as an installed service
2014-02-06 11:12:39:6997 [Info] BAMTools 
2014-02-06 11:12:39:6997 [Info] BAMTools Call stack:
2014-02-06 11:12:39:6997 [Info] BAMTools 
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.GenerateNames()
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.get_ServiceName()
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.GenerateStatus()
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.get_Status()
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.AlertHostHelper.StopService()
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.AlertModule2012.UpdateConfig(BamConfigurationManager originalConfig, BamConfigurationManager bamConfig)
2014-02-06 11:12:39:6997 [Info] BAMTools <BizTalk2009> 02/06/2014 11:12:38 1 Microsoft.BizTalk.Bam.Management.AlertModule2012 UpdateConfig Exit
2014-02-06 11:12:39:6997 [Info] BAMTools <BizTalk2009> 02/06/2014 11:12:38 1 Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility Main Error Exception thrown
2014-02-06 11:12:39:6997 [Info] BAMTools Source:
2014-02-06 11:12:39:6997 [Info] BAMTools System.ServiceProcess
2014-02-06 11:12:39:6997 [Info] BAMTools Error messages:
2014-02-06 11:12:39:6997 [Info] BAMTools 
2014-02-06 11:12:39:6997 [Info] BAMTools Service BAMAlerts was not found on computer '.'.
2014-02-06 11:12:39:6997 [Info] BAMTools The specified service does not exist as an installed service
2014-02-06 11:12:39:6997 [Info] BAMTools 
2014-02-06 11:12:39:6997 [Info] BAMTools Call stack:
2014-02-06 11:12:39:6997 [Info] BAMTools 
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.GenerateNames()
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.get_ServiceName()
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.GenerateStatus()
2014-02-06 11:12:39:6997 [Info] BAMTools    at System.ServiceProcess.ServiceController.get_Status()
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.AlertHostHelper.StopService()
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.AlertModule2012.UpdateConfig(BamConfigurationManager originalConfig, BamConfigurationManager bamConfig)
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.AlertModule.UpdateConfig()
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.BamManager.UpdateConfigurationXml()
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.HandleUpdateConfig()
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.DispatchCommand()
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Run()
2014-02-06 11:12:39:6997 [Info] BAMTools    at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Main(String[] args)
2014-02-06 11:12:39:6997 [Info] BAMTools <BizTalk2009> 02/06/2014 11:12:38 1 Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility Main Exit
2014-02-06 11:12:39:6997 [Info] BAMTools Finished logging tracing of bm.exe execution.
2014-02-06 11:12:39:6997 [Info] BAMTools Deleting File: C:\Users\!gtqk\AppData\Local\Temp\2\6fc65525-7a2d-4c82-aa3a-e776e4e58291-BamManagerTrace.log
2014-02-06 11:12:39:7007 [Info] BAMTools Deleting File: E:\Program Files (x86)\Microsoft BizTalk Server 2013\Tracking\bm.exe.config
2014-02-06 11:12:39:7007 [Error] BAMTools Error configuring
Error executing bm.exe with tracing enabled. (Microsoft.BizTalk.Bam.CfgExtHelper.Utility)
Error executing process: E:\Program Files (x86)\Microsoft BizTalk Server 2013\Tracking\bm.exe (Microsoft.BizTalk.Bam.CfgExtHelper.Utility)
Microsoft (R) Business Activity Monitoring Utility Version 3.10.229.0

Copyright (C) Microsoft Corporation. All rights reserved.

I have made the required changes on the SQL Server - MSTDC, Named Pipes Enabled.

BizTalk Server 1 and BizTalk Server 2 both have required MSDTC settings. Along with this Firewall settings are also modified.

I have followed this link - http://social.technet.microsoft.com/wiki/contents/articles/1888.install-and-configure-bam-business-activity-monitoring-in-a-multi-computer-environment.aspx

which is for BizTalk Server 2010 (provided for BizTalk Server 2013 ?).

Kindly, let me knoe if anyone had similar issue and it has been resolved , or any other pointers

With Regards,

Gopal Talreja

In BizTalk configuration "Named pipes" has to be explicitly disabled. You state as having enabled it... strict No. No...

Secondly, you do not specify the version of BizTalk, the log mentions 2009 whereas you're using document provided for 2010?

By the looks of it, SQL Server Notification Services is not configured on the SQL Server. You;d need to install SQL Server Notification Service on the BizTalk BAM computer with the database on the remote SQL.

You have enabled DTC but have you verified it through DTC Ping or DTC Tester?

Regards.

Hi,

I am using BizTalk Server 2013, even though the BizTalk log shows BizTalk 2009.

Also, When I look for 2013 documentation, it points to documentation for BizTalk 2010.

Along with this I am using SQL Server 2012, so no need of SQL Server Notification Services as well.

Initially, Named Pipes was disabled. I tried it that way but it was not working.

Any other pointer ? 

First question is - Should I have BAM ALERTs configured on the secondary server as well ?

if Yes, then what should be the process.

Rgds,

Gopal

You can download the 2013 related documentation from http://www.microsoft.com/en-in/download/details.aspx?id=35552

When using SQL 2012 for Notification Services, there is an explicit requirement for enabling SQL Mail. From the link above you;d get the Multi-Computer install which will take you through the steps. If TCP/IP is not working for SQL, maybe that is what you need to check, is SQL configured for TCP/IP, is DTC tested, appropriate permissions in SQL, Domain User Group, etc.

Regards.

• Marked as answer by Pengzhen SongMicrosoft contingent staff, Moderator Monday, February 17, 2014 10:45 AM

You can download the 2013 related documentation from http://www.microsoft.com/en-in/download/details.aspx?id=35552

When using SQL 2012 for Notification Services, there is an explicit requirement for enabling SQL Mail. From the link above you;d get the Multi-Computer install which will take you through the steps. If TCP/IP is not working for SQL, maybe that is what you need to check, is SQL configured for TCP/IP, is DTC tested, appropriate permissions in SQL, Domain User Group, etc.

Regards.

• Marked as answer by Pengzhen SongMicrosoft contingent staff, Moderator Monday, February 17, 2014 10:45 AM

Gopal,

I got exactly error on my second BizTalk sever. Have you solved problem? can you share your solution?

Thank you,

Fanyin

Make sure you install CU1 for BizTalk Server 2013:

http://support.microsoft.com/kb/2838133/en-us

There is a known issue regarding BAM on a multi-node BizTalk Server.

Morten la Cour

Morten Thanks for the reply.

I installed CU1 and CU2 on both BizTalk 2013 severs and restart them. I got same error as before

Service BAMAlerts was not found on computer '.'.
The specified service does not exist as an installed service

 (Microsoft.BizTalk.Bam.CfgExtHelper.Utility)

Fanyin

I am getting exactly same error on my second box. I am using biztalk 2013 R2. Did you find any solution for this . If yes please let me know as I got stuck there.

We are getting the same error with BizTalk 2013 R2 and SQL Server 2014.  Has a solution been found to this problem.

I faced similar problem while installing BAMAlerts on 2nd BizTalk 2013 R2 server in a group. The reason for this error is the Wizard is unable to create the windows service (BAMAlerts) during the configuration. To fix the issue you need to create the service manually. I had to perform following actions:

1.CREATE SERVICE:

Start command prompt as administrator on the node with problems. Execute (do not use copy paste from email, it often gives error):

sc create BAMAlerts binPath=  "C:\Program Files (x86)\Microsoft BizTalk Server 2013\Tracking\BAMAlerts.exe

2. SET USERNAME and PASSWORD on this Service:

Open services admin console, and change the user and password for the BAMAlerts Service.

- Start the service.

Start again the configuration for the BAM on the node with problems and complete the BAMTools and BAMAlerts configration (do not enter any username and password in the BAMAlerts configuration wizard).

3. RUN SQL Statement:

After starting the Service, BAMAlerts service may stop with following error in the event log:

Microsoft.BizTalk.Bam.Management.BamManagerException: Encountered error while executing command on SQL Server "A-CLS01VISQL1". ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'bam_Metadata_GetProperty', database 'BAMPrimaryImport', schema 'dbo'.

To solve this, run following SQL statement 

USE BAMPrimaryImport

GRANT EXECUTE ON bam_Metadata_GetProperty

    TO BAM_ManagementNSReader;

GO

 

This should solve the problem.

Thanks to Microsoft support engineer for help.

Strange bug and I hope MS will solve this issue in next patch/CU/update

• Edited by Srinivas.B.Rao 13 hours 33 minutes ago formatting

I faced similar problem while installing BAMAlerts on 2nd BizTalk 2013 R2 server in a group. The reason for this error is the Wizard is unable to create the windows service (BAMAlerts) during the configuration. To fix the issue you need to create the service manually. I had to perform following actions:

1.CREATE SERVICE:

Start command prompt as administrator on the node with problems. Execute (do not use copy paste from email, it often gives error):

sc create BAMAlerts binPath=  "C:\Program Files (x86)\Microsoft BizTalk Server 2013\Tracking\BAMAlerts.exe

2. SET USERNAME and PASSWORD on this Service:

Open services admin console, and change the user and password for the BAMAlerts Service.

- Start the service.

Start again the configuration for the BAM on the node with problems and complete the BAMTools and BAMAlerts configration (do not enter any username and password in the BAMAlerts configuration wizard).

3. RUN SQL Statement:

After starting the Service, BAMAlerts service may stop with following error in the event log:

Microsoft.BizTalk.Bam.Management.BamManagerException: Encountered error while executing command on SQL Server "A-CLS01VISQL1". ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'bam_Metadata_GetProperty', database 'BAMPrimaryImport', schema 'dbo'.

To solve this, run following SQL statement 

USE BAMPrimaryImport

GRANT EXECUTE ON bam_Metadata_GetProperty

    TO BAM_ManagementNSReader;

GO

 

This should solve the problem.

Thanks to Microsoft support engineer for help.

Strange bug and I hope MS will solve this issue in next patch/CU/update

• Edited by Srinivas.B.Rao Monday, February 16, 2015 9:52 PM formatting

I faced similar problem while installing BAMAlerts on 2nd BizTalk 2013 R2 server in a group. The reason for this error is the Wizard is unable to create the windows service (BAMAlerts) during the configuration. To fix the issue you need to create the service manually. I had to perform following actions:

1.CREATE SERVICE:

Start command prompt as administrator on the node with problems. Execute (do not use copy paste from email, it often gives error):

sc create BAMAlerts binPath=  "C:\Program Files (x86)\Microsoft BizTalk Server 2013\Tracking\BAMAlerts.exe

2. SET USERNAME and PASSWORD on this Service:

Open services admin console, and change the user and password for the BAMAlerts Service.

- Start the service.

Start again the configuration for the BAM on the node with problems and complete the BAMTools and BAMAlerts configration (do not enter any username and password in the BAMAlerts configuration wizard).

3. RUN SQL Statement:

After starting the Service, BAMAlerts service may stop with following error in the event log:

Microsoft.BizTalk.Bam.Management.BamManagerException: Encountered error while executing command on SQL Server "A-CLS01VISQL1". ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'bam_Metadata_GetProperty', database 'BAMPrimaryImport', schema 'dbo'.

To solve this, run following SQL statement 

USE BAMPrimaryImport

GRANT EXECUTE ON bam_Metadata_GetProperty

    TO BAM_ManagementNSReader;

GO

 

This should solve the problem.

Thanks to Microsoft support engineer for help.

Strange bug and I hope MS will solve this issue in next patch/CU/update

• Edited by Srinivas.B.Rao Monday, February 16, 2015 9:52 PM formatting