title: Linked Server related
body: <p>I have two instances of SQL Server:</p>
  
  <ul>
  <li>Server1 (SQL Server 2008)</li>
  <li>Server2 (SQL Server 2005)</li>
  </ul>
  
  <p>I am executing a stored procedure from Server1 which references tables on Server2.</p>
  
  <p>It is working fine in my test environment:</p>
  
  <ul>
  <li>Server1 runs Vista SP2, SQL Server 2008;</li>
  <li>Server2 runs Windows XP SP2, SQL Server 2005.</li>
  </ul>
  
  <p>However, it is not working in the production environment:</p>
  
  <ul>
  <li>Server1 runs Vista SP1, SQL Server 2008;</li>
  <li>Server2 runs Windows XP SP2, SQL Server 2005.</li>
  </ul>
  
  <p>The error message I receive is:</p>
  
  <blockquote>
    <p>OLE DB provider "SQLNCLI10" for linked server "Server2" returned message "No transaction is active.".<br>
    Msg 7391, Level 16, State 2, Line 21<br>
    The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "Server2" was unable to begin a distributed transaction.</p>
  </blockquote>