remote access Option

Use the remote access option to control the execution of stored procedures from local or remote servers on which instances of Microsoft SQL Server are running. Set remote access to 1 (default) to grant permission to run local stored procedures from remote servers or remote stored procedures from the local server. Set the option to 0 to prevent local stored procedures from being run from a remote server or remote stored procedures from being run on the local server.

The remote access option only applies to servers added using sp_addserver and is included for backward compatibility.

The setting takes effect after the server is restarted.


This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use sp_addlinkedserver instead.