Microsoft KB Archive/917840

= How to reconfigure the BAM databases in BizTalk Server 2004 =

Article ID: 917840

Article Last Modified on 5/5/2006

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Standard Edition
 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Partner Edition

-





INTRODUCTION
This article describes how to reconfigure the Business Activity Monitoring (BAM) databases in Microsoft BizTalk Server 2004.



MORE INFORMATION
To reconfigure the BAM databases after BizTalk Server 2004 has already been configured, follow these steps:  Stop all BizTalk Host services. Click Start, click Run, type notepad, and then click OK. Click File, and then click Open. In the Files of type list, click All Files. Locate and then click the BAMConfiguration.xml file, and then click Open.

Note By default, the BAMConfiguration.xml file is located in the :\Program Files\Microsoft BizTalk Server 2004\Tracking folder. is the hard disk where BizTalk Server 2004 is installed.  In Notepad, modify the &quot;PrimaryImportDatabase&quot; section to point to a computer that is running Microsoft SQL Server and the BAMPrimaryImport database that you want. For example, the &quot;PrimaryImportDatabase&quot; section may resemble the following sample code.  <Property Name=&quot;ServerName&quot;>servername</Property> <Property Name=&quot;DatabaseName&quot;>databasename</Property> <DeploymentUnit> Note In this sample code,  is the name of the computer where you want to store the BAM databases. is the name of the BAMPrimaryImport database. </li>  Modify the &quot;StarSchemaDatabase&quot; section to point to a computer that is running SQL Server and the BAMStarSchema database that you want. For example, the &quot;StarSchemaDatabase&quot; section may resemble the following sample code. <DeploymentUnit Name=&quot;StarSchemaDatabase&quot;> <Property Name=&quot;ServerName&quot;>servername</Property> <Property Name=&quot;DatabaseName&quot;>databasename</Property> <DeploymentUnit> Note In this code sample,  is the name of the computer where you want to store the BAM databases. is the name of the BAMStarSchema database. </li>  Modify the &quot;ArchivingDatabase&quot; section to point to a computer that is running SQL Server and the BAMArchiving database that you want. For example, the &quot;ArchivingDatabase&quot; section may resemble the following sample code. <DeploymentUnit Name=&quot;ArchivingDatabase&quot;> <Property Name=&quot;ServerName&quot;>servername</Property> <Property Name=&quot;DatabaseName&quot;>databasename</Property> <DeploymentUnit> Note In this sample code,  is the name of the computer where you want to store the BAM databases. is the name of the BAMArchiving database. </li>  Modify the &quot;AnalysisDatabase&quot; section to point to a computer that is running SQL Server and the BAMAnalysis database that you want. For example, the &quot;AnalysisDatabase&quot; section may resemble the following sample code. <DeploymentUnit Name=&quot;AnalysisDatabase&quot;> <Property Name=&quot;ServerName&quot;>servername</Property> <Property Name=&quot;DatabaseName&quot;>databasename</Property> <DeploymentUnit> Note In this sample code,  is the name of the computer where you want to store the BAM databases. is the name of the BAMAnalysis database. </li> Click File, and then click Save As.</li> In the Save as type list, click All Files.</li> In the File name box, type a new name for the file, and then click OK. For example, type modifiedBAMConfiguration.xml, and then click OK.</li> Exit Notepad.</li> Click Start, click Run, type cmd, and then click OK.</li> At the command prompt, use the CD command to change to the folder where the Bm.exe file is located.

Note By default, the Bm.exe file is located in the :\Program Files\Microsoft BizTalk Server 2004\Tracking folder. is the hard disk where BizTalk Server 2004 is installed.</li> At the command prompt, type bm.exe dbsetup, and then press ENTER. In this command,  is the name of the file that you saved in step 12.</li> At the command prompt, type exit, and then press ENTER.</li> Start SQL Server Enterprise Manager.</li> Expand Microsoft SQL Servers, expand SQL Server Group, expand the name of the computer that is running SQL Server and that is where you want to store the BAM databases, expand Databases, expand BizTalkMgmtDb, and then click Tables.</li> In the right pane, right-click TDDS_Destinations, point to Open Table, and then click Return all rows.</li>  In the row where Business Monitoring is the DestinationName value, modify the Initial Catalog and Data Source values in the connection string. For example, the row should resemble the following. Pooling=false;Current Language=us_english;Integrated Security=SSPI;Initial Catalog=databasename; Data Source=databasename Note In this example,  is the name for the BAMPrimaryImport database. is the name of computer where you want to store the BAM databases. </li> Close the TDDS_Destinations table.</li> <li>In the right pane, right-click adm_Group, point to Open Table, and then click Return all rows.</li> <li>In the BAMDBName column, type the name of the BAMPrimaryImport database.</li> <li>In the BAMDBServerName column, type the name of the computer where you want to store the BAM databases.</li> <li>Close the adm_Group table.</li> <li>Start all BizTalk Host services.</li></ol>

Keywords: kbhowto kbinfo kbbtsbam kbbts KB917840

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.