| Author |
 Topic  |
|
|
AskSQLTeam
Ask SQLTeam Question
USA
0 Posts |
 Posted - 12/12/2005 : 07:18:49
|
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 |
|
|
bakerjon
Posting Yak Master
USA
145 Posts |
|
| |
Topic |
|
|
|
MS DTC unable to communicate with MS DTC on a remote system
