Remote Servers Editor (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Editors

The Remote Server Editor lets you manage the connection and security properties for a remote server, and manage the associated logins.

Note: Before using this editor, consult Sybase documentation for information on configuring remote server logins. For more information, see Accessing Third Party Documentation.

To edit a remote server

  1. Open an editor on the remote server. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Lets you work with the Network Name, Server Type, Timeout Inactive Connections, Network Password Encryption, Security Model, Security Mechanism, Message Integrity, Message Confidentiality, and Mutual Authentication settings. For details on these settings, see Remote Servers (Sybase ASE) - Properties.

Logins

Lets you build pairs of sp_addremotelogin and sp_remoteoption system procedure calls that authorize a new remote server user and configures remote login options for that user:

Click the Add Remote Login button to open a dialog that displays or lets you provide: Remote Server Name - Displays the remote server name. Remote Login Name - Lets you specify a remote login name. Select the All remote users box if you want to use this name for all remote logins. Local Login Name - Lets you select a local user name. Trusted Remote Login - Lets you specify this remote login as a trusted login.

Select a login, click Modify, and use the table above as a guide to modifying login options.

Select a login, and click Drop to delete the login.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.