Home Forums SQL Server 2012 SQL 2012 - General enable promotion of Distributed Transactions for RPC: should be set to TRUE or FALSE RE: enable promotion of Distributed Transactions for RPC: should be set to TRUE or FALSE

  • pretty sure the misisng pice is the service, if you've toggled both rpc settings in your linked server.

    On the Target/linked server, Remote desktop over to it andopen services....it has a service named "Distributed Transaction Coordinator", and that service must be started.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!