December 14, 2012 at 7:51 am
OK, so I am trying to figure out what the purpose of the RPC option for sp_serveroption is for.
I understand what RPC is, but I have a deeper question.
When sp_serveroption rpc is set to false, I can still add a linked server, turn it on there (in the linked server properties) and get it to work.
Why is that?
1.) How can I disable RPC in such a way that a server does not allow it even when added as a linked server?
2.) Why can RPC be disabled at the sp_serveroption level and still work through the linked server properties?
3.) What is the best way to tell if RPC is enabled at the server level, and ensure it's disabled?
Any help is appreciated.
December 14, 2012 at 2:58 pm
RPC Needs to be enabled in order to call a stored procedure which is on linked server database.
exec sp_serveroption @server='linked_server_name', @optname='rpc', @optvalue='false'
exec sp_serveroption @server='linked_server_name', @optname='rpc out', @optvalue='false'
EXEC [linked_server_name].MASTER.SYS.SP_HELPDB ‘linked_server_name’
Hope this helps you..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply