Sql Compact 4 Locks up ~30+seconds when accessing encrypted database on Windows XP when running in non admin proc

Question

Having three thousand users of a mission critical app requires tracking down some obscure errors and problems. This one takes the cake. After a month of head scratching , debugging , profiling and finally head banging here it is.

SQL Compact uses the Crypto Api on encrypted databases. Hence a requirement to access the MachineKeys folder which is C:\Documents and Settings\All Users\Application Data\Microsoft\Crypto\Copy of RSA\MachineKeys  on windows XP and the contained files with cryptographic key pairs.

File permissions set on the files containing key pairs exclude access to non admins.

The app runs but there is a huge delay which basically locks up the app/machine.

Users scream when this happens - at least mine do.

This has only occurred on windows XP and only occurs for non admins in my experience so far.

Fix by bludgeoning the permissions.

Roll-on XP End Of Life.

---

ceeblunt

Answer 1

Have you tested with 4.0 SP1 CTP1 ?

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog

Answer 2

Yes.

Additional info.  Occurs in SBS AD domains. Possibly when upgraded domain server/changed domain.

---

ceeblunt

Answer 3

Hello,

I am facing the same issue.

Do you found a solution instead of manipulating the MachineKeys folder security?

---

Hesham