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..