aggregation and analysis. Management Web Service, and the BizTalk Server engine. depending on the application. The BizTalk host services may also be installed on this server, or on a separate server in multiple computer configurations having three or more computers. Database and Platform Services Data storage and retrieval; security and authentication; networking; operating system functions SQL Server, Windows Server, Enterprise Single Sign-On (SSO),and fail-over and NLB clustering On a server running Windows Server, SQL Server. For performance reasons this server typically does not run the BizTalk host services. Installing BAM It is easier to understand BAM, the installation and configuration process, and dependencies by splitting into three BizTalk Server environments described in the following table. To setup BAM (Business Activity Monitoring) in a multi-computer environment on a Windows Server 2008 R2 platform, see (http://go.microsoft.com/fwlink/?LinkID=208597). Runtime Environment Design-time Environment Environment A basic BizTalk Server 2010 runtime environment may include the following servers:  BizTalk Server 2010  SQL Server 2008 R2/2008 SP1  BizTalk BAM Server  Web Server There are three roles involved during the BAM development and deployment process. These are as follows:  Business analyst  Business administrator  Application developer After a BAM solution is implemented and deployed, business end-users can view the reports generated by various reporting tools. These tools include  Bam Portal  SQL Server Reporting Services  Microsoft PerformancePoint Monitoring Server  Custom BAM reporting applications
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.
SSO Administrators Administrator of the Enterprise Single Sign-On (SSO) service.For more information about SSO accounts, see "How to Specify SSO Administrator and Affiliate Administrators Accounts" at . Contains service accounts for Enterprise Single Sign-On service. Contains users/groups that need to be able to configure and administer BizTalk Server and SSO service.Contains accounts used to run BizTalk Configuration Manager when configuring SSO master secret server. db_owner SQL Server Database Role for the SSO. securityadmin SQL Server Role for the SQL Server where SSO is located. SSO Affiliate Administrators Administrators of certain SSO affiliate applications. Can create/delete SSO affiliate applications, administer user mappings, and set credentials for affiliate application users. Contains no service accounts. Contains account used for BizTalk Server Administrators. BizTalk Server Administrators Has the fewest privileges necessary to perform administrative tasks. Can deploy solutions, manage applications, and resolve message processing issues. To perform administrative tasks for adapters, receive Contains users/groups that need to be able to configure and administer BizTalk Server. BTS_ADMIN_USERS SQL Server Database Role in the following databases:BizTalkMgmtDb, BizTalkMsgBoxDb, BizTalkRuleEngineDb, BizTalkDTADb, BAMPrimaryImport. db_owner SQL Server Database Role for the following databases:BAMStarSchema, BAMPrimaryImport,
and send handlers, and receive locations, the BizTalk Server Administrators must be added to the Single Sign-On Affiliate Administrators. For more information, see "Managing BizTalk Server Security" in at . BAMArchive, BAMAlertsApplication, BAMAlertsNSMain. NSAdmin SQL Server Database Role in the following databases: BAMAlertsApplication, BAMAlertsNSMain. SQL Server Database Role in the following databases: BizTalkDTADb, BizTalkMgmtDb. OLAP Administrators on the computer hosting the BAMAnalysis OLAP database. BizTalk Server Operators Has a low privilege role with access only to monitoring and troubleshooting actions. Contains user/groups that will monitor solutions. Contains no service accounts. BTS_OPERATORS SQL Server Database Role in the following databases: BizTalkDTADb, BizTalkEDIDb, BizTalkMgmtDb, BizTalkMsgBoxDb, BizTalkRuleEngineDb. BizTalk Application Users The default name of the first In-Process BizTalk Host Group created by Configuration Manager. Use one BizTalk Host Group for each In-Process host in your environment. Includes accounts with access to BizTalk Hosts (hosts processes in BizTalk Server, BTSNTSvc.exe). Contains service accounts for the BizTalk In-Process host instance in the host that the BizTalk Host Group is designated for. BTS_HOST_USERS SQL Server Database Role in the following databases:BizTalkMgmtDb, BizTalkMsgBoxDb, BizTalkRuleEngineDb, BizTalkDTADb, BAMPrimaryImport. BAM_EVENT_WRITER SQL Server Database Role in the BAMPrimaryImport. BizTalk Isolated Host Users The default name of the first Isolated Contains service accounts for the BTS_HOST_USERS SQL Server Database Role in the
Sign-On Service which accesses the SSO database. BizTalk Host Instance Account Service account used to run BizTalk host instance (BTNTSVC). BizTalk Application BizTalk Isolated Host Instance Account Service account used to run BizTalk Isolated host instance (HTTP/SOAP). BizTalk Isolated Host UsersIIS_WPG Rule Engine Update Service Service account used to run Rule Engine Update Service, which receives notifications to policies from the Rule engine database. RE_HOST_USERS SQL Server Database Role in the BizTalkRuleEngineDb. BizTalk Base EDI service Service account used to run BizTalk Base EDI service, which processes EDI documentations. Important The Base EDI adapter was in BizTalk Server EDI Subsystem UsersIn-Process BizTalk Host Groups hosting the Base EDI adapter.
BAM Star Schema Database BAMStarSchema Medium Medium This database contains the staging table, and the measure and dimension tables. BAM Notification Services Application database BAMAlertsApplication Medium Medium This database contains alert information for BAM notifications. For example, when you create an alert using the BAM portal, entries are inserted in this database specifying the conditions and events to which the alert pertains, as well as other supporting data items for the alert. BAM Notification Services Instance database BAMAlertsNSMain Medium Medium This database contains instance information specifying how the notification services connect to the system that BAM is monitoring. List of Windows SharePoint Services Databases The following is the list of SQL Server databases used by Windows SharePoint Services. Data store name Default database name Volume Growth Description Windows SharePoint Services configuration database User-defined Low Low This database contains all of the global settings for the server.