Very Computer

I have three SQL Server 7.0. A, B and C. I have script from Server A to
query the linked server B.db.dbo.table and use

begin transaction aaa
then do some work and then
commit transaction aaa.

It is running OK to run against on server B.db.dbo.table, recordset
returned. But when running the same script from same server A to query
Server C.db.dbo.table, then returns message 'MSDTC on server 'C' is
unavailable'
I check three server's MSDTC service is running. I restarted it. And They
are all in same version and Service Pack.
Anyone know what's happen? Please help
Thanks!

Hi there,

Could you check if the name resolution works. Can you ping by both ip and
name from Server A to Server C. Is there a firewall between Server A and
Server C and are all the ports open for DTC communication and SQL
communication, Are RPC services started on both machines. Also could you
test  the query with set xact_abort on. Also the complete and exact error
message would be of great help.

Hope this helps,

Thanks.

"This posting is provided AS IS with no warranties, and confers no
rights."

Hi there,

Thanks for the info!
There is no problem to ping name and IP between A and C server. And also
there is no firewall between them. RPC services are started on both servers.
And then I set xact_abort on,  but still has the same message below:
Server: Msg 8501, Level 16, State 3, Line 176
MSDTC on server 'SQLGP1' is unavailable.

Thanks for your help!

Jie

Quote:> Hi there,

> Could you check if the name resolution works. Can you ping by both ip and
> name from Server A to Server C. Is there a firewall between Server A and
> Server C and are all the ports open for DTC communication and SQL
> communication, Are RPC services started on both machines. Also could you
> test  the query with set xact_abort on. Also the complete and exact error
> message would be of great help.

> Hope this helps,

> Thanks.

> "This posting is provided "AS IS" with no warranties, and confers no
> rights."