Error USING ALIAS: New transaction cannot enlist in the specified transaction

• cordless2

  SSC Enthusiast

  Points: 105

  More actions

  March 14, 2007 at 1:21 pm

  #171636

  Hello,

  I'm running W2003 SP1 with SQL Server 2000 Enterprise SP4 in two servers (named 'server1' and 'server2') with both MSDTC network access (kb article 817064) and XA enabled (at msdtc config). We get the following error when trying a distributed transaction from server1 in which server2 name is an alias:

  Server: Msg 7391, Level 16, State 1, Line 3

  The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

  [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

  OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

  The sentence we are executing is something like that:

  set xact_abort on

  begin distributed tran

  insert into aliasserver2.northwind.dbo.testtable values ('test')

  commit tran

  'Aliasserver2' is an alias for 'server2' created on server1 client netwok utility and configured as a linked server on server 1 as well. We get the same error if we use the word 'distributed' or not.

  If we replace 'aliasserver2' with 'server2' (which is the real server name), it works ok (so it seems msdtc to be correctly configured in the two servers). But we need to use the alias for other reasons. But it doesn't work with the alias

  So, is it possible to make a distributed transaction using an alias as a server name???

  Thank you all for your collaboration...