How to Add Accounts to a View
Administrators use the add-account command to associate users with BAM views and protect BAM Excel Spreadsheet views from unauthorized access. When users save BAM views, the views reference a SQL connection string that is hidden within the workbook. The workbook is protected, but you must ensure that the document is protected.
When you associate users with BAM views, you restrict access to the views to only the users or groups to whom you grant access.
Important
If you are using real-time aggregations (RTAs), users added with add-account are not automatically granted logon rights to the computer running SQL Server. If you are using RTAs, consider establishing a Windows user group that contains all of the users that need to see views of the RTAs. Grant that group explicit SQL Server logon rights on the SQL server hosting the BAM Primary Import database.
For information about viewing BAM views, see How to List BAM Views.
To add an account to a view
Open a command prompt as follows: Click Start, click Run, type cmd, and then click OK.
Navigate to the tracking folder by typing \Program Files (x86)\Microsoft BizTalk Server <VERSION>Tracking at the command prompt. Press ENTER.
Type bm add-account -AccountName:<account name> -View:<view name>.
Note
On a system that supports User Account Control (UAC), you may need to run the tool with Administrative privileges.
Press ENTER.
See Also
Managing the BAM Dynamic Infrastructure
BAM Management Utility