Re: DTS Error: Unable to enlist in the transaction

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jupe (jupiterdude_at_hotmail.com)
Date: 12/14/04 

Date: 14 Dec 2004 08:26:46 -0800

I am sure it is SQL server. MSDTC was started, and working. SP level is
8.00.818 (SP3).

It appears to be working when pointing at virtually any other SQL
server in the enterprise. We will be restaging the finicky server ASAP.

Thanks for your input.

-- Jupe

Allan Mitchell wrote:
> Works for me. You are sure the connection is to SQL Server? You are
sure
> MSDTC is started? Are you Service Packed?
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>

Relevant Pages

  • RE: Server: Msg 7391, (..) unable to begin a distributed transaction.
    ... Windows 2003 platform encounter error 7391. ... Secondly, do not make SQL Server startup automatically, restart the ... start MSDTC first and then startup SQL Server manually in both ... b.Start Component Services Administrative Tool. ...
    (microsoft.public.sqlserver.programming)
  • Re: XA error in Beta 2 driver
    ... BEGIN DISTRIBUTED TRANSACTION ... > first call into the XA procedure on the SQL Server side. ... > So for example the you could have the MSDTC service (Distributed Transaction ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: dcpromod cluster node to non-domain controller, now SQL server wont start
    ... MSDTC is the sticking point... ... I set it to full control as per the KB... ... delete MSDTC from within the cluster and then recreate it on the ... with SQL server as I can move groups with just network names, ...
    (microsoft.public.windows.server.clustering)
  • Re: MSDTC doesnt work on SQL 2k in W2k3 cluster environment
    ... First, after reclustering the MSDTC, did you configure it within its own ... dedicated Cluster Resource Group? ... You will then need to take the SQL Server IP resource offline, ... How to enable network DTC access in Windows Server 2003 ...
    (microsoft.public.sqlserver.clustering)
  • Re: msdtc is causing my cluster to be unavailiable via its virtua
    ... Anthony i think you might have been right about the DNS registration, ... for some reason it didnt go through but i just tried failing over the MSDTC ... > I see that the IP in the SQL Server cluster resource group is named SQL IP ...
    (microsoft.public.sqlserver.clustering)