|
Home > Archive > MS SQL Server Clients > November 2005 > Microsoft Distributed Transaction Coordinator call failed.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Microsoft Distributed Transaction Coordinator call failed.
|
|
| umer.zafar@gmail.com 2005-10-31, 7:23 am |
| 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
| |
| Giuseppe Dimauro 2005-10-31, 1:23 pm |
| try using DTC Ping utility:
http://www.microsoft.com/downloads/...&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@gmail.com> wrote in message
news:1130753487.330720.301200@g43g2000cwa.googlegroups.com...
> 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
>
| |
| umer.zafar@gmail.com 2005-11-01, 3:23 am |
| Giuseppe Dimauro wrote:[color=darkred
]
> try using DTC Ping utility:
> http://www.microsoft.com/downloads/...&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@gmail.com> wrote in message
> news:1130753487.330720.301200@g43g2000cwa.googlegroups.com...
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/defaul...kb;en-us;329332
http://support.microsoft.com/?kbid=839279
| |
| Gert E.R. Drapers 2005-11-14, 3:23 am |
| 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@SQLDev.Net
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@gmail.com> wrote in message
news:1130825745.270346.30400@g47g2000cwa.googlegroups.com...
> Giuseppe Dimauro wrote:
>
> 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/defaul...kb;en-us;329332
> http://support.microsoft.com/?kbid=839279
>
|
|
|
|
|