I found this link which told me how to modify the settings for the MSDTC. Join them; it only takes a minute: Sign up OLe DB provider “SQLNCLI” for linked server was unable to begin a distributed transaction up vote 6 down vote favorite I am Running msdtc -uninstall msdtc -install and then stopping and restarting SQL Server service fixed it. Caveat for a cloned machine If you have created your server by using a clone of another machine and the above steps did not fix the issue (or maybe the Network http://crudlet.org/distributed-transaction/unable-to-begin-a-distributed-transaction-no-transaction-is-active.html
share|improve this answer answered Sep 19 '11 at 18:30 EBarr 8,01244373 add a comment| up vote 2 down vote If the servers are clustered and there is a clustered DTC you share|improve this answer edited Nov 27 '15 at 15:18 answered Sep 19 '11 at 18:47 Ian Boyd 88.2k152537869 2 Let's see if I've got it right : 1- msdtc -uninstall Issues can arise from a number of problems. print linkedlist reversely Can cheese in hand luggage be mistaken for plastic explosive? http://stackoverflow.com/questions/7473508/unable-to-begin-a-distributed-transaction
Also check the eventlog for DTC errors. –Jens W. Then click on Distributed Transaction Coordinator. You will then get a Properties Form. Thank you for linking to the other answer.
You cannot edit your own topics. sql-server sql-server-2005 msdtc distributed-transactions share|improve this question edited Sep 2 at 14:46 asked Sep 19 '11 at 15:40 Ian Boyd 88.2k152537869 17 good to see you didn't skip the crucial You can enable this by:Control Panel --> Add or Remove Programs" --> Add/Remove Windows Components --> Application Server --> Detail --> "Enable network DTC access".You can also verify:Administrative Tools -> Component Hot Network Questions What is the purpose of the AT-ACT?
Kevin Urquhart SQL Server DBA, London www.theBoredDBA.com Recent Script to Update Specific StatsOnly Update Stats You NeedSetting Trigger OrderHow Inserted and Deleted Tables WorkSQL Server Trigger Examples Archive September 2015 (4)August Enable Promotion Of Distributed Transactions Ensure Distributed Transaction Coordinator service is running on both machies: Disable all MSDTC security on both machines: Turn on random options on the linked server: Cursed and swore. It typifies every experience I've ever had with MSDTC. –A. asked 2 years ago viewed 28837 times active 1 year ago Blog Stack Overflow Gives Back 2016 Developers, Webmasters, and Ninjas: What’s in a Job Title?
I've used linked servers quite a bit over the years, so I had all the usual settings in SQL for a linked server and in MSDTC that Ian documented so nicely https://connect.microsoft.com/SQLServer/feedback/details/243725/linked-server-sourceserver-was-unable-to-begin-a-distributed-transaction The college in 'Electoral College' Writing a recommendation letter for a student I reported for academic dishonesty Can a mathematician review my t-shirt design? Ole Db Provider Sqlncli10 For Linked Server Was Unable To Begin A Distributed Transaction Would society of simultaneous hermaphrodites have gender roles? Ole Db Provider Sqlncli10 For Linked Server Returned Message No Transaction Is Active http://www.sqlwebpedia.com/content/msdtc-troubleshooting was pretty good as was http://www.mssqltips.com/sqlservertip/2083/troubleshooting-sql-server-distributed-transactions-part-1-of-2/ togehter they cover just about every thing I can recall having to debug for MSDTC problems (and some others too).
That should have worked. Check This Out Why are Stormtroopers stationed outside the Death Star near the turbolaser batteries adjacent to Bay 327? How do I generate a time series in PostgreSQL? Does anybody know which plant (or tree) is this? The Transaction Manager Has Disabled Its Support For Remote/network Transactions
High Jump Champion Output integers in negative order, increase the maximum integer everytime Can a typeface be designed to have characters depend on previous characters within a typed word? Also, I edited the wording of the section you mentioned, good catch on that! If you require transactions, you have to debug the problem pretty much yourself since it is environmental. Source HelpFile: HelpContext: $00000000 SQLState: 42000 NativeError: 7391 How do i get Microsoft to favor functionality over security?
One note though… your wording of "Check off Network DTC aCCESS" is slightly confusing. Msg 7391, Level 16, State 2 Browse other questions tagged sql sql-server or ask your own question. Check out this TechNet article for generic troubleshooting steps: http://support.microsoft.com/default.aspx?scid=kb;en-us;306212If your local batch is doing any kind of data modification operation (including INSERT of any form) there will be an implicit
Is it possible to have 3 real numbers that have both their sum and product equal to 1? Simply open a command prompt with Administrator Rights and type: msdtc -uninstall Press Enter. What change in history would I have to make to stop Christmas from happening? A Nested Transaction Was Required Because The Xact_abort Option Was Set To Off. BEGIN DISTRIBUTED TRANSACTION SELECT TOP 1 * FROM Sessions OLE DB provider "SQLNCLI" for linked server "ASILIVE" returned message "No transaction is active.".
Ad Hoc (OpenRowset / OpenDatasource) Distributed Queries1iSeries Linked-Server SQL 2012 performance issue1Can we Link sql windows server with oracle unix server?0Linked Server Error on SQL Agent Job0MS SQL, MySQL linked server simulation with kinetic friction, weird results Design strategy to replace multiple if else What is the intuition behind the formula for the average? Join them; it only takes a minute: Sign up Unable to begin a distributed transaction up vote 67 down vote favorite 16 i'm trying to run SQL against a linked server, have a peek here Was curious what the downside to setting the attribute was.
Please enter a workaround. Full Name Email Website (optional) Comment NB: Comments will only appear once they have been moderated. Right click on the Local DTC option under the Distributed Transaction Coordinator You will then see the Local DTC Properties dialog box. Navigate to the Security tab. As you can see below, the Browse other questions tagged sql-server sql-server-2012 linked-server iseries distributed-transactions or ask your own question.