BAM Web Services Event Provider: The BAM Portal cannot connect to the BAM Primary Import database

Microsoft.BizTalk.Server.2016.BAMPortalCannotConnectToPrimaryImportDB (Rule)

The BAM portal cannot connect to the BAM Primary Import database.

Knowledge Base article:

Summary

Incorrect logon account used for connecting to Primary Import database.

Causes

The BAM Web services account may not have permissions to the BAM Primary Import database in the SQL server.

Resolutions

Try connecting to the SQL server using SQL client tools and the BAM WS user credentials to verify if the user account has access privileges to connect to the BAM Primary Import database. You can determine the BAM WS user account by running the BizTalk Configuration tool and the account will be in the BAM Portal section. You can also use the BizTalk configuration tool to change the BAM WS account.

Configuration

Not Available

Additional

Not Available

External

Not Available

Element properties:

Target

Microsoft.BizTalk.Server.2016.BizTalkRuntimeRole

Category

EventCollection

Enabled

True

Event_ID

1534

Alert Generate

True

Alert Severity

Error

Alert Priority

High

Remotable

True

Alert Message

SERVICE UNAVAILABLE: BAM portal cannot connect to BAM Primary Import database - login failed

{0}

Event Log

Application

Member Modules:

ID	Module Type	TypeId	RunAs
Microsoft.BizTalk.Server.2016.BAMPortalCannotConnectToPrimaryImportDB.DataSource	DataSource	Microsoft.Windows.EventProvider	Default
GenerateAlert	WriteAction	System.Health.GenerateAlert	Default
WriteToDB	WriteAction	Microsoft.SystemCenter.CollectEvent	Default
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishEventData	Default

Source Code:

<Rule ID="Microsoft.BizTalk.Server.2016.BAMPortalCannotConnectToPrimaryImportDB" Enabled="true" Target="BTSLib!Microsoft.BizTalk.Server.2016.BizTalkRuntimeRole" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="Microsoft.BizTalk.Server.2016.BAMPortalCannotConnectToPrimaryImportDB.DataSource" TypeID="Windows!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Property[Type="BTSLib!Microsoft.BizTalk.Server.2016.ServerRole"]/ComputerName$</ComputerName>

      <LogName>Application</LogName>

      <Expression>

        <And>

          <Expression>

            <Or>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

                    <XPathQuery Type="String">PublisherName</XPathQuery>

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value Type="String">BAM Web Service</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

                    <XPathQuery Type="String">PublisherName</XPathQuery>

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value Type="String">BAMWebServices</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

            </Or>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value Type="UnsignedInteger">1534</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectEvent"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishEventData"/>

    <WriteAction ID="GenerateAlert" TypeID="Health!System.Health.GenerateAlert">

      <Priority>2</Priority>

      <Severity>2</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.BizTalk.Server.2016.BAMPortalCannotConnectToPrimaryImportDB.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDescription$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue>$Target/Property[Type="BTSLib!Microsoft.BizTalk.Server.2016.ServerRole"]/ComputerName$</SuppressionValue>

        <SuppressionValue>$Data/EventDisplayNumber$</SuppressionValue>

        <SuppressionValue>$Data/PublisherName$</SuppressionValue>

      </Suppression>

      <Custom1>BAM Alerts</Custom1>

    </WriteAction>

  </WriteActions>

</Rule>