Error deploying BAM definition with aggregations

Posted: July 9, 2010  |  Categories: BizTalk Uncategorized
Tags: BAM BizTalk

I just got caught by this one.

D:\Projects\ProBAM\Apress.ProBAM2009\Apress.ProBAM2009.Publishing.BAM\BAMDefinit
ionfiles>bm deploy-all -definitionFile:awo.xml
Microsoft (R) Business Activity Monitoring Utility Version 3.8.368.0
Copyright (C) 2006 Microsoft Corporation.  All rights reserved.

Using ‘BAMPrimaryImport’ BAM Primary Import database on server ‘BTS09’…

Deploying Activity… Done.
Deploying View… ERROR: The BAM deployment failed.
OLE DB error: OLE DB or ODBC error: Cannot open database “BAMPrimaryImport” requ
ested by the login. The login failed.; 42000.
Errors in the high-level relational engine. A connection could not be made to th
e data source with the DataSourceID of ‘bam_rta_OrderStatus’, Name of ‘bam_rta_O
rderStatus’.
Server: The operation has been cancelled.

This has been answered before here. Once I found the required user was NTAUTHORITY/NETWORK SERVICE in the SQL server logs. I added it as a user of the BAMPrimaryImport database.  I then got this;

D:\Projects\ProBAM\Apress.ProBAM2009\Apress.ProBAM2009.Publishing.BAM\BAMDefinit
ionfiles>bm deploy-all -definitionFile:awo.xml
Microsoft (R) Business Activity Monitoring Utility Version 3.8.368.0
Copyright (C) 2006 Microsoft Corporation.  All rights reserved.

Using ‘BAMPrimaryImport’ BAM Primary Import database on server ‘BTS09’…

Deploying Activity… Done.
Deploying View… ERROR: The BAM deployment failed.
OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the obje
ct ‘bam_OrderStatus_PivotTable3_RTATable’, database ‘BAMPrimaryImport’, schema ‘
dbo’.; 42000.
Server: The operation has been cancelled.

I gave that user db_datareader role membership and everything worked. Why this account?

turbo360

Back to Top