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 | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
    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.

    Was this answer helpful?

Your answer

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