Credit goes to Pradip Tripathy for finding this issue.
You encrypt a LOB column in SSMS using the wizard. For instance, the column Employee.Notes in Northwind
Later your reconnect. On the Options page, you add this string.
Column Encryption Setting=enabled
You now expect to see the decrypted values when you run your queries. However, when you run the query "SELECT * FROM Employees", you get this error message:
An error occurred while executing batch. Error message is: Retrieving encrypted column 'Notes' with CommandBehavior=SequentialAccess is not supported.
I can't say how critical this issue is from a strict use-case point of view. However, it certainly makes Microsoft looks bad when the new shiny feature does not work.