Server is not configured for RPC

Question

Looking for my job history I foudn the error below:

06/18/2018 00:00:01,MBS_Lojas_ExportaMR_OutrasLojas,Error,1,WIN-VRT-01\SQL2008,MBS_Lojas_ExportaMR_OutrasLojas,Passo1,,Executed as user: WIN-VRT-01\integracao. Server 'x.y.z' is not configured for RPC. [SQLSTATE 42000] (Error 7411).  The step failed.,01:11:15,16,7411,,,,0

I have this linked server with the option RPC and RPC Out with the values assigned to true.

In the job I have this

EXEC master.dbo.sp_serveroption @server=N'x.y.z', @optname=N'rpc', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'x.y.z', @optname=N'rpc out', @optvalue=N'true'

I can't find out why is this happening and none of the solutions posted for this error could help me to debug this issue.

Answer 1

You need to enable RPC Out in Linker Server Properties on the Calling Server.

Don't enable RPC unless you want the linked server to be able to make calls to your server.

Answer 2

I made RPC and RPC out fields as True (as shown in the image below). Logged out of SSMS and logged back in and it worked.