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

How to Install SQL Server 2000

How To

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.