locked
Web Matrix and SQL Server CE not installed on web server RRS feed

  • Question

  • User1387288263 posted
    We are receiving an error while deploying a Starter Site from the WebMatrix templates. After the site is deployed and we navigate to its url we are receiving the following error:

    The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail. (Exception from HRESULT: 0x800736B1) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
    And in the event log of the web server we see this:<o:p></o:p>Activation context generation failed for "D:\WebSites\Account\yourdomain.com\wwwroot\bin\x86\sqlceme40.dll". Dependent Assembly Microsoft.VC90.CRT,processorArchitecture="x86",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="9.0.30729.4148" could not be found. Please use sxstrace.exe for detailed diagnosis.<o:p></o:p>After you manually coping the SQL CE .dll file over the error goes away, as explained in this readme http://www.asp.net/webmatrix/readme look half way down for: Issue: Deploying an application to a computer that does not have SQL Server Compact installed.<o:p></o:p>Shouldn't Web Matrix automatically copy these files over to the web server to run if the server does not have SQL CE installed?<o:p></o:p>

    Any insight on this matter would be greatly appreciated.

     

    Wednesday, January 19, 2011 3:23 PM

Answers

  • User1387288263 posted

    Guys,

     I deleted the whole site, re-deployed from a new WebMatrix template and the site failed. I copied over the Microsoft.VC90.CRT.manifest file and the site runs without error.

    I have tried this on multiple PC (xp and vista). In-addition we have two "New" customers expirencing the issue as well !

    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Friday, January 21, 2011 8:45 AM

All replies

  • User-359244760 posted

    Hello,

    Could you confirm what versions of the following you are running:

    • WebMatrix on the client? Is it RTM?
    • SQL CE on the client?
    • .NET on the server? 3.5 or 4.0?
    Wednesday, January 19, 2011 8:07 PM
  • User1387288263 posted

    We are running the following:

    • WebMatrix version on the client = 1.0.1042
    • SQL CE version on the client = 4.0.8422.1
    • .NET version on the server = 4.0
    Wednesday, January 19, 2011 9:54 PM
  • User-359244760 posted

    You should have both 3.5 and 4.0 on the server. (This is because there will be apps that require one or the other framework version installed.) Is this the case?

    Wednesday, January 19, 2011 10:12 PM
  • User1387288263 posted

    yes, both 3.5 SP1 and 4.0

    Wednesday, January 19, 2011 10:26 PM
  • User1230680471 posted

    I looked at the versions you are using and they don't seem to match the released versions.

     Can you please verify you are running the RTM V1.0 builds?

    Also is it possible to try this with a fresh site on client and server without copying the dlls manually and send us the publishing log (which you can get by openning the log and right click on the log window, then choose copy all.

    Yishai
    The WebMatrix Team

    Thursday, January 20, 2011 1:21 AM
  • User1387288263 posted

    I found the version in "Add and Remove Programs" by clicking the "Click here for support info" link for each program. The version numbers I gave you have the actual build numbers as well. Is there a better place to get the version for each app?

    Please let me know what version you expect including the build so we can all be sure.

     Also, I have created a new fresh site using the WebMatrix Starter Site template. I got the same result as mention previously and have included the publishing log below. I have tested this on many PCs with same results.

    8:08:04 AM: Adding MSDeploy.IisApp (MSDeploy.IisApp).
    8:08:04 AM: Updating createApp (whg.testdomain.net).
    8:08:04 AM: Adding child dirPath (whg.testdomain.net\Account).
    8:08:04 AM: Adding child dirPath (whg.testdomain.net\App_Data).
    8:08:04 AM: Adding child dirPath (whg.testdomain.net\bin).
    8:08:04 AM: Adding child dirPath (whg.testdomain.net\bin\AMD64).
    8:08:04 AM: Adding child dirPath (whg.testdomain.net\bin\AMD64\Microsoft.VC90.CRT).
    8:08:04 AM: Adding child dirPath (whg.testdomain.net\bin\System.Data.SqlServerCe.Entity).
    8:08:04 AM: Adding child dirPath (whg.testdomain.net\bin\X86).
    8:08:04 AM: Adding child dirPath (whg.testdomain.net\bin\X86\Microsoft.VC90.CRT).
    8:08:04 AM: Adding child dirPath (whg.testdomain.net\Styles).
    8:08:04 AM: Adding setAcl (whg.testdomain.net/App_Data).
    8:08:06 AM: Updating createApp (whg.testdomain.net).
    8:08:06 AM: Adding child filePath (whg.testdomain.net\About.cshtml).
    8:08:07 AM: Adding child filePath (whg.testdomain.net\Account\AccountLockedOut.cshtml).
    8:08:07 AM: Adding child filePath (whg.testdomain.net\Account\ChangePassword.cshtml).
    8:08:07 AM: Adding child filePath (whg.testdomain.net\Account\Confirm.cshtml).
    8:08:07 AM: Adding child filePath (whg.testdomain.net\Account\ForgotPassword.cshtml).
    8:08:07 AM: Adding child filePath (whg.testdomain.net\Account\Login.cshtml).
    8:08:07 AM: Adding child filePath (whg.testdomain.net\Account\Logout.cshtml).
    8:08:07 AM: Adding child filePath (whg.testdomain.net\Account\PasswordReset.cshtml).
    8:08:07 AM: Adding child filePath (whg.testdomain.net\Account\Register.cshtml).
    8:08:07 AM: Adding child filePath (whg.testdomain.net\Account\Thanks.cshtml).
    8:08:07 AM: Adding child filePath (whg.testdomain.net\App_Data\StarterSite.sdf).
    8:08:31 AM: Adding child filePath (whg.testdomain.net\bin\AMD64\Microsoft.VC90.CRT\msvcr90.dll).
    8:08:31 AM: Adding child filePath (whg.testdomain.net\bin\AMD64\sqlceca40.dll).
    8:08:31 AM: Adding child filePath (whg.testdomain.net\bin\AMD64\sqlcecompact40.dll).
    8:08:31 AM: Adding child filePath (whg.testdomain.net\bin\AMD64\sqlceer40EN.dll).
    8:08:31 AM: Adding child filePath (whg.testdomain.net\bin\AMD64\sqlceme40.dll).
    8:08:31 AM: Adding child filePath (whg.testdomain.net\bin\AMD64\sqlceqp40.dll).
    8:08:31 AM: Adding child filePath (whg.testdomain.net\bin\AMD64\sqlcese40.dll).
    8:08:31 AM: Adding child filePath (whg.testdomain.net\bin\Microsoft.Web.Infrastructure.dll).
    8:08:31 AM: Adding child filePath (whg.testdomain.net\bin\Microsoft.Web.Infrastructure.xml).
    8:08:31 AM: Adding child filePath (whg.testdomain.net\bin\NuGet.Core.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Data.SqlServerCe.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Data.SqlServerCe.Entity\System.Data.SqlServerCe.Entity.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.Helpers.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.Helpers.xml).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.Razor.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.Razor.xml).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.WebPages.Administration.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.WebPages.Deployment.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.WebPages.Deployment.xml).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.WebPages.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.WebPages.Razor.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.WebPages.Razor.xml).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\System.Web.WebPages.xml).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\WebMatrix.Data.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\WebMatrix.Data.xml).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\WebMatrix.WebData.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\WebMatrix.WebData.xml).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\X86\Microsoft.VC90.CRT\msvcr90.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\X86\sqlceca40.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\X86\sqlcecompact40.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\X86\sqlceer40EN.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\X86\sqlceme40.dll).
    8:09:01 AM: Adding child filePath (whg.testdomain.net\bin\X86\sqlceqp40.dll).
    8:09:06 AM: Adding child filePath (whg.testdomain.net\bin\X86\sqlcese40.dll).
    8:09:06 AM: Adding child filePath (whg.testdomain.net\Default.cshtml).
    8:09:06 AM: Adding child filePath (whg.testdomain.net\favicon.ico).
    8:09:06 AM: Adding child filePath (whg.testdomain.net\robots.txt).
    8:09:06 AM: Adding child filePath (whg.testdomain.net\Styles\Site.css).
    8:09:06 AM: Adding child filePath (whg.testdomain.net\web.config).
    8:09:06 AM: Adding child filePath (whg.testdomain.net\_AppStart.cshtml).
    8:09:06 AM: Adding child filePath (whg.testdomain.net\_SiteLayout.cshtml).
    8:09:06 AM: Updating setAcl (whg.testdomain.net/App_Data).
    8:09:06 AM: Publish completed.
     

    Thursday, January 20, 2011 8:24 AM
  • User1230680471 posted

    Good morning and thanks for your quick response,

    The SQL Compact version expected is 4.0.8482.1, it might be that you just had a typo since the numbers look similar enough.

    Also can you please attach a recursive irectory listing of the bin folders in the site, both right after publishing and after your manually fixed it?, please make sure it includes at least the file names, file size, date and time and all sub folders and files.

    I'm also interested to know if publishing through FTP protocol works in your case.

    Thanks again,
    Yishai
    The WebMatrix Team

    Thursday, January 20, 2011 10:34 AM
  • User1387288263 posted

    Hi Yishai,

    I did typo the version, it is 4.0.84.82.1. I tried FTP as well and the app also fails with the same errors.

    Here is a list of the directorys:

    Failing Site after WebDeploy or FTP:
    - Bin Folder -
    01/20/2011  12:31 PM    <DIR>          AMD64
    01/20/2011  12:32 PM    <DIR>          System.Data.SqlServerCe.Entity
    01/20/2011  12:32 PM    <DIR>          X86
    01/20/2011  12:32 PM            45,416 Microsoft.Web.Infrastructure.dll
    01/20/2011  12:32 PM             1,469 Microsoft.Web.Infrastructure.xml
    01/20/2011  12:32 PM           192,888 NuGet.Core.dll
    01/20/2011  12:32 PM           465,248 System.Data.SqlServerCe.dll
    01/20/2011  12:32 PM           130,408 System.Web.Helpers.dll
    01/20/2011  12:32 PM            48,745 System.Web.Helpers.xml
    01/20/2011  12:32 PM           178,536 System.Web.Razor.dll
    01/20/2011  12:32 PM            90,485 System.Web.Razor.xml
    01/20/2011  12:32 PM           121,704 System.Web.WebPages.Administration.dll
    01/20/2011  12:32 PM            25,960 System.Web.WebPages.Deployment.dll
    01/20/2011  12:32 PM               967 System.Web.WebPages.Deployment.xml
    01/20/2011  12:32 PM           136,552 System.Web.WebPages.dll
    01/20/2011  12:32 PM            37,224 System.Web.WebPages.Razor.dll
    01/20/2011  12:32 PM             6,890 System.Web.WebPages.Razor.xml
    01/20/2011  12:32 PM            70,721 System.Web.WebPages.xml
    01/20/2011  12:32 PM            36,712 WebMatrix.Data.dll
    01/20/2011  12:32 PM             6,927 WebMatrix.Data.xml
    01/20/2011  12:32 PM            63,848 WebMatrix.WebData.dll
    01/20/2011  12:32 PM            20,860 WebMatrix.WebData.xml

    - Bin\AMD64 Folder -
    01/20/2011  12:31 PM    <DIR>          Microsoft.VC90.CRT
    01/20/2011  12:31 PM           462,688 sqlceca40.dll
    01/20/2011  12:31 PM           104,288 sqlcecompact40.dll
    01/20/2011  12:31 PM           154,464 sqlceer40EN.dll
    01/20/2011  12:31 PM            80,736 sqlceme40.dll
    01/20/2011  12:31 PM           908,128 sqlceqp40.dll
    01/20/2011  12:32 PM           543,072 sqlcese40.dll

    - Bin\ADM64\Microsoft.VC90.CRT Folder -
    01/20/2011  12:31 PM           624,448 msvcr90.dll

    - Bin\X86 Folder -
    01/20/2011  12:32 PM    <DIR>          Microsoft.VC90.CRT
    01/20/2011  12:32 PM           349,536 sqlceca40.dll
    01/20/2011  12:32 PM            88,416 sqlcecompact40.dll
    01/20/2011  12:32 PM           153,952 sqlceer40EN.dll
    01/20/2011  12:32 PM            66,912 sqlceme40.dll
    01/20/2011  12:32 PM           642,400 sqlceqp40.dll
    01/20/2011  12:32 PM           387,424 sqlcese40.dll

    - Bin\X86\Microsoft.VC90.CRT Folder -
    01/20/2011  12:32 PM           653,120 msvcr90.dll

    - Bin\System.Data.SqlServerCe.Entity Folder -
    01/20/2011  12:32 PM           239,968 System.Data.SqlServerCe.Entity.dll
     

    Working Site after Manual Copy of the bin folder:
    - Bin Folder -
    01/20/2011  12:31 PM    <DIR>          AMD64
    01/20/2011  12:32 PM    <DIR>          System.Data.SqlServerCe.Entity
    01/20/2011  12:32 PM    <DIR>          X86
    01/20/2011  12:18 AM            71,016 Microsoft.Web.Helpers.dll
    01/05/2011  05:45 PM            45,416 Microsoft.Web.Infrastructure.dll
    12/20/2010  12:52 PM             1,469 Microsoft.Web.Infrastructure.xml
    12/20/2010  03:37 PM           192,888 NuGet.Core.dll
    01/06/2011  12:36 AM           465,248 System.Data.SqlServerCe.dll
    01/19/2011  01:02 PM           239,968 System.Data.SqlServerCe.Entity.dll
    01/05/2011  05:45 PM           130,408 System.Web.Helpers.dll
    12/20/2010  01:59 AM            48,745 System.Web.Helpers.xml
    01/05/2011  05:45 PM           178,536 System.Web.Razor.dll
    12/20/2010  12:52 PM            90,485 System.Web.Razor.xml
    01/05/2011  05:45 PM           121,704 System.Web.WebPages.Administration.dll
    01/05/2011  05:45 PM            25,960 System.Web.WebPages.Deployment.dll
    12/20/2010  12:52 PM               967 System.Web.WebPages.Deployment.xml
    01/05/2011  05:45 PM           136,552 System.Web.WebPages.dll
    01/05/2011  05:45 PM            37,224 System.Web.WebPages.Razor.dll
    12/20/2010  12:52 PM             6,890 System.Web.WebPages.Razor.xml
    12/20/2010  01:59 AM            70,721 System.Web.WebPages.xml
    01/05/2011  05:45 PM            36,712 WebMatrix.Data.dll
    12/20/2010  01:59 AM             6,927 WebMatrix.Data.xml
    01/05/2011  05:45 PM            63,848 WebMatrix.WebData.dll
    12/20/2010  01:59 AM            20,860 WebMatrix.WebData.xml

    - Bin\AMD64 Folder -
    01/20/2011  12:50 PM    <DIR>          Microsoft.VC90.CRT
    01/05/2011  11:48 PM           462,688 sqlceca40.dll
    01/05/2011  11:48 PM           104,288 sqlcecompact40.dll
    01/05/2011  11:48 PM           154,464 sqlceer40EN.dll
    01/05/2011  11:48 PM            80,736 sqlceme40.dll
    01/05/2011  11:48 PM           908,128 sqlceqp40.dll
    01/05/2011  11:48 PM           543,072 sqlcese40.dll

    - Bin\ADM64\Microsoft.VC90.CRT Folder -
    01/19/2011  01:02 PM             1,862 Microsoft.VC90.CRT.manifest
    11/16/2010  01:28 AM           624,448 msvcr90.dll
    01/19/2011  01:02 PM               406 README_ENU.txt

    - Bin\X86 Folder -
    01/20/2011  12:50 PM    <DIR>          Microsoft.VC90.CRT
    01/06/2011  12:12 AM           349,536 sqlceca40.dll
    01/06/2011  12:12 AM            88,416 sqlcecompact40.dll
    01/06/2011  12:12 AM           153,952 sqlceer40EN.dll
    01/06/2011  12:12 AM            66,912 sqlceme40.dll
    01/06/2011  12:12 AM           642,400 sqlceqp40.dll
    01/06/2011  12:12 AM           387,424 sqlcese40.dll

    - Bin\X86\Microsoft.VC90.CRT Folder -
    01/19/2011  01:03 PM             1,860 Microsoft.VC90.CRT.manifest
    07/12/2009  02:02 AM           653,120 msvcr90.dll
    01/19/2011  01:03 PM               406 README_ENU.txt

    - Bin\System.Data.SqlServerCe.Entity Folder -
    01/06/2011  12:36 AM           239,968 System.Data.SqlServerCe.Entity.dll

     

    Thursday, January 20, 2011 12:55 PM
  • User1387288263 posted

    FYI,

    When I copy these files into the  wwwroot\Bin\X86\Microsoft.VC90.CRT Folder and overwriting the "msvcr90.dll" file the error goes away.

    msvcr90.dll

    Microsoft.VC90.CRT.manifest

    README_ENU.txt


     

    Thursday, January 20, 2011 5:15 PM
  • User-1672167363 posted

    Hello @ Simon,

    Question if this is a Publish of applcation to an end user

    shouldn't the Package contain the Dependicies of VC++ Runtime

    as part of delivery and a check for if exists?

    Every thing I have noticed for this as errors are related to the VC++ 2005 verions 8.0 redist.

    Please correct me if I have mis-understood how to package to an end user.

    I have maybe wasted time with including the VS Shared libraries?

    I hope to get your help.

    Martin :)

    Thursday, January 20, 2011 6:22 PM
  • User-1672167363 posted
    Small correction The VC 2008 aka VC 9.0 libraries.
    Thursday, January 20, 2011 6:23 PM
  • User1230680471 posted
    Yes you are correct it looks like the issue is with these DLLs, however they are correctly copied. I'm suspecting the issue is that the manifest file is not copied by our current design. Can you do one more test for me? Publish to a fresh site (which is supposed to fail), then copy only the manifest file to the folder and see if this fixes the problem. Thanks, Yishai
    Thursday, January 20, 2011 6:27 PM
  • User-1672167363 posted

    Hello @ Yishai G.

    I would like to know for my own learning what is the "Best Practice" to get

    proper VC redist on to the server or as part of package?

    I am not trying to confuse the user post I just want to learn.

    Thanks,

    Cheers

    Martin :)

    Thursday, January 20, 2011 6:36 PM
  • User1230680471 posted
    The publishing from WebMatrix (and from Visual Studio) should do it for the user, so there is no need to do anything from the server side and the user side. We are trying to investigate why it does not work in this case, and what should be done further. In all other cases we have seen, you just click publish and the site will run on the server without any issues. It's important to keep this way, so in case Sql Compact gets refreshed and they need to deploy different Dlls, the server does not have to change, and all the user will have to do it republish his site. I hope this helps, please don't hesitate to further ask if it wasn't clear enough Yishai
    Thursday, January 20, 2011 8:22 PM
  • User-1672167363 posted

    Hello @ Yishai G.

    Yes that helped.

    Thank You,

    Martin :)

    Thursday, January 20, 2011 9:42 PM
  • User1387288263 posted

    Guys,

     I deleted the whole site, re-deployed from a new WebMatrix template and the site failed. I copied over the Microsoft.VC90.CRT.manifest file and the site runs without error.

    I have tried this on multiple PC (xp and vista). In-addition we have two "New" customers expirencing the issue as well !

    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Friday, January 21, 2011 8:45 AM
  • User1230680471 posted
    Thanks, that is exactly what I was suspecting. For now the workaround you guys are using is the right one. We will look into this issue and see if we can come up with a fix. But for copying the files manually to your bin folder is the right way to go Thanks for helping getting this thing sorted out Yishai
    Friday, January 21, 2011 12:34 PM
  • User-1364498265 posted

    I've been trying to reproduce the error internally so we can better understand the problem, however, I've been having problems setting up a server that reproduces the error. Could you either shed some more insight about the server configuration you know that causes the problem or would it be possible to get TS information to the server so that I can look at the server's configuration personally? If TS'ing would be possible, feel free to follow up by contacting me at: John.Tabet at microsoft dot com

    Monday, January 31, 2011 4:13 PM
  • User-1848341606 posted

     Thanks Yishai! I also had the same problem. Thank you again.

    Thursday, August 25, 2011 12:26 PM