question

brauyn-0180 avatar image
0 Votes"
brauyn-0180 asked brauyn-0180 commented

SSMS Always Encrypted Error

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered brauyn-0180 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you very much , I solved my problem through your answer. I generated powershell script and changed value of timeout in connection string . Thus I encrypted all data.

0 Votes 0 ·