Home Forums SQL Server 2005 SQL Server 2005 General Discussion OLE DB provider "SQLNCLI" for linked server " " returned message "No transaction is active." RE: OLE DB provider "SQLNCLI" for linked server " " returned message "No transaction is active."

  • I am sure you might have resolved issue by now but just in case Not resolved then you may refer link

    http://www.sqlvillage.com/Articles/Distributed%20Transaction%20Issue%20for%20Linked%20Server%20in%20SQL%20Server%202008.asp

    that can guide you resolve this issue even for Windows Server 2008.

    [font="Verdana"]--www.sqlvillage.com[/size][/font]