Purpose

The purpose of this article is to teach you the process of disabling a remote server setup in Microsoft SQL Server 2000.

Disabling a remote server setup

Remote servers are set up in pairs. To set up a pair of remote servers, configure both servers to recognize each other as remote servers. Then, verify that configuration options are set properly for both servers so that each instance of SQL Server allows remote users to execute procedure calls.

To disable a remote server setup follow the steps as below:

1. Click Start, go to Programs, then go to Microsoft SQL Server and click Enterprise Manager.

2. Expand Security and click Remote Servers.

3. Right click remote server i.e. PC60 in details pane of Remote Servers and click Delete.

4. Click Yes.