INF: Setting Up Servers to Use Remote Procedure Calls

ID Number: Q80081

4.20

OS/2

Summary:

The following is a consolidation of the steps for setting up SQL

Server on two servers to allow the use of remote procedure calls.

More Information:

1. Run the following on machine 1:

sp_addserver m1,local

sp_addserver m2

sp_configure 'remote access',1

reconfigure

2. Stop and restart SQL Server on machine 1.

3. Run the following on machine 2:

sp_addserver m2,local

sp_addserver m1

sp_configure 'remote access',1

reconfigure

sp_addremotelogin m1,sa,sa

sp_remoteoption m1,sa,sa,trusted,true

4. Stop and restart SQL Server on machine 2.

The system administrator (SA) can now log in to machine 1 and execute a

procedure on machine 2. For example:

m2...sp_who

Additional reference words: 4.20