I have a database with always encrypted in SQL Server Express.
I migrated my SQL Server version from 2017 (v14) to 2019 (v15), in this new version there is a secure enclave option available for always encrypted that I'm not using.
When I connect from SQL Server Management Studio, everything is fine, I can see the encrypted information as always, but when I try to use it on my application with Entity Framework, I get this error:
System.Data.SqlClient.SqlException: Operation supported by enclaves invoked on data encrypted with randomized encryption where the keys are not enclave-enabled. Please clear the proc cache
My connection string is:
Data Source=localhost\SQLEXPRESS;Initial Catalog=Derma2Go_test;Integrated Security=True;MultipleActiveResultSets=True;Column Encryption Setting=enabled
I get error #33580 in SQL Server.
I am using Entity Framework 6.0.0.0
I don't want to use the secure enclaves in my database, how can I resolve this issue?