sql-lover (5/15/2015)

---

Lowell (5/15/2015)

---

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.

Let's focus on the LinkedServer itself 😉 ... and that option.

It is set to TRUE on all of my servers but one. The following query does not run when set to TRUE

Insert into #TempTable

EXEC ServerB.MyDatabase.MyStoreProcedure

@param1= '',

@param2= ''

It only runs on the server where 'remote proc transaction promotion' is set to FALSE.

rpc and rpc out are set to true, all servers, that's not the issue.