SqlCe opens slow under a limited user account in Windows XP

Question

This is a mirror of a SO post: http://stackoverflow.com/questions/11697308/sqlce-opens-slow-under-a-limited-user-account-in-windows-xp

I have a windows application built with .NET 4.0. It has a SqlCe database under its program files directory: C:\Program Files\Company Name\Application Name\Data\Data.sdf

This application is installed with Inno Setup and the Data folder is given permission with this inno setup configuration:

[Dirs]
Name: {app}\Data; Permissions: users-modify

However, even if I deploy this application without the installer (just zip up all the files from my development machine and unzip on the target machine's desktop) I still face these same issues. So I do not think it is a file directory permission issue.

For certain kinds of windows users, it will take 13+ seconds to open a connection to this database on Windows XP machines.

On our client's XP computers:

• Domain admins can run fine.
• Local admins and local limited users will experience the slow connection open.

On my personal XP Home computer:

• Admins can run this fine.
• Limited users will experience the slow connection open.

On my personal Windows 7 machine, it runs fine with local admin and local limited account.

Other notes that might help:

I am using SqlCe 4.0. I am bin deploying the SqlCe files so that the target machine does not have to install SqlCe.

This application will sometimes delete and re-download the Data.sdf file as part of it other processes (sync).

This application is also using WPF and Entity Framework.

Please help. Nearly every screen in this application will open and close the database connection.

Thanks

Answer 1

Hello,

I am facing the same issue. Do you found a solution?

---

Hesham

Answer 2

Yes.  I got an answer in my SO post.

http://stackoverflow.com/a/11699440/320623

Give the user permissions to:

C:\Documents and Settings\All Users\Application Data\Microsoft\Crypto\RSA\MachineKeys

http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/eb6a01a7-0bfd-41e3-b4c8-34581c5ccaa3

This blog has some similar information in the comments.  You may only need to give the user "read" permissions:

http://erikej.blogspot.com/2011/02/using-sql-server-compact-40-with.html