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 2008 Forums
 Transact-SQL (2008)
 The transaction manager has disabled

Author  Topic 

Kimi86
Yak Posting Veteran

79 Posts

Posted - 2014-08-04 : 22:02:35
I am trying to delete some data from a linked server using a simple query
Delete from [MyServer].db.dbo.tableA where UniqueKey in (Select UniqueKey from #DeleteKeys)-- Temp table here is just an example
I am doing multiple delete so doing this in a transaction

But I get below error:
"The transaction manager has disabled its support for remote/network transactions.

I also tried doing below steps:

Follow this step to verify your DTC has been configure Properly
1. Go to "Administrative Tools > Component Services"
2. On the left navigation tree, go to "Component Services > Computers
> My Computer"
3. Right click on "My Computer", select "Properties"
4. Select "MSDTC" tab
5. Click "Security Configuration"
6. Make sure you check "Network DTC Access", "Allow Remote Client",
"Allow Inbound/Outbound", "Enable TIP" (Some option may not be
necessary, have a try to get your configuration)
7. The service will restart
8. You May need to restart the server if necessary

9.Do the same thing On your client computer

but then i got error - "No transaction is active."

I am not able to correct this error since last 2 days.. could someone please advice

Thanks
   

- Advertisement -