A severe error occurred on the current command. The results, if any, should be discarded. OLE DB provider "SQLNCLI10" for linked server "LinkedServerName" returned message "No transaction is active.".I had release the appliaction I am currently working on to testing. The applcation has been runnin g perfectly on my development machine, but no such luck on our testers machine. A new feature for this release is the use of distributed transactions to complete some of the business functionality. This obviously requires that MSDTC is setup and a linked server is created on the local SQL Server.
The MSDTC and linked server were setup on the test machine as I had described in my test document.
It took me a fair bit of googling to find the solution. Most of the obvious setup problems were covered in my test document. The problem in the end turned out to be the firewall on the test machine, something I should have checked much sooner.
Links for future reference:
http://stackoverflow.com/questions/673806/msdtc-how-many-ports-are-needed
http://support.microsoft.com/kb/306843
http://www.lewisroberts.com/2009/08/16/msdtc-through-a-firewall-to-an-sql-cluster-with-rpc/
No comments:
Post a Comment