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.

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


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.