Below is an error that showed up while trying to execute a stored procedure on instance X from SQL server instance y. MYSERVER here represents the name of SQL Server instance X
Msg 7411, Level 16, State 1, Line 1
Server ‘MYSQLSERVER′ is not configured for RPC.
Solution to this was to set RPC in/out to true. Below are the T-SQL commands used.
exec sp_serveroption @server=’MYSQLSERVER′, @optname=’rpc’, @optvalue=’true’
exec sp_serveroption @server=’MYSQLSERVER′, @optname=’rpc out’, @optvalue=’true’
Below shows how to do this graphically , using SSMS – SQL Server Management Studio.