Thursday, June 13, 2013

Microsoft.BizTalk.ExplorerOM.PermissionException in BizTalk 2013

Testing our automatic BizTalk application installer framework today against a newly installed BizTalk 2013 group failed. I  was getting the exception:

Microsoft.BizTalk.ExplorerOM.PermissionException: Error in the application

Running the BizTalk Server Administration Console using the same (service)account as for my failing installer I got this similar error:

Failed to load Group […BizTalkMgmtDb] data providers. (Microsoft.BizTalk.Administration.SnapIn)


Connecting to ExplorerOM failed. (Microsoft.BizTalk.SnapIn.Framework)
Error in the application. (Microsoft.BizTalk.ExplorerOM)

 

Running SQL Profiler I found this User Error Message:

The SELECT permission was denied on the object 'bts_dynamic_sendport_handlers', database '…, schema 'dbo'.

Granting these permissions (inspired by other working installations) on the table 'bts_dynamic_sendport_handlers' fixed the problem:

USE

[BizTalkMgmtDb]

GRANT SELECT, INSERT, DELETE, UPDATE ON [dbo].[bts_dynamic_sendport_handlers] TO [BTS_ADMIN_USERS]

GRANT SELECT ON [dbo].[bts_dynamic_sendport_handlers] TO [BTS_OPERATORS]

GRANT SELECT ON [dbo].[bts_dynamic_sendport_handlers] TO [BTS_HOST_USERS]

Apparently this is well known (but not easily Googled):
In my case, I had deleted all databases of a previous BizTalk 2010 installation, but still I got this problem, which in the first reference above is described as an upgrade related issue.

7 comments:

21st Century Software Solutions said...

Biztalk Admin Online Training
http://www.21cssindia.com/courses/biztalk-admin-online-training-220.html
For Inquiry - contact@21cssindia.com - +919000444287
Overview

What is Business Process?
Need to Integrate
What is Integration?
Challenges without Integration
Challenges in Business Integration

BizTalk Server

Other Products available in Market
Comparison of BizTalk with Tibco, Web methods & SAP PI
Comparison of BizTalk with SSIS and WPF

21st Century Software Solutions said...

Biztalk Admin Online Training - http://www.21cssindia.com/courses/biztalk-admin-online-training-220.html
Overview - What is Business Process? - Need to Integrate - What is Integration? - Challenges without Integration - Challenges in Business Integration - BizTalk Server - Other Products available in Market - Comparison of BizTalk with Tibco, Web methods & SAP PI - Comparison of BizTalk with SSIS and WPF - Employees to learn at their own pace and maintain control of learning “where, when and how” with boundless access 24/7by 21st Century Software Solutions. contact@21cssindia.com ---- Call Us +919000444287

comettech said...

Nice Blog and thanks for sharing your information we are also providing online training on once have a look http://www.keentechnologies.com/sap-hcm-online-training.html

Unknown said...

Good post. keep sharing such a informative post.

web designing training in chennai

Unknown said...

Excellent post! keep sharing such a useful post.


web design training in chennai

divi said...

Nice article you have posted here. Thank you for giving this innovative information and
please add more in the future.web design company in velachery

arshiya said...

Amazing article, Really useful information to all, Keep sharing more useful updates.
data science skills
latest new technologies
ccna job opportunities
courses with guaranteed jobs
cyber security interview questions pdf
java interview questions and answers for freshers