OLE DB provider "SQLNCLI10" for linked server "servername" returned message "No transaction is active.".

Question

OLE DB provider "SQLNCLI10" for linked server "servername" returned message "No transaction is active.".

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Might be a totally different thing, but this article[/url] shows you how to set up and troubleshoot linked servers and OLEDB providers.

Hope this helps

Gianluca

-- Gianluca Sartori

satish_kukunuru Old Hand Points: 345 More actions · Answer 2

Thanks for replying. The article given by you is much informative.

Still problem didn't resolve.

In my case, the problem is about the distributed transaction.

"SQLNCLI10" for linked server "servername" was unable to begin a distributed transaction.

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

Did you reboot the server(s) after tweaking MSDTC configuration? This step is required.

How is the provider loaded? In process or out of process?

-- Gianluca Sartori

satish_kukunuru Old Hand Points: 345 More actions · Answer 4

http://www.sqlservercentral.com/articles/Linked+Servers/73794/

The above is the link given by you for the configuration.

I didn't try the MMC configuration, cluster configuration. I did only MSDTC changes.

do I need to give port number as exception in the firewall ? Can you clarify me what is in process & our process mean ? I am new to this area using remote calls.

In the Link server, i have stored procedure. By calling linked server stored procedure, i need to insert the data into a temporary table which is declared in my local server. This is my requirement.

Thanks

Satish

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

satish_kukunuru (1/23/2012)
Can you clarify me what is in process & our process mean ? I am new to this area using remote calls.

Run this:

EXEC master.sys.sp_MSset_oledb_prop

What does this return for SQLNCLI10, column "allow_in_process"?

In process means that the provider gets loaded into SQLServer's address space, out of process means that the provider gets loaded outside SQLServer's address space by a surrogate process.

do I need to give port number as exception in the firewall ?

Maybe. See if DTCPING helps you identifying network related issues.

-- Gianluca Sartori

Jared SSC Guru Points: 61793 More actions · Answer 6

What are your Linked Server options set to for this specific linked server object?

Jared
CE - Microsoft