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. You must set both the configuration parameter and the license option to enable encryption.
sp_configure ‘enable encrypted columns’, 1
