January 27, 2009 at 6:48 am
Hi All
I have deployed one script to check agent status on my centralized monitoring server. Now the script is runing fine for all the servers runnig on windows server 2003 but the server that have windows 2000 server installed on them fails to run this. It throws error :
Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "server" was unable to begin a distributed transaction.
I have started MSDTC services from ( Component servives -- > MSDTC)
Can you please suggest.
January 27, 2009 at 7:48 am
A few things to try and you will invariably have to check this on both the server connecting and the server you are connecting to.
First go to Add/Remove Programs-->Add/Remove Windows Components. Select Application Server and select Details. Verify that Network DTC Access is checked. Try your process again.
If that does not work...
From a command prompt run "msdtc -uninstall"
followed by "msdtc -install"
Try process again.
If that doesn't work..
Check Administrative Tools --> Component Services-->Computer-->My Computer. Right click on My Computer and select Properties. On the MSDTC tab click Security configurations and be sure this is set up for Network access.
That is all I have for you.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply