How to check and set remote server configuration options (Enterprise Manager)

To check and set remote server configuration options

1. Expand a server group, and then right-click a server.
   
   
2. Click Properties, and then click the Connections tab.
   
   
3. Under Remote server connections, review and, if appropriate, change the values for the following configuration options:
   • Allow other SQL Servers to connect remotely to this SQL Server using RPC.
     
     
   • Query time-out (sec, 0 = unlimited)

     This option specifies the number of seconds to wait before returning from processing a query. A value of 0 will allow an infinite wait. The default is 0.

   • Enforce distributed transactions (MTS).

   Changing a configuration option requires that you stop and restart the server. If you changed a configuration option, then proceed to Step 4. If not, skip to Step 6.

4. Right-click the server, and then click Stop.
   
   
5. After the server has stopped, right-click the server, and then click Start.
   
   
6. Repeat Steps 1 through 5 on the other server of the remote server pair.