Problems accessing Component Integration Services

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.