Last post Oct 10, 2017 09:50 AM by Eric Du
Oct 01, 2017 09:35 AM|ganesh123.shirsath|LINK
We have developed an application asp.net mvc with SQL server 2016 in place which uses
1 unit of work and entity framework while communicating with database, currently all CRUDE operations on UI are done with Unit of framework
2. We are using RDL report and we have written Views, stored procedures to fetch data for drawing reports
Currently we have requirement to secure PII (Personally Identifiable Information). We have checked the follow options
1> Always encrypted feature in SQL server 2016, it works perfectly with Entity elements but with stored procedure and views (where we are selecting encrypted columns ) it throws operand mismatch error?
Please suggest suitable approach with which all UI as well as reports will work?
Thanks in advance
Oct 02, 2017 03:09 AM|Eric Du|LINK
According to your description, could you give us a detailed description of which operation you do cause this issue and the detailed exception message?
Hope you could post the detailed code and detailed error message, this will better help you fix the issue.
Here is a tutorial about how to use this new feature, please check:
Oct 02, 2017 11:30 AM|ganesh123.shirsath|LINK
Hi Eric, Thanks for the information.
We are getting the following exception
Error: Operand type clash: varchar is incompatible with nvarchar(50) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto2', column_encryption_key_database_name = '').
When we analyse found that in stored procedure for encrypted column
was used and it was causing the issue, its sorted currently and when we debug the application with visual studio 2013 we are able to perform insert as well as update operation.
When we published the web application on IIS ( its the same server where database is hosted and certificate is installed) its throwing error as
1> On list screen its throw error as "The wait operation timed out
2> When we do Add operation on UI its throwing error as
"Certificate with thumbprint '817862855998E2C88AE37E841B8137EC7ED6FB7E' not found in certificate store 'My' in certificate location 'CurrentUser'. Verify the certificate path in the column master key definition in the database is correct, and the certificate has been imported correctly into the certificate location/store. Parameter name: masterKeyPath"
3> We have also hosted the web application on different server and still we are getting the same error.
Thanks in advance
Oct 10, 2017 09:50 AM|Eric Du|LINK
In your case, add certain logging to print out which certificates are there in the store you are looking for, and that should point out which store is in fact being accessed.