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."

  • May 15, 2013 at 11:34 am

    #1615541

    I had the same problem. My two servers were in different domains. I had to add hosts entries on each server. For example, I have server1.domain1.local and server2.domain2.local. On Server1, I added IP, server2 to hosts file. On Server2, I added IP, server1 to hosts file. This resolved my issue.