To configure the Integration Services 1. Open a Command Prompt. 2. Change directory to %ProgramFiles%\Microsoft SQL Server\100\DTS\Binn 3. Run the following command: notepad MsDtsSrvr.ini.xml 4. In Notepad, update the text inside the tag to the host name of the SQL “<ServerName>” Server 5. In Notepad, save the changes. 6. From the Command Prompt, execute the following command: net stop MsDtsServer 7. From the Command Prompt, execute the following command: net start MsDtsServer Configuring BAM Primary Import, BAM Archive, BAM Star Schema, BAM Analysis, and BAM Notification Services Application databases You can configure BAM Primary Import, BAM Archive, BAM Star Schema, BAM Analysis, and BAM Notification Services Application databases on different computers. The following are the software requirements when SQL Server is installed on a computer than the one where BizTalk Server is installed: Remote SQL Server 2008 R2/2008 SP1 BAM feature Feature configuration BizTalk Server SQL Server BAM Tools BAM Primary Import ADOMD .NET 10SQL SQL Server 2008 Tables and BAM Server 2008 R2/2008 R2/2008 SP1 Archive database SP1 Integration Services BAM Tools Enable Analysis SQL Server 2008 SQL Server 2008 Services for BAM R2/2008 SP1 R2/2008 SP1 Analysis aggregations Integration Services Services BAM Notification Enable Notification SQL Server 2005 N/A Services Application Services for BAM Notification Services Database alerts Engine Components Note The service account used for the OLAP service should have db_datareader permissions on the BAM Star Schema database.
To configure the Integration Services 1. Open a Command Prompt. 2. Change directory to %ProgramFiles%\Microsoft SQL Server\100\DTS\Binn 3. Run the following command: notepad MsDtsSrvr.ini.xml 4. In Notepad, update the text inside the “<ServerName>” tag to the host name of the SQL Server 5. In Notepad, save the changes. 6. From the Command Prompt, execute the following command: net stop MsDtsServer 7. From the Command Prompt, execute the following command: net start MsDtsServer Configuring BAM Primary Import, BAM Archive, BAM Star Schema, BAM Analysis, and BAM Notification Services Application databases You can configure BAM Primary Import, BAM Archive, BAM Star Schema, BAM Analysis, and BAM Notification Services Application databases on different computers. The following are the software requirements when SQL Server is installed on a computer than the one where BizTalk Server is installed: Remote SQL Server 2008 R2/2008 SP1 BAM feature Feature configuration BizTalk Server SQL Server BAM Tools BAM Primary Import Tables and BAM Archive database ADOMD .NET 10SQL Server 2008 R2/2008 SP1 Integration Services SQL Server 2008 R2/2008 SP1 BAM Tools Enable Analysis Services for BAM aggregations SQL Server 2008 R2/2008 SP1 Integration Services SQL Server 2008 R2/2008 SP1 Analysis Services BAM Notification Services Application Database Enable Notification Services for BAM alerts SQL Server 2005 Notification Services Engine Components N/A Note The service account used for the OLAP service should have db_datareader permissions on the BAM Star Schema database.
Installing%20BizTalk%20Server%202010%20and%20BAM%20in%20a%20Multi-Computer%20Environment.docx