remote access Option

Use the remote access option to control logins from remote servers running instances of Microsoft® SQL Server™. remote access is used with remote stored procedures. Set remote access to 1 (default) to allow logins from remote servers. Set the option to 0 to secure a local server and prevent access from a remote server.

The setting takes effect after stopping and restarting the server.

To set remote server access