Sep
3
Written by:
PaulEdwards
Friday, September 03, 2010 2:02 PM
The following stored procedure call failed: " { call [dbo].[bts_ProcessHeartbeat_BizTalkServerIsolatedHost]( ?, ?, ?)}".
I ran into this issue today and it’s the second time this has burned me. It didn’t take as long to figure out this time, but hopefully typing this up will ingrain it into my brain further.
The full text of the error message that gets added to the event log is as follows:
The following stored procedure call failed: " { call [dbo].[bts_ProcessHeartbeat_BizTalkServerIsolatedHost]( ?, ?, ?)}". SQL Server returned error string: "EXECUTE permission denied on object 'bts_ProcessHeartbeat_BizTalkServerIsolatedHost', database 'BizTalkMsgBoxDb', schema 'dbo'.".
And 3 or 4 of these exact same event log entries are added every second.
So what causes this you ask? Well this error occurs when you have set up a virtual directory in IIS for an HTTP Receive Adapter in BizTalk, but the Application Pool’s identity is not a member of the BizTalk Isolated Host Users or BizTalk Application Users security group.
Easily done when you set up a virtual directory quickly and don’t realise that it’s using the “Default App Pool” with the identity of “Network Service” or similar. Something you do thousands of times but just forget.
Hopefully this gets crawled and becomes of use to someone later on.