February 9, 2009 at 1:41 pm
Hi
While issuing a remote select query I am getting the error.
Server: Msg 8501, Level 16, State 1, Line 1 MSDTC on server 'VKOCMEDB504' is unavailable. Server: Msg 7391, Level 16, State 1, Line 1 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d01c].
both servers are windows 2000 and sql 2000.Kindly help
February 10, 2009 at 12:40 am
Hello,
Check if the DTC Services is started, that can be a potential Issue.
Regards,
Sriram
February 10, 2009 at 12:58 am
Hi,
Make MS-DTC to run with "NT Authority\NetworkService" in both the source and destination servers.
Please refer to solution 2 and 3 section in this article for more details. You can also try some tools in this link to troublshoot MS DTC problems.
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
February 10, 2009 at 7:17 am
There are a few things to try with this.
1. Check MSDTC within Component Services and be sure that you have it set to Allow Remote Clients.
2. Within Add/Remove Programs --> Add/Remove Windows Components --> Application Server --> Details, verify that Enable Network DTC access is checked. If not check it, click OK, Next etc...to install that piece (does not require reboot).
3. If both of those are turned on and should be working from a command prompt trying uninstalling and reinstalling msdtc. This is done by running
msdtc -uninstall
msdtc -install
Once all of those things have been handled try running your transaction again.
If you are running within a cluster, try all of those things and then if it still does not work then try moving the Group that MSDTC is contained in over to a different node.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply