Adding a Remote Server

You can use the server to access data on remote servers.

1. Add the remote server to the interfaces file.
   Use the dsedit or dscp utility to edit the interfaces file (called sql.ini on Windows), located in the $SYBASE directory. See the Configuration Guide for your platform.
2. Add the name, server class, and network name of the remote server to system tables.
   Optionally, assigning an alternate login name and password.

• Creating Server Entries in System Tables
  Use sp_addserver to add entries to the sysservers table.
• Adding an Alternate Login and Password
  Use sp_addexternlogin to assign an alternate login name and password to be used when communicating with a remote server.
• Verifying Connectivity
  The connect to command establishes a passthrough mode connection to the remote server. This passthrough mode remains in effect until you issue a disconnect command.