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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  'SQLOLEDB' unable to begin a distributed transacti

Author  Topic  myforum Starting Member 4 Posts Posted - 2009-04-10 : 09:53:35 Hi, Iam trying to update a database in a server from another database which is in another server using linked server. However iam facing an error as below [Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. Both machines are using sql server 2000 on windows server 2003 SP2. I enabled the network DTC access on both machines but still getting the error. Any suggestions are highly appreciated . Thanks in advance