We are using MSDTC to perform distributed transactions
between our application
server (A) and a database server (B). Application server
is running windows 2000 with IIS 5 while database server
is running

winnt 4 SP6 with SQL 7.0 SP3. These severs are separated
by a firewall, but no NAT. To test the functionality of
the

application we opened all ports on the firewall (from the
application server to the database server and viceversa).

The problem is with MSDTC. Infact the application works
fine, except when a transaction is performed to update
records on the

db.
We tested for connectivity with Dtcping.exe with no errors
and a full connectivity trace between the two servers.
The application works fine if we put the db on a database
server in the same LAN of the application server.

Any hints appreciated,
regards, pacho baratta

I believe you need NetBIOS name resolution for DTS to work correctly, so you
try either WINS or LMHOSTS that cover both sides of the FW.


--
Darren Green
http://www.sqldts.com

"Pacho Baratta" <p.baratta (AT) datasiel (DOT) net> wrote

lmhosts is already correctly compiled.

See http://support.microsoft.com/default...b;EN-US;250367
And http://support.microsoft.com/default...b;en-us;306843

GertD (AT) SQLDev (DOT) 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-2003 All rights reserved.

"pacho baratta" <anonymous (AT) discussions (DOT) microsoft.com> wrote

In message <024001c3d9b6$308b32d0$a001280a (AT) phx (DOT) gbl>, pacho baratta
<anonymous (AT) discussions (DOT) microsoft.com> writes
What is the error message?

Have you searched the KB?

DTC errors are a nightmare in my experience, and you've already had my
best guess.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org