Step 3 - SQL CE 4 Database Connection Initialisation Failed
Hi All,
Trying to do an installation of v 4.7 on Windows Server 2008 R2 x64 w/ SP1 (IIS 7.5) and am unable to get the SQL CE 4 database configuration step to complete.
Installation Steps:
Clean installation of 2008 R2 x64 w/ SP1 and all other available updates
Installation of MS Web Platform Installer (WPI) along with FF and Chrome browsers
Launched Umbraco 4.7 installation via WPI and it completed with no errors (dated 3/15/2011)
--- I seem to remember previous versions asking database questions during the WPI install but that did not happen with 4.7, has that been removed with the support of CE 4.0 being added?
Added application pool (we'll call it myAppPool) and set it to use .Net 4.0 (v4.0.30319)
Assigned Umbraco (Default Web Site) to use my application pool
At Step 3, I select the option to use SQL CE 4 and click Install and receive "Database connection initialisation failed"
At this point I checked permissions and IIS_IUSR has read access all the way down and myAppPool has modify access all the way down. I tried changing both of these to have Full Control all the way down with no change to the behavior.
Assume that I restarted IIS a pile of times.
I've also tried doing the manual install as well as not using a custom application pool with the exact same results.
Just want to mention that once you have downloaded the WebDeploy package you should just overwrite the bin folder with the one from the package and you should be good to go :-)
I am having the same issue. I got the WebDeploy package. Did all the IIS permissions NETWORK SERVICE access to all, Set the appPool to 4.0.
Restarted IIS, still can't get the SQL CE to be successful. Getting "Database connection initialisation failed". Insanely frustrating. I love using Umbraco, but local installation shouldn't be hard.
I agree Umbraco is the greatest thing since sliced bread. It can be a pain in the ass to get working though. Well I always seem to have some problem. I might be incompetant though. Actually that's probably the real cause :)
Anyway, I just had this issue. For some reason or other the Web platform installer didn't install windows CE4. So if you go open that up click Products -> Database -> Make sure Microsoft Sql Server Compact 4 is installed. (I also have the tools installed)
Step 3 - SQL CE 4 Database Connection Initialisation Failed
Hi All,
Trying to do an installation of v 4.7 on Windows Server 2008 R2 x64 w/ SP1 (IIS 7.5) and am unable to get the SQL CE 4 database configuration step to complete.
Installation Steps:
At this point I checked permissions and IIS_IUSR has read access all the way down and myAppPool has modify access all the way down. I tried changing both of these to have Full Control all the way down with no change to the behavior.
Assume that I restarted IIS a pile of times.
I've also tried doing the manual install as well as not using a custom application pool with the exact same results.
Can anyone provide any suggestions?
Thank you in advance,
Rick
Hi Rick,
Did you download and use the WebDeploy package? Only the WebDeploy one has the Microsoft SQL CE runtime files and installer.
Have a look http://umbraco.codeplex.com/releases/view/62573 under Other Available Downloads for Umbraco 4.7.0 WebDeploy .net 4.0
Ben
Just want to mention that once you have downloaded the WebDeploy package you should just overwrite the bin folder with the one from the package and you should be good to go :-)
Hope this helps.
/Jan
I am having the same issue. I got the WebDeploy package. Did all the IIS permissions NETWORK SERVICE access to all, Set the appPool to 4.0.
Restarted IIS, still can't get the SQL CE to be successful. Getting "Database connection initialisation failed". Insanely frustrating. I love using Umbraco, but local installation shouldn't be hard.
Hello,
I agree Umbraco is the greatest thing since sliced bread. It can be a pain in the ass to get working though. Well I always seem to have some problem. I might be incompetant though. Actually that's probably the real cause :)
Anyway, I just had this issue. For some reason or other the Web platform installer didn't install windows CE4. So if you go open that up click Products -> Database -> Make sure Microsoft Sql Server Compact 4 is installed. (I also have the tools installed)
Hope that helps
is working on a reply...