• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3287
  • Last Modified:

Linked Server Error SQL Server 2008 R2

I am setting up linked server between two SQL Server Instances of 2008 R2 Std Version and getting the following error.

Executed as user: --------------------. The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "-------------------------------" was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391)  OLE DB provider "SQLNCLI10" for linked server "---------------------------------" returned message "The transaction manager has disabled its support for remote/network transactions.". [SQLSTATE 01000] (Error 7412).  The step failed.

Please help.
0
Favorable
Asked:
Favorable
  • 2
2 Solutions
 
Ryan McCauleyData and Analytics ManagerCommented:
Are you getting this error as you're attempting to set up the linked server, or when you're trying to execute a remote query once it's already configured? If the latter, I suspect you're executing a stored procedure on the remote server, though in some cases a regular query can cause this.

It sounds like either RPC isn't enabled in the linked server settings themselves, or MSDTC isn't configured properly to allow distributed transactions. Here are the two walk-throughs to fix these items:

MSDTC
http://pongsathonkeng.blogspot.com/2011/02/msdtc-setup.html

RPC/RPC-out
http://www.bidn.com/blogs/BradSchacht/ssis/617/server-%E2%80%98servername%E2%80%99-is-not-configured-for-rpc

Give both of these a try and, if you're still having issues, please post back the query you're running when you get the error.
0
 
FavorableAuthor Commented:
Actually, before your post I did some other research to findout MSDTC was configured. The Sys Admin came to get it fixed and the linked generated a similar error this time was (no transaction is active). I immediately thought to change Enable distribution transaction RPC on linked server options from true to false and my stored prod executed successfully.
Thanks, though your post was late! Lol!!!
0
 
FavorableAuthor Commented:
Issue got resolved before solution was posted!
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now