clipped from: www.mssqlcity.com   
I got an error that RPC is not enabled. How can I enable RPC?
Answer:
You can enable RPC by using the sp_serveroption system stored procedure. To enable RPC from the ProductSQL server, you can use the following:
USE master
EXEC sp_serveroption 'ProductSQL', 'rpc', 'true'
To enable RPC to the ProductSQL server, you can use the following:
USE master
EXEC sp_serveroption 'ProductSQL', 'rpc out', 'true'