SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 MS DTC unable to communicate with MS DTC on a remote system
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 12/12/2005 :  07:18:49  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Alun writes "Hi

Now I know this subject has been discussed at some length before, but after reading through all the papers, forums, etc, I still cannot find a solution to my problem.

The error I am getting is:
MS DTC is unable to communicate with MS DTC on a remote system. No common protocol is supported between the 2 systems, et al.

Here is the config:
Cluster Server: Win 2003 Std Edition
SQL Server (both instances on same cluster node): 2K with SP3

The script is running on Instance A & accesses table data on Instance B thru a linked server. Script runs ok in QA, but thru a scheduled task it fails, with the above error in the Event Log.

Obvious answers to obvious questions:
MSDTC is configured (allowing network DTC access, etc) & running using 'Network Service' account.
COM+ is installed.
Table structure & SP are correct.


Help if you can please
Regards & thanks
Alun"

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts

Posted - 12/12/2005 :  08:36:10  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message  Reply with Quote
Read the part about configuring DTC here:

http://weblogs.sqlteam.com/derrickl/archive/2005/12/04/8484.aspx


Also, make sure you have a network path setup between the two servers with the needed TCP/IP or UDP ports (depending on what kind of network ports you have configured on the SQL Server for remote access).

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

bakerjon
Posting Yak Master

USA
145 Posts

Posted - 12/12/2005 :  09:24:55  Show Profile  Visit bakerjon's Homepage  Reply with Quote
What authentication you are using? If you have Windows 2003 SP1 (I don't notice it in your list above), the default security on MS DTC is Windows auth only. If you are using SQL authentication, you will have to knock that down. See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48061&SearchTerms=MS,DTC for details on how to do that.



Jon
-Like a kidney stone, this too shall pass.

http://www.sqljunkies.com/weblog/outerjoin
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000