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

Author  Topic 

Kimi86
Yak Posting Veteran

79 Posts

Posted - 2014-08-04 : 22:03:38
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

andrew321
Starting Member

5 Posts

Posted - 2014-08-05 : 01:31:59
The steps above u have followed are correct but in addition, use above steps on client computer to open “Security Configuration” and check “Network DTC Access”, “Allow Inbound/Outbound” options and restart the service and computer.

On SQL Server service manager, click on the “Service” then select “DTC” and it should be running on your server computer.
Go to Top of Page
   

- Advertisement -