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 |
|
myforum
Starting Member
4 Posts |
 Posted - 2009-04-09 : 10:39:04
|
| Hi, We are 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 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-04-09 : 11:19:42
|
| You need to go into the options on the linked server and ensure that RPC is enabled. |
 |
|
|
myforum
Starting Member
4 Posts |
Posted - 2009-04-09 : 11:33:47
|
Thank u very much for ur reply RickDIn serveroptions of linkedserver,i already enabled the RPCStill same error.But how can we know that RPC is working fine.quote:
Originally posted by RickD
You need to go into the options on the linked server and ensure that RPC is enabled.
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-10 : 06:26:56
|
| did you check if MSDTC service is running? |
|
|
|
myforum
Starting Member
4 Posts |
Posted - 2009-04-10 : 07:06:32
|
| yes,MSDTC service is running. |
|
|
|
|
|
|
'SQLOLEDB' unable to begin a distributed transacti