INF: Setting Up Servers to Use Remote Procedure Calls

 Last reviewed: April 28, 1997
Article ID: Q80081

The information in this article applies to: 

  - Microsoft SQL Server version 4.2 for 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 query words:
Keywords : kbusage SSrvServer
Version : 4.2
Platform : OS/2

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.