Unable to access sqlce database

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
9/12/2013 1:04:41 PM
Gravatar
Total Posts 18439

Re: Unable to access sqlce database

If the error is:

"Access to the database file is not allowed."

 It is a file system permission problem and it cannot read or write to the database file then you must fix the file system permissions so it can. The user that is the identity on the web application pool must have full control on this file.

If you are talking about some other problem then start a new thread and ask it clearly separate from this one. The answer to this problem has been given and is not going to be different in the future.

The problem is that uploading the db is the cause of the file system permission problem, the file is created and owned by a windows user with a SID system id  on your local machine but that user does not exist on the remote server but the remote server still sees the attributes on the file each time you upload it and it is owned by a user from your local windows that is unknown to the server so every time you upload it the  permissions are messed up again.

You should upload it fix the permissions so it works then don't repeat the process, treat it the same as backup and restore of a sql database, restoring a sql database is not something to keep doing every day and it is the same store for sql ce even though it is easier to do than with sql server it is not something to keep doing over and over, unless you want to keep breaking and fixing the file system permissions.

 

9/12/2013 3:06:21 PM
Gravatar
Total Posts 36

Re: Unable to access sqlce database

Thank you, Joe. I was wondering if the file permissions and the sign-in problems were related. The host has to set the access for the file as you explained. I thought these properties may have been copied with the upload, but I was mistaken due to my lack of understanding.

However, I still have the same problem signing in and cannot administer the website. I shall start another thread for this problem.

Regards

You must sign in to post in the forums. This thread is closed to new posts.