Purpose

The purpose of this article is to teach you the process of setting up remote server access using Enterprise Manager in Microsoft SQL Server 2000.

To Set Remote Server Access

Remote access is used with remote stored procedures which describes how to control the execution of stored procedures from remote servers. Changing a configuration option requires that you stop and restart the server.

Follow the steps below to set up the remote server access in Microsoft SQL Server 2000:

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

2. Right click on registered server i.e. PC54, and click Properties, then choose Connection tab.

3. Now, select the Allow other SQL Servers to connect remotely to this SQL Server using RPC option.

4. Click OK.