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
In Object Explorer, right-click a server and select Properties.
Click the Connections node.
Under Remote server connections, select or clear the Allow remote connections to this server check box.