How to reconfigure the BAM databases in BizTalk Server 2004 (917840)

MORE INFORMATION

1. Stop all BizTalk Host services.
2. Click Start, click Run, type notepad, and then click OK.
3. Click File, and then click Open.
4. In the Files of type list, click All Files.
5. Locate and then click the BAMConfiguration.xml file, and then click Open.
   
   Note By default, the BAMConfiguration.xml file is located in the drive:\Program Files\Microsoft BizTalk Server 2004\Tracking folder. drive is the hard disk where BizTalk Server 2004 is installed.
6. In Notepad, modify the "PrimaryImportDatabase" section to point to a computer that is running Microsoft SQL Server and the BAMPrimaryImport database that you want. For example, the "PrimaryImportDatabase" section may resemble the following sample code.

   <DeploymentUnit Name=" PrimaryImportDatabase">
   <Property Name="ServerName">servername</Property>
   <Property Name="DatabaseName">databasename</Property>
   <DeploymentUnit>

   Note In this sample code, servername is the name of the computer where you want to store the BAM databases. databasename is the name of the BAMPrimaryImport database.
7. Modify the "StarSchemaDatabase" section to point to a computer that is running SQL Server and the BAMStarSchema database that you want. For example, the "StarSchemaDatabase" section may resemble the following sample code.

   <DeploymentUnit Name="StarSchemaDatabase">
   <Property Name="ServerName">servername</Property>
   <Property Name="DatabaseName">databasename</Property>
   <DeploymentUnit>

   Note In this code sample, servername is the name of the computer where you want to store the BAM databases. databasename is the name of the BAMStarSchema database.
8. Modify the "ArchivingDatabase" section to point to a computer that is running SQL Server and the BAMArchiving database that you want. For example, the "ArchivingDatabase" section may resemble the following sample code.

   <DeploymentUnit Name="ArchivingDatabase">
   <Property Name="ServerName">servername</Property>
   <Property Name="DatabaseName">databasename</Property>
   <DeploymentUnit>

   Note In this sample code, servername is the name of the computer where you want to store the BAM databases. databasename is the name of the BAMArchiving database.
9. Modify the "AnalysisDatabase" section to point to a computer that is running SQL Server and the BAMAnalysis database that you want. For example, the "AnalysisDatabase" section may resemble the following sample code.

   <DeploymentUnit Name="AnalysisDatabase">
   <Property Name="ServerName">servername</Property>
   <Property Name="DatabaseName">databasename</Property>
   <DeploymentUnit>

   Note In this sample code, servername is the name of the computer where you want to store the BAM databases. databasename is the name of the BAMAnalysis database.
10. Click File, and then click Save As.
11. In the Save as type list, click All Files.
12. 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.
13. Exit Notepad.
14. Click Start, click Run, type cmd, and then click OK.
15. 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 drive:\Program Files\Microsoft BizTalk Server 2004\Tracking folder. drive is the hard disk where BizTalk Server 2004 is installed.
16. At the command prompt, type bm.exe dbsetup file_name, and then press ENTER. In this command, file_name is the name of the file that you saved in step 12.
17. At the command prompt, type exit, and then press ENTER.
18. Start SQL Server Enterprise Manager.
19. 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.
20. In the right pane, right-click TDDS_Destinations, point to Open Table, and then click Return all rows.
21. 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, databasename is the name for the BAMPrimaryImport database. servername is the name of computer where you want to store the BAM databases.
22. Close the TDDS_Destinations table.
23. In the right pane, right-click adm_Group, point to Open Table, and then click Return all rows.
24. In the BAMDBName column, type the name of the BAMPrimaryImport database.
25. In the BAMDBServerName column, type the name of the computer where you want to store the BAM databases.
26. Close the adm_Group table.
27. Start all BizTalk Host services.