BizTalk Server: Cannot see my BAM View in BAM Portal after I deploy it

It´s a common factor that before users can view data from a BAM model in the BAM Portal website, they must be granted access to the views. However, and contrary to what I thought, the user that makes the deploy of the BAM Definition don’t necessarily have access to this particular view in the BAM Portal! (I was being misled because usually, I am the owner… hehe)

Instead, the only user that always has access to the view and cannot be added to or removed from the view(s) is the Database Owner (BAMPrimaryImport)!

You can check who the database owner is by running the following query:

SELECT SUSER_SNAME(owner_sid),name
FROM sys.DATABASES

So after I run this query I realize that another user was the owner and to solve this “problem” I had to give permissions to my user to access this View in BAM Portal by running the following BAM Management Utility command:

bm.exe add-account -AccountName:DOMAIN\USER -View:MyView

Mystery solved

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community. View all posts by Sandro Pereira