InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 20:42:04 GMT20http://www.sqlservercentral.com/Forums/Topic1009296-1550-1.aspxNothing worked except the below mentioned solution.Open command prompt as Administrator and enter the following commandsC:\> net stop msdtcC:\> msdtc -uninstallC:\> msdtc -installfollowed by server restart.. [url=http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/eb4eda65-1759-4266-a304-1f34c4b93680/]http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/eb4eda65-1759-4266-a304-1f34c4b93680/[/url][url=http://36chambers.wordpress.com/2011/04/08/msdtc-no-transaction-is-active/]http://36chambers.wordpress.com/2011/04/08/msdtc-no-transaction-is-active/[/url]Thu, 24 Jan 2013 05:35:29 GMTkarthik babuhttp://www.sqlservercentral.com/Forums/Topic1009296-1550-1.aspxI just found out that on the remote server, the MSDTC setting is on "Mutual Authentication Required"; it should be on "No Authentication Required".I will change it and restart the MSDTC and SQL services, and see if that fixes the issue:[code="sql"]begin distributed transactionselect * from LinkedSrvrName.dbName.dbo.tblNamerollback tran[/code]Error:[quote]OLE DB provider "SQLNCLI10" for linked server "LinkedSrvrName" returned message "No transaction is active.".Msg 7391, Level 16, State 2, Line 4The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "LinkedSrvrName" was unable to begin a distributed transaction.[/quote]Thu, 04 Nov 2010 11:03:05 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic1009296-1550-1.aspxCan be done at Active Directory Domain Trust. Both domains need have trust and and an exception with IP address. Please look for the article called:"Create a two-way, external trust for both sides of the trust"Thanks.Wed, 27 Oct 2010 12:59:57 GMTHotfixhttp://www.sqlservercentral.com/Forums/Topic1009296-1550-1.aspxThanks both for your responses.Wed, 27 Oct 2010 12:53:55 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic1009296-1550-1.aspxDon't forget that MSDTC is DNS based. I have found that a quick entry into the host file will fix these cross domain issues pretty quick...so on your source server, add a host file entry to the target, on the target, enter a host record for the source.then try again.host file is always here;C:\WINDOWS\system32\drivers\etc\hostsWed, 27 Oct 2010 12:44:14 GMTGeoff Ahttp://www.sqlservercentral.com/Forums/Topic1009296-1550-1.aspxPls check SPN settingsWed, 27 Oct 2010 10:26:39 GMTAkkarehttp://www.sqlservercentral.com/Forums/Topic1009296-1550-1.aspx[quote][b]Gianluca Sartori (10/22/2010)[/b][hr]Can the two DTC connect to each other?Have you checked that with DTCPing?[/quote]Got following error on local server when running DTCping:[quote]++++++++++++Start DTC Binding Test +++++++++++++Trying Bind to RemoteSrvr110-22, 12:57:09.192-->LocalSrvr1 Initiating DTC Binding Test.... Test Guid:FA12FEB1-8D3D-4297-B8F2-3A71341D788ABinding call to RemoteSrvr1 Failed In GUID Out GUIDSession Down[/quote]It looks like it is indeed a domain issue.Fri, 22 Oct 2010 11:03:07 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic1009296-1550-1.aspxCan the two DTC connect to each other?Have you checked that with DTCPing?Fri, 22 Oct 2010 09:58:56 GMTspaghettidbahttp://www.sqlservercentral.com/Forums/Topic1009296-1550-1.aspxCan anyone help me with this?I have checked all my settings according to link [url]http://www.sqlvillage.com/Articles/Distributed%20Transaction%20Issue%20for%20Linked%20Server%20in%20SQL%20Server%202008.asp[/url], and have restarted the MSDTC and SQL on both the local and remote servers, and yet this linked server query is still returning error below:[code="sql"]BEGIN DISTRIBUTED TRANSACTIONSELECT TOP 1 col1 FROM LinkedServer1.db1.dbo.tbl1ROLLBACK TRAN[/code]Error:[quote]OLE DB provider "SQLNCLI10" for linked server "LinkedServer1" returned message "No transaction is active.".Msg 7391, Level 16, State 2, Line 3The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "LinkedServer1" was unable to begin a distributed transaction.[/quote]I'm suspecting this may be caused by the fact that the local server is on a [b]TEST domain[/b], while the remote server is on a [b]production domain[/b], and there is one-way trust between the 2 domains, ie. one can only go from prod to test with Windows authentication and not the other way around.However, I have configured the linked server to use SQL auth with a sql login on the remote server, so I am not sure if this is indeed the issue.Any insights would be appreciated.Fri, 22 Oct 2010 09:28:29 GMTMarios Philippopoulos