root transaction wanted to commit, but transaction aborted

• Arnold Magpantay

  Old Hand

  Points: 343

  More actions

  August 10, 2005 at 4:48 am

  #168266

  Hi,

   

  Is there anybody encountered problem when connecting the BizTalk server to MSSQL server? Because I’m currently suffered from this problem, we have a BizTalk server with IP address of 172.x.x.x and MSSQL with IP address of 170.x.x.x. Here are the details of the problem:

   

  Biztalk can “select” in the MSSQL database, but when the transaction wanted to commit, we encountered problem, Please see the event logs

   

  An error occurred in BizTalk Server.

   

   Details:

   ------------------------------

   [0x8004e002] the root transaction wanted to commit, but transaction aborted.

   

  But when we tried to change the IP Address of BizTalk to 170.x.x.x, the transactions are successfully committed, is this network/IP address problem or MSSQL problem?

   

  Thank you.

   

  Regards,

  Arnold

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  August 10, 2005 at 5:59 am

  #580963

  This link might be relevant:

  http://support.microsoft.com/default.aspx?scid=kb;en-us;275847&sd=tech

  ---