Sql Compact 4 Locks up ~30+seconds when accessing encrypted database on Windows XP when running in non admin proc
24 เมษายน 2555 13:41
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.
25 เมษายน 2555 11:09ผู้ดูแลHave you tested with 4.0 SP1 CTP1 ?
Please mark as answer, if this was it. Visit my SQL Server Compact blog
4 พฤษภาคม 2555 12:09
Additional info. Occurs in SBS AD domains. Possibly when upgraded domain server/changed domain.
30 กรกฎาคม 2555 10:20
I am facing the same issue.
Do you found a solution instead of manipulating the MachineKeys folder security?