Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-12 : 07:18:49
|
| Alun writes "HiNow 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 SP3The 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 pleaseRegards & thanksAlun" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-12 : 08:36:10
|
| Read the part about configuring DTC here:http://weblogs.sqlteam.com/derrickl/archive/2005/12/04/8484.aspxAlso, 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).MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
bakerjon
Posting Yak Master
145 Posts |
|
|
|
|
|
|
|
MS DTC unable to communicate with MS DTC on a remote system