Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Question about RPC for linked servers. Expand / Collapse
Author
Message
Posted Friday, December 14, 2012 7:51 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 2:11 PM
Points: 54, Visits: 349
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.
Post #1396668
Posted Friday, December 14, 2012 2:58 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 2:25 PM
Points: 332, Visits: 537
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..
Post #1396823
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse