How to: Set Remote Server Access (SQL Server Management Studio)

This topic describes how to control the execution of stored procedures from remote servers by using Object Explorer in SQL Server Management Studio.  

To set remote server access

1. In Object Explorer, right-click a server and select Properties.

2. Click the Connections node.

3. Under Remote server connections, select or clear the Allow remote connections to this server check box.

See Also

Concepts

remote access Option

Help and Information

Getting SQL Server 2005 Assistance