Use the remote access option to control executing stored procedures from remote servers running instances of Microsoft® SQL Server™. Set remote access to 1 (default) to allow permission to execute stored procedures from remote servers. Set the option to 0 to prevent execution of stored procedures from a remote server.
The setting takes effect after stopping and restarting the server.
To set remote server access
Enterprise Manager
Enterprise Manager
.gif)
Transact-SQL
SQL-DMO
See Also
RECONFIGURE
Setting Configuration Options
sp_configure