hi guys, after fixing errors on my orchard site, this error finally came out after clicking Finish Setup:

"Setup failed: An exception was thrown while invoking the constructor 'Void .ctor(Orchard.Environment.Configuration.ShellSettings, Orchard.Data.ISessionFactoryHolder)' on type 'SqlCeCommandInterpreter'."

I followed what i read in other discussions to set all the permissions in the bin, App_Data, Module, and Themes but still no luck. Any suggestions on how to fix this???

Delete app_data and start over.

I have run into the same error, cannot find a way to fix this. I am running at a hosting provider in a shared environment, so limited access to the machine. On a similar setup at the same ISP I have been running Orchard 1.4 without issues for over a year now. I have tried clearing and removing app_data, have set read/write access to the entire site structure, re-downloaded the ZIP and re-uploaded it through FTP, but all to no avail. I am trying to run Orchard with the built-in data storage option (SQL Server Compact), which does work for 1.4 as mentioned. This is a fresh site, no previous data, I have not packaged any modules.

What I did do is re-compile log4net.dll with the added [assembly: System.Security.SecurityRules(System.Security.SecurityRuleSet.Level1)] directive (see here) to get it to work on this environment, but log4net is working: I have changed level to "info" and get about 135 kB of Orchard configuring itself.

Any and all suggestions welcome!

Are you sure that IIS is configured to run .net 4.0 in integrated mode and in full trust?

.NET 4.0 integrated mode: yes, full trust: not sure, given the fact that it is a shared environment ISP: probably not.

Will try to install a copy of the 1.4 version site that works on the other (supposedly similar) environment to see if there are configuration differences between the 2, will report back.

make sure your app pool identity has write access to the App_Data folder.

Confirmed .NET 4.0, and I was able to install an existing 1.4 site on this environment by simply FTPing it over. Write access was set on all necessary folders. Is there any way to get at the underlying exception for "Setup failed: An exception was thrown while invoking the constructor 'Void .ctor(Orchard.Environment.Configuration.ShellSettings, Orchard.Data.ISessionFactoryHolder)' on type 'SqlCeCommandInterpreter'."? It is not in the log file.

What about full trust?

Hi

I'm getting this error as well when creating a fresh site using built-in storage. The app pool identity has full access to the App_Data directory and is in integrated mode. The site also has full trust. 

Hmm, it seems that it can't load System.Data.SqlServerCe, although I do have SQL Server Compact installed. It does, however, work when I run the non-Azure solution.

You shouldn't need to install Sql Server Compact on the web server. It should be bin deployable as far as I know.

I have successfully setup an Orchard site using Sql Server CE bin deployed (granted it is Orchard v1.3.9).

If you have installed Sql Server CE on the web server then maybe the bin deployed version is conflicting with the version in the GAC.

Sorry, I should have mentioned that this is on my local machine. However, I'm thinking it's not a good idea to use built-in storage when using developing for Azure, as it will just re-create the database each time I run it right?