You must Sign In to post a response.
  • Category: SQL Server

    SQL Server 2016 Allways Encryption Feature - End up in Errors -

    Hi ,

    I am trying to use 2016 Allways encryption in my 2016 instance ( Enterprise Edition ) , on my user DB --> User Table in which it has a column called "Date Of Birth". where the the Datatype is ( DataTime , Null) .

    After following the steps of encrypting the column in my DB , and following the Wizards , i end up with error . as shown below .
    =====================================================
    Nov 11 2016 11:55:17 [Informational] TaskUpdates: Message:Task: 'Performing encryption operations' -- Status: 'Failed' -- Details: 'Task failed due to following error: Exception of type 'System.OutOfMemoryException' was thrown.'.

    Nov 11 2016 11:55:17 [Informational] WorkitemExecution: Message:Work item 'Performing encryption operations' stopped..

    Nov 11 2016 11:55:17 [Error] WorkitemExecution: Message:Work item 'Performing encryption operations' did not complete. Details: Exception of type 'System.OutOfMemoryException' was thrown..
    =======================================================

    On seeing the error , even i too though that the system is running short of Memory, but actually not, the system and instance has got ample amount of memory to support .

    Can some one help me to clear this problem ..

    I have followed the same as explained in the below URL
    http://dataap.org/sql-2016-ctp/always-encrypted-sql-server-2016/


    Please help..
  • #768316
    Hi,

    Can you let us know what encryption you have used?
    Because we have implemented encryption type called Transparent Data Encryption. Which will encrypt basically on column/table level data and not directly entire database. So we don't get any issues like System out of memory something like that.

    Let us know if you still have this issue, Kindly explain with little more details.
    If the issue solved kindly post the resolution for us.

    Thanks,
    Mani


Sign In to post your comments