.Net SqlClient Data Provider: Msg 7411, Level 16, State 1, Line 3
Server name is not configured for RPC.
If you receive an error something like this most likely is from the Linked server its because when you try to run a remote procedure call like stored procedures.. Linked server setup should have RPC enabled
In order to fix this change the Linked server properties
EXEC sp_serveroption ‘server_name’, ‘rpc’, ‘true’;
EXEC sp_serveroption ‘server_name’, ‘rpc out’, ‘true’;
or we can change usi SSMS GUI interface