If you issue a command that accesses a remote object and Component Integration Services is not found, the following error message appears:
cis extension not enabled or installed
Verify that the enable cis configuration parameter is set to 1 by running:
sp_configure "enable cis"
sp_configure returns the following row for the enable cis parameter:
name min max config value run value enable cis 0 1 1 1
Both “config value” and “run value” should be 1. If both values are 0, set the enable cis configuration parameter to 1, and restart the server. Use the syntax:
sp_configure "enable cis" 1
If “config value” is 1 and “run value” is 0, the enable cis configuration parameter is set, but does not take effect until the server is restarted.
Component Integration Services is enabled by default
beginning with Adaptive Server version 12.0.
