BizTalk360 makes direct query to some of the BizTalk management database for performance reasons. The following tables by default would not have enough permissions even for a BizTalk Administrator role. For proper functioning of BizTalk360, it is important to assign “SELECT” permission to the following tables in the BizTalkMgmtDb:

  • adm_OtherDatabases
  • adm_Server2HostMapping
  • adm_ServiceClass
  • BizTalkDbVersion


You can give permission either by running the following script on the BizTalk management database or by using the SQL Management Studio:

GRANT SELECT ON dbo.adm_OtherDatabases TO BTS_ADMIN_USERS
GRANT SELECT ON dbo.adm_Server2HostMapping TO BTS_ADMIN_USERS
GRANT SELECT ON dbo.adm_ServiceClass TO BTS_ADMIN_USERS
GRANT SELECT ON dbo.BizTalkDbVersion TO BTS_ADMIN_USERS


You may encounter the following error messages in the UI:


The SELECT permission was denied on the object 'adm_OtherDatabases', database 'BizTalkMgmtDb', schema 'dbo'.

System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'adm_OtherDatabases', 

database 'BizTalkMgmtDb', schema 'dbo'.


Unable to Save. The SELECT permission was denied on the object
'BizTalkDBVersion', database 'BizTalkMgmtDb', schema 'dbo'.


You can grant select permission to BizTalk administrators role by following these procedures:

  1. Open SQL Server Management Studio
  2. Expand BizTalkMgmtDb Tables
  3. Right click on adm_OtherDatabases table and select Properties 
  4. On the permission tab, click Search 
  5. On the “Select user or Roles” window, click Browse 
  6. select BTS_ADMIN_USERS and click OK
  7. Make sure SELECT check box is selected in the bottom pane. It should look as shown below.
  8. Follow the same procedure from 1 to 7 for adm_Server2HostMapping, adm_ServiceClass table