The configuration parameter enable encrypted columns must be set to 1 to use the encryption functionality. If the configuration option is turned off in a server that contains encrypted columns, any commands against those columns fail with an error. Both the configuration parameter and the license option are needed to enable encryption.
sp_configure ‘enable encrypted columns’, 1
