Linked Server needed after BizTalk SP2 installation

After installing SP2 of BizTalk 2004 you receive an error in the 'TrackedMessages_Copy_BizTalkMsgBoxDb' SQL job :






Executed as user: INT\s_sqlidb. Could not find server 'VIRIDBTTR\BIZTALKTRACKING' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. [SQLSTATE 42000] (Error 7202) An error occurred while inserting data in the Tracking_Parts1 table [SQLSTATE 42000] (Error 50000). The step failed.


If you have your MsgBoxDb & DTADb on seperate SQL Instances installed and you install SP2 of BizTalk 2004 you need to add a linked server from the MsgBoxDb SQL instance to the DTADb SQL instance :

Make sure you choose 'be made using the login's current security context' on the security tab. Leave the rest by default.

Without having that job run correctly you will not be able to save any message body from HAT !