Microsoft KB Archive/80081

{|
 * width="100%"|

INF: Setting Up Servers to Use Remote Procedure Calls

 * }

Q80081

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.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
  Run the following on machine 1:

     sp_addserver m1,local sp_addserver m2

sp_configure 'remote access',1 reconfigure  Stop and restart SQL Server on machine 1.  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  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" Keywords : kbusage

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2