Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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:
© 2014 Microsoft. All rights reserved.