SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 The transaction manager has disabled
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Kimi86
Yak Posting Veteran

78 Posts

Posted - 08/04/2014 :  22:03:38  Show Profile  Reply with Quote
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

Edited by - Kimi86 on 08/04/2014 22:45:17

andrew321
Starting Member

USA
5 Posts

Posted - 08/05/2014 :  01:31:59  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000