Connected Pawns

January 9, 2012

Cannot open log for source ‘BizTalk ESB Toolkit 2.1′

Filed under: BizTalk — Tags: , — mbrimble @ 12:09 pm

I have  installed the ESB Management Console on a server that does not have Visual Studio installed and I got this error when I tried to open the ESB Management Console on the local host.

http://social.msdn.microsoft.com/Forums/ar-SA/biztalkesb/thread/16f6fcbe-ffd6-4fbf-a92f-a97726292256 talks about the same error but none of the solutions in this thread solved my problem.

Eventually I discovered that if i added the http://local host to my local intranet sites the ESB management console now displays without error.

Now if I try open site from a browser that is not on the local server, I get challenged and enter the credentials for the same user as above then I get the same error. In this case adding the http://<server> to the intranet or trusted sites does not solve the issue. What is really weird is that if I enter credentials for the administrator who installed the server then the the ESB Management Console is displayed

I decided that I was not seeing the real error because the user cannot write the error to the event log on the web server. I gave this user full access to the event log by running the following from a command prompt where the bolded text is the the SID of my user.

C:\Windows\system32>wevtutil sl Application /ca:O:BAG:SYD:(A;;0xf0007;;;SY)(A;;0×7;;;BA)(A;;0×7;;;SO)(A;;0×3;;;IU)(A;;0×3;;;SU)(A;;0×3;;;S-1-5-3)(A;;0×3;;;S-1-5-33)(A;;0×1;;;S-1-5-32-573)(A;;0×3;;;S-1-5-21-1832726700-257789682-1899323428-1000)

Now I see the following error written to the event log;

Access denied

Source: Microsoft.Practices.ESB.BizTalkOperations.BizTalkQuery

Method: Void .ctor()

Error Source: System.Management

Error TargetSite: Void ThrowWithExtendedInfo(System.Management.ManagementStatus)

Error StackTrace:    at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.Practices.ESB.BizTalkOperations.BizTalkQuery.GetMsgboxServerInfo()
at Microsoft.Practices.ESB.BizTalkOperations.BizTalkQuery..ctor()

What permissions or policy am i missing?

http://qa.social.msdn.microsoft.com/Forums/en-US/biztalkesb/thread/2a1519c1-bab3-40fb-a645-a7e54f606b22 describes a workaround where you put the username password in tot he web.config but thus is just hiding the problem. I want to find out what permission or setting is missing.

Advertisement

1 Comment »

  1. Its because the App Pool that the BizTalk operation service runs on doeesnt have access to few tables in the BizTalkMessageBox and perhaps BizTalkMgmt database. I had a similar issue with permissions missing for the user and he didnt belong to the BTS_Admin_USER in BiztalkMgmt database. The easiest way to figure this out is to run your SQL profiler and see which tables and db’s are being accessed when you run through this. Run the ESB code in Debug mode.

    Comment by Suresh Gladstone — February 16, 2012 @ 12:58 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Theme: Silver is the New Black. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.