Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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



See Also


Setting Configuration Options


Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft