October 10, 2013 at 5:19 am
Created a Linked server.
below is the error
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "EMPLOYEE" was unable to begin a distributed transaction.
************************************
Every Dog has a Tail !!!!! :-D
October 10, 2013 at 5:25 am
I have the same problem and i solve that on this way
go to Component Services screen (Start -> Program -> Administrative Tools -> Component Services)
Expand Computers
Expand Distributed Transaction Coordinator
Right Click on Local DTC
On properties make sure Network DTC Access, Allow Inbound and Allow Outbound are checked. You may need to turn on Allow Remote Clients.
October 10, 2013 at 5:31 am
I went to the specified path u said..
Bu in security tab i can only see
Enable XA Transactions :w00t:
************************************
Every Dog has a Tail !!!!! :-D
October 10, 2013 at 5:35 am
This settings needs to be done on Destinations server??
Below is my scenario..
Source server - AAA
Destination server - BBB
Linked server configured on AAA
& we want to run a stored procedure in accordance to BBB server..
So the settings you told.. we have to do it in AAA server or BBB server
************************************
Every Dog has a Tail !!!!! :-D
October 10, 2013 at 5:36 am
What operating system you have installed on remote machines?
on server BBB
October 10, 2013 at 5:37 am
Its Windows NT 6.1
************************************
Every Dog has a Tail !!!!! :-D
October 10, 2013 at 6:55 am
Thanks Rookie.. It worked 🙂
************************************
Every Dog has a Tail !!!!! :-D
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply