title: Distribution Transaction Completed - Error - SQL Server 2005
body: <p>Trying to execute a stored procedure to update a certain data warehouse, however when I execute the stored procedure I get an error message stating: </p>
  
  <blockquote>
    <p>error Msg 8525, Level 16, State 1, Line 1 Distributed transaction
    completed. Either enlist this session in a new transaction or the NULL
    transaction</p>
  </blockquote>
  
  <p>After some Googling, it suggested to configure DTC settings, but I have already checked my MSDTC and it is already checked for allowing inbound and outbound for Transaction Manager Communication.</p>
  
  <p>Any ideas to fix it? </p>