Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm not talking about "RPC Out". That setting works as I expect it to: when "false", I can't call stored procedures on my linked server. When it's "true", I can.

The specific option I am referring to is in the GUI (SQL Server Management Studio) on the Linked Server Properties window for any linked server (under "Server Options" on the left). Or, you may also set this option by calling sp_serveroption @optname='rpc'.

"RPC" can be set to either true or false. However, I can't find solid documentation on what this actually means in practice. I can't find any situation in my experimentation that behaves differently depending on whether "RPC" is set to true or false.

Can anyone give an example of what behaves differently depending on this setting?


share|improve this question

2 Answers 2

One allows A=>B the other allows B=>A. In other words just because server A can call a proc on B doesn't mean B can call a proc on A.

RPC Enables RPC from the specified server.

RPC Out Enables RPC to the specified server.

share|improve this answer
That makes sense in theory, except I couldn't find a scenario experimentally where the RPC setting had any effect. I created a linked server B on server A. However, the RPC setting seems to have no effect on server B calling server A. (That call happens via another linked server A defined on server B.) –  Dan May 17 '11 at 21:43
I'm just guessing here but from what you posted... if A is linked to B from A, and B is linked to A from B then the links are going both ways through two different pipes. The settings above likely only apply when A is linked to B on A ONLY. –  RThomas May 18 '11 at 18:51

I know this is an old question but it returns as one of the first links on a search. I am just adding to @RThomas answer to give a bit more detail and when to use it. According to a msdn blog the RPC vs RPC Out on a SQL Server linked-server is this:

  1. RPC - This setting is mainly for legacy feature called Remote Server. According to the blog it states you will not be using this in SQL Server 2005 and higher. Unless you get an error like:

18482 “Could not connect to server '%.*ls' because '%.*ls' is not defined as a remote server. Verify that you have specified the correct server name. %.*ls.”

  1. RPC Out - setting is very pertinent to linked servers on SQL Server 2005 and higher. If this is not enabled you can get the following error message:

Msg 7411, Level 16, State 1, Line 1 Server 'myLinkedServer' is not configured for RPC.

Which really should say RPC Out should be enabled.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.