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:

jake george 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

jake george 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

jake george said...

Biztalk Admin Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/biztalk-admin-online-training-220.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Biztalk Admin Online Training, Biztalk Admin Training, Biztalk Admin, Biztalk Admin Online Training| Biztalk Admin Training| Biztalk Admin| "Courses at 21st Century Software Solutions
Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
Visit: http://www.21cssindia.com/courses.html"

Technologies 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

prathap kumar said...

I have read your blog its very attractive and impressive. I like it your blog.

.Net Training in Chennai | .Net Online Training

Online Dot Net Training | Online LINQ Training

Arjun Rishi said...

Good post. keep sharing such a informative post.

web designing training in chennai

Anu Sri said...

Excellent post! keep sharing such a useful post.


web design training in chennai