Re: Microsoft Distributed Transaction Coordinator call failed.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Also I would not invest in DB-Lib code, since this is a dead API and does
not provide access to the full feature set of SQL Server 7.0, 2000 or 2005.
Use ODBC or OLE-DB instead. See http://sqldev.net/misc/DTCTest.htm for a
small test program, including some source that you can use.

GertD@xxxxxxxxxx

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.

<umer.zafar@xxxxxxxxx> wrote in message
news:1130825745.270346.30400@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Giuseppe Dimauro wrote:
>> try using DTC Ping utility:
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=5e325025-4dcd-4658-a549-1d549ac17644&DisplayLang=en
>>
>> if pinging is ok and trouble persists check security. If machines are on
>> different systems AND different domains disable RPC Security (restart
>> machines before testing). But it's better if you do all the stuff with
>> security enabled.
>>
>> Giuseppe Dimauro
>> MSDN Regional Director, Italy
>> http://wwww.dotnet2themax.com
>>
>>
>> <umer.zafar@xxxxxxxxx> wrote in message
>> news:1130753487.330720.301200@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> > hi...
>> > I am trying to run MS DTC sample application (dblib) equipped
>> > with MS SQL Server 2000.I am using following commnd line to
>> > link SQL Servers on two different systems
>> >
>> > "dblib -s1 abc -u1 administator -p1 password1
>> > -s2 xyz -u1 sa -p1 password2 "
>> >
>> > Server 1: my PC (OS Xp)
>> > Server 2: Remote PC (OS Win2k3)
>> >
>> > But this gives following ERROR:
>> >
>> > DB-LIBRARY error:
>> > Microsoft Distributed Transaction Coordinator call failed.
>> > Operating system error:
>> > Microsoft Distributed Transaction Coordinator call failed.
>> > dbenlisttrans() failed: 0
>> >
>> > Probably remote PC is (why) not enlisted when it calls
>> > "Enlist(&gSrv2,dbproc_server2,pTransaction);"
>> >
>> > Suggestions are highly appreciated to resolve this problem
>> > Thanks in advance
>> > Umer
>> >
>
> Hi..Thanks a lot..DTCPing really helped me to discover more..well
> following two links (referred by Tony Rogerson SQL Server MVP) helped
> me to get even more close to my solution. It is hoped, these links will
> save time of others.
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;329332
> http://support.microsoft.com/?kbid=839279
>


.

Relevant Pages

  • Re: Microsoft Distributed Transaction Coordinator call failed.
    ... if pinging is ok and trouble persists check security. ... machines before testing). ... > with MS SQL Server 2000.I am using following commnd line to ... > Microsoft Distributed Transaction Coordinator call failed. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)
  • Re: Getting to the bottom of MSDE network connection problems ...
    ... Brilliant, Nick, especially the explanation for local network user being ... authenticated as GUEST in WinXP SP2. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ... > again and selected the security tab. ...
    (microsoft.public.sqlserver.msde)
  • RE: Login failed for user (null).
    ... used at signon to authenticate in SQL Server. ... connect the remote SQL Server database), is there any other data accessing ... What's the security identity used to access the remote SQL Server, ... the worker process identity. ...
    (microsoft.public.dotnet.framework.aspnet.security)