Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
remote access Option

remote access Option

SQL Server 2000

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

Transact-SQL

SQL-DMO

See Also

RECONFIGURE

Setting Configuration Options

sp_configure

Show:
© 2015 Microsoft