RE: enable promotion of Distributed Transactions for RPC: should be set to TRUE or FALSE

SSC Guru

Points: 323504

May 15, 2015 at 12:07 pm

i often get a similar error message when i create a new linked server, where i forgot to set the rpc and rpc out to true;

Executed as user: MyDomain\sqlmaster. Server 'SSASLocal' is not configured for RPC. [SQLSTATE 42000] (Error 7411). The step failed.

so in my case, i have to make sure both rpc and rpc out are set to true in my linked server, and that the distributed trnasaction coordinator service was running.

I read that you are leaving it to false, and disabling the DTC,a dn it works then?

that's kind of opposite of my experience.

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!