Help

  • 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

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

  • 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

  • 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

  • What operating system you have installed on remote machines?

    on server BBB

  • Its Windows NT 6.1

    ************************************
    Every Dog has a Tail !!!!! :-D

  • 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