1. Configure for remote access

To configure Adaptive Server for remote access, log in to Adaptive Server as sa and check the current sp_configure setting using the following command:

sp_configure 'remote access'

If the returned value is 1, Adaptive Server is configured for remote access.

StepsIf the returned value is 0

  1. Enter:

    sp_configure 'remote access',1
    
  2. Restart Adaptive Server.