Cannot view cleartext of AlwaysEncrypted LOB columns in SSMS - by Erland Sommarskog

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 2413024 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 2/27/2016 12:00:12 PM
Access Restriction Public

Description

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.
Sign in to post a comment.