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.