Configuring default values

Use configure replication server to establish default security settings for all outgoing logins (when Replication Server acts as a client) and incoming logins (when Replication Server acts as a server).

You can override default security settings for these outgoing pathways:

NoteYou cannot override any default security settings that control security for incoming logins.

When Replication Server seeks to open a pathway to another server, it checks to see if security parameters have been set specifically for that pathway. If not, Replication Server uses the default security settings determined using configure replication server.

To set global security parameters, log in to Replication Server and execute configure replication server at the isql prompt. Here is the syntax:

configure replication server {
  set security_mechanism to 'mechanism_name' |
  set security_parameter to { 'required' |
    'not_required' }}

You can set all of the configuration parameters listed in Table 8-8. They are stored in the rs_config table in the RSSD. You must have sa permission to execute them.


Examples

This section provides examples of using configure replication server.

Requiring unified login

To require all servers and users that connect to Replication Server to be authenticated by the security mechanism, set unified_login to “required.” Log in to Replication Server and execute this command at the isql prompt:

configure replication server 
  set unified_login to 'required'

If unified_login is “not_required”, Replication Server allows servers and users to connect with either a credential or a password.

Noteunified_login must be “required” for other security services to take effect.

Requiring data encryption

To require all data sent or received by Replication Server to be encrypted, log in to the Replication Server and execute this command at the isql prompt:

configure replication server 
  set msg_encryption to 'required'