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 |
|
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 queryDelete from [MyServer].db.dbo.tableA where UniqueKey in (Select UniqueKey from #DeleteKeys)-- Temp table here is just an exampleI am doing multiple delete so doing this in a transactionBut 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 Properly1. 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" tab5. Click "Security Configuration"6. Make sure you check "Network DTC Access", "Allow Remote Client","Allow Inbound/Outbound", "Enable TIP" (Some option may not benecessary, have a try to get your configuration)7. The service will restart8. You May need to restart the server if necessary9.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 adviceThanks |
|
|
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. |
 |
|
|
|
|
|
The transaction manager has disabled