dbTalk Databases Forums  

Distributed Transactions across Linked Servers

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Distributed Transactions across Linked Servers in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tim - Milwaukee
 
Posts: n/a

Default Distributed Transactions across Linked Servers - 02-06-2008 , 08:26 AM






Hello.

One of our database developers is running into a problem when trying
to get distributed transactions to work across linked servers. (SQL
2005 to SQL 2000).

The specific error message is:

"Msg 8501, Level 16, State 3, Procedure _Test2, Line 12 MSDTC on
server 'MSDB02' is unavailable."

I've check to confirm that the DTC service is running on both
machines. We've read over these article/discussions:

http://www.thescripts.com/forum/thread82878.html
http://www.google.com/search?q=MSDTC...is+unavailable


Any suggestions on what we can do to trouble-shoot this?

Thank you.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.