Unable to enlist in transaction
-
Hi there,
I have a DTS package which is setup to join a transaction if present (on all package steps) and to rollback on failure (again on all package steps)
I am trying to run this DTS package with a set of Data transformation tasks, between a Windows 2000 server/Sql Server 2000 and another Windows 2000 server/Sql Server 2000.
Both machines have MSDTC service started.
When I try and run the DTS package using the designer, or DTSRunUI (With Global vars populated) the very first item fails and states "Unable to enlist in transaction" - "New transaction cannot enlist in the specified transaction coordinator".
I have found numerous threads based on tweaking Windows Server 2003 to fix this, but nothing for Windows 2000.
I'm really a .NET developer and not a DBA, so im not sure where to look next.
Any help greatly appreciated!
Matt
-
We had similiar issues between or Windows 2000 and Windows 2003 servers. Can you check the configuration settings on the servers and tell us what they are? Programs -> Administrative Tools -> Component Services
From there: Expand Computers, My Computer
right click My Computer -> Properties
Thanks,
-
Remote server is set to use local co-ordinator, no remote host specified (greyed out)
client network protocol TCP/IP
service started (ver 3.00.00.3535)
LOCAL server is the same, except the MSDTC minor version is not the same (3.00.00.3511) - would that pose a problem?
if I try and execute this t-sql:
begin distributed transaction
select *
from [remoteserver].[master].[dbo].[sysfiles]
commit
I get the following:
Server: Msg 7202, Level 11, State 2, Line 2
Could not find server 'PNSQL01\DEV' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Does this mean the servers have to be setup as linked servers in order for any DTC stuff to work?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply