How To
How to check and set remote server configuration options (Enterprise Manager)
To check and set remote server configuration options
- Expand a server group, and then right-click a server.
- Click Properties, and then click the Connections tab.
- 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.
- Allow other SQL Servers to connect remotely to this SQL Server using RPC.
- Right-click the server, and then click Stop.
- After the server has stopped, right-click the server, and then click Start.
- Repeat Steps 1 through 5 on the other server of the remote server pair.