SQL – Server ‘MYSQLSERVER′ is not configured for RPC

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.