Problems with linked server

I have a linked server that is giving consistent errors when I attempt to
define a new view based on it. The error message is:
ADO error: [OLE/DB provider returned message: New transaction cannot enlist
in the specified transaction coordinator.] OLE DB error trace [OLE/DB
Provider 'SQLOLEDB' ITransactionJoi...
Join Transaction returned 0x8004d00a].
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
The server was set up via sp_addlinkedserver, security is via a dedicated
account added with sp_addlinkedsrvlogin, and the collation compatible and
data access options set via sp_serveroption. Existing views, procedures and
functions work; but if I attempt to modify an object or create a new one, I
get the error above.
The linked server is on a separate domain which trusts the domain from which
it is being linked, but the reverse trust is not set.
Any help would be most appreciated.
Thanks,
JohnJust an update on the problem. I searched the kb and came up with several
topics which looked reasonable, most of which had to do with firewalls. Both
the "servers" have firewalls installed, one is open from within our subnet,
the other is just the Microsoft ICF that shipped with XP (the second server
is my workstation with SQL Developer Edition).
Disabling the firewall fixed the issue, but is not a solution. I have poked
what I hope are the fewest number of holes through it to keep things
working, a small set of ports for DTC and the RPC End Point Mapper. If
anyone has the definitive list of ports that need to be open, I would
appreciate it.
Regards,
John
"John K" <jkraeck@.NOprincetonSPAM.edu> wrote in message
news:eKkXo%23UrDHA.2244@.TK2MSFTNGP12.phx.gbl...
> I have a linked server that is giving consistent errors when I attempt to
> define a new view based on it. The error message is:
> ADO error: [OLE/DB provider returned message: New transaction cannot
enlist
> in the specified transaction coordinator.] OLE DB error trace [OLE/DB
> Provider 'SQLOLEDB' ITransactionJoi...
> Join Transaction returned 0x8004d00a].
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction.
>
> The server was set up via sp_addlinkedserver, security is via a dedicated
> account added with sp_addlinkedsrvlogin, and the collation compatible and
> data access options set via sp_serveroption. Existing views, procedures
and
> functions work; but if I attempt to modify an object or create a new one,
I
> get the error above.
> The linked server is on a separate domain which trusts the domain from
which
> it is being linked, but the reverse trust is not set.
> Any help would be most appreciated.
> Thanks,
> John
>