Principale utente con più risposte
Sql Compact 4 Locks up ~30+seconds when accessing encrypted database on Windows XP when running in non admin proc
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.