Share via

Difference Between 'Remote Access' Config Option and Linked Servers RPC/OUT

Saransvan 111 Reputation points
2023-08-01T14:59:54.4633333+00:00

Hi.

MS Article on 'Remote Access' config option states: This option affects servers that are added by using sp_addserver and sp_addlinkedserver. You should leave remote access enabled (the default) if you use linked servers.

So what is the RPC/OUT options within the Linked Servers for - what is the difference?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,477 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 116.9K Reputation points MVP
    2023-08-01T21:19:23.7033333+00:00

    I don't think remote access has any effect at all. I believe it relates to "remote server" a feature that pre-dates linked server, and which has been removed from the product. I could discern any difference when I set it to 0. That said, leave it 1, and don't touch it.

    The server option rpc out controls whether you can call stored procedures on the remove server. Depending on how you set up your linked server, this option may default to 1 or 0, but it must be 1 for stored procedure calls to be possible.

    To my knowing rpc in has no effect.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.