Share via

SSMS Always Encrypted Error

büşra uyün 21 Reputation points
2021-06-23T10:10:49.557+00:00

When I tried always encrypted on 180 thousand row of data , I faced error :

Message:Work item 'Performing encryption operations' did not complete. Details: One or more errors occurred..

When I tried on 50 thousand row of data , I encrypted and I also trıed on 100 thousand of data but I couldn't encrypt.

what do you thınk about this ? do you thınk thıs problem is related to amount of data .

During test process , I used microsoft Sql Server Management Server 18

Azure SQL Database
0 comments No comments

Answer accepted by question author

Olaf Helper 47,621 Reputation points
2021-06-23T10:44:28.77+00:00

Are you using the wizard, also for execution? Better don't do that, the wizard do have a command timeout of 30 seconds and if the execution exceed this timeout, it fails.

Always use script in query windows, that has no default timeout. For this follow the wizard uo to last step. Instead of let it execution, generate the scrip with the button on to left.

Was this answer helpful?


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.