Linked Servers SQL2000 and SQL7.0 on different Domains ???

[Bernadette]

Hi There

Can anybody give me any advice. Is it possible to have a Main server "ServerA" on a Windows2000 domain with a linked server set up "ServerB" on a WindowsNT domain.

Can I run Distributed Transactions on this server ?

When I try I constantly get this message

Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider SQL OLEDB was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]


Does anybody know if this is possible ???? Bernadette

 

[MAK9974]

Try this

1. make sure RPC in and RPC out are checked
2. use "set XACT_ABORT ON" before any query


then run the query

select a.col1,b.col2 from server.db.dbo.tb1 a,
server.db.dbo.tb2 b

 

[Bernadette]

Thank you very much for answering.

I tried that but it didnt help. I still get the error. It works okay if the servers are on the same domains but the servers I want to use are not of the same domains.

Do I have to wrap up the distributed transactions inside a stored proc ?

Bernadette