The remote access configuration parameter is set to 1 when you install Adaptive Server. This allows Adaptive Server to execute remote procedure calls to the Backup Server.
For security reasons, you may want to disable remote access except when dumps and loads are taking place. To disable remote access, use:
sp_configure "allow remote access", 0
Before you perform a dump or load, use the following command to reenable remote access:
sp_configure "allow remote access", 1
allow remote access is dynamic and does not require a restart of Adaptive Server to take effect. Only a System Security Officer can set allow remote access.
