Hi All,

one of our Host Instances not starting i could see in the event viewer the below error

The following stored procedure call failed: " { call [dbo].[bts_ProcessHeartbeat_ReHost]( ?, ?, ?)}". SQL Server returned error string: "Could not find stored procedure 'dbo.bts_ProcessHeartbeat_ReceiveHost'.".

There were other errors like messageboxDB not avaliable

but we can connect to messageboxDB and connect to instance not sure why only this host instance is not starting.

Any Suggestions on the above?

Straight forward error.

There seems to be issue in your BizTalk processing server connecting to your BizTalk database/ server (SQL database where BizTalk related databases are configured) Check the connectivity between your BizTalk and SQL server.

This stored procedure "dbo.bts_ProcessHeartbeat_<<HostInstanceName>>' is called whenever you start the host instance and your error says it can't find the stored procedure when you try to start your HostInstance-ReceiveHost.

Also check for basic things like firewall getting enabled on the hosts (both the BizTalk Frontend and the SQL backend), changes in MSDTC configurations or MSDTC connectivity.

Is the Enterprise SSO running?

Regards.