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:
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_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:
System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'adm_OtherDatabases',
database 'BizTalkMgmtDb', schema 'dbo'.
'BizTalkDBVersion', database 'BizTalkMgmtDb', schema 'dbo'.
You can grant select permission to BizTalk administrators role by following these procedures:
Open SQL Server Management Studio
- Expand BizTalkMgmtDb Tables
- Right click on adm_OtherDatabases table and select Properties
On the permission tab, click Search
On the “Select user or Roles” window, click Browse
select BTS_ADMIN_USERS and click OK
- Make sure SELECT check box is selected in the bottom pane. It should look as shown below.
- Follow the same procedure from 1 to 7 for adm_Server2HostMapping, adm_ServiceClass table