Im unable to install a clean 7.5 site.
Ive tried installing a clean site without success.
Tried new site both with and without alloy templates. I get the below exception.
Server 2008 r2 64 bit with sql express.
Started a transacted installCopying C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\application to C:\EPiServer\CMS75\wwwrootCopying C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin to C:\EPiServer\CMS75\wwwroot\binproductPath: C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\installedVersion: 0.0.0.0frameworkVersion: 7.5.394.2AppData path: C:\EPiServer\CMS75\appdataApplying web config modification for EPiServer Framework 6.0.318.113Applying web config modification for EPiServer Framework 18.104.22.168Applying web config modification for EPiServer Framework 6.2.267.1Applying web config modification for EPiServer Framework 7.5.394.2Removing assembly redirect for EPiServer.Shell.UISkipping EPiServer.Shell.UI since assembly redirects are not foundCopying C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\bin to C:\EPiServer\CMS75\wwwroot\binAssembly redirect for EPiServer.ApplicationModules.dllAdding/Updating assembly redirect for EPiServer.ApplicationModulesAssembly redirect for EPiServer.Data.Cache.dllAdding/Updating assembly redirect for EPiServer.Data.CacheAssembly redirect for EPiServer.Data.dllAdding/Updating assembly redirect for EPiServer.DataAssembly redirect for EPiServer.Events.dllAdding/Updating assembly redirect for EPiServer.EventsAssembly redirect for EPiServer.Framework.dllAdding/Updating assembly redirect for EPiServer.FrameworkAssembly redirect for EPiServer.Licensing.dllAdding/Updating assembly redirect for EPiServer.LicensingAssembly redirect for EPiServer.Shell.dllAdding/Updating assembly redirect for EPiServer.ShellAssembly redirect for Newtonsoft.Json.dllAdding/Updating assembly redirect for Newtonsoft.JsonAssembly redirect for StructureMap.dllAdding/Updating assembly redirect for StructureMapAdding/Updating assembly redirect for System.Web.MvcInstalling Add-Ons:Id : EPiServer.PackagingTitle : EPiServer Add-On Store PlatformVersion : 3.0.1845Id : EPiServer.Packaging.UITitle : EPiServer Add-On Store UIVersion : 3.0.1845Id : ShellTitle : EPiServer UI PlatformVersion : 3.0.1209Copying C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Geolocation to C:\EPiServer\CMS75\appdata\GeolocationAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\Castle.Core.dllAdding/Updating assembly redirect for Castle.CoreAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\Castle.Windsor.dllAdding/Updating assembly redirect for Castle.WindsorAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.BaseLibrary.dllAdding/Updating assembly redirect for EPiServer.BaseLibraryAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.Configuration.dllAdding/Updating assembly redirect for EPiServer.ConfigurationAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.dllAdding/Updating assembly redirect for EPiServerAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.Enterprise.dllAdding/Updating assembly redirect for EPiServer.EnterpriseAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.ImageLibrary.dllAdding/Updating assembly redirect for EPiServer.ImageLibraryAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.Implementation.dllAdding/Updating assembly redirect for EPiServer.ImplementationAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.LinkAnalyzer.dllAdding/Updating assembly redirect for EPiServer.LinkAnalyzerAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.UI.dllAdding/Updating assembly redirect for EPiServer.UIAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.Web.WebControls.dllAdding/Updating assembly redirect for EPiServer.Web.WebControlsAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.WorkflowFoundation.dllAdding/Updating assembly redirect for EPiServer.WorkflowFoundationAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiServer.XForms.dllAdding/Updating assembly redirect for EPiServer.XFormsAssembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\log4net.dllAdding/Updating assembly redirect for log4netInstalling Add-Ons:Id : CMSTitle : EPiServer Edit UIVersion : 3.0.1097Id : EPiServer.SuiteTitle : EPiServerVersion : 7.5.394Executing database script "C:\Users\Administrator\AppData\Local\Temp\tmp8F18.tmp"Executing database script "C:\Users\Administrator\AppData\Local\Temp\tmp8FC4.tmp"productPath: C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Database\sql\EPiServer.Data.sql"An error has occured and the transaction will be rolled backRolledbackIncorrect syntax near the keyword 'as'.Incorrect syntax near the keyword 'as'.An unhandled error has occured:Incorrect syntax near the keyword 'as'.When executingAt C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Install\System Scripts\Install Site (SqlServer).ps1:139 char:26+ Execute-EPiSqlSvrScript <<<< `True=Get-EPiIsBulkInstallingAn unhandled error has occured:Incorrect syntax near the keyword 'as'.When executingAt C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Install\System Scripts\Install Site (SqlServer).ps1:139 char:26+ Execute-EPiSqlSvrScript <<<< `True=Get-EPiIsBulkInstallingAn unhandled error has occured:Incorrect syntax near the keyword 'as'.When executingAt C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Install\System Scripts\Install Site (SqlServer).ps1:139 char:26+ Execute-EPiSqlSvrScript <<<< `=Get-EPiIsBulkInstallingAt C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Install\System Scripts\Install Site (SqlServer).ps1:139 char:26+ Execute-EPiSqlSvrScript <<<< `System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'as'. at EPiServer.Install.SqlServer.Installers.SqlServerItemInstaller.HandleSqlException(SqlCommand cmd, SqlException ex) at EPiServer.Install.SqlServer.Installers.SqlScriptInstaller.ExecuteSqlScript(String filePath, IDictionary parameters, IDictionary stateSaver) at EPiServer.Install.SqlServer.Installers.EPiServerSqlScriptInstaller.InstallInternal(IDictionary stateSaver) at EPiServer.Install.SqlServer.Installers.EPiServerSqlScriptInstaller.Install(IDictionary stateSaver) at EPiServer.Install.InstallationManager.Install(Installer installer) at EPiServer.Install.SqlServer.SqlServerInstallationManager.ExecuteDatabaseScript(String sqlServerName, Nullable`1 sqlServerPort, String databaseName, String loginName, String loginPassword, String scriptFilePath, Boolean avoidDbTransaction, Boolean isEPiServerScript, IDictionary parameters) at EPiServer.Install.SqlServer.Cmdlets.ExecuteSqlScriptCmdlet.ProcessRecord() at System.Management.Automation.Cmdlet.DoProcessRecord() at System.Management.Automation.CommandProcessor.ProcessRecord()ClientConnectionId:7e9d64f0-8870-4372-9691-e9d8598293a5
Read the stack trace, I think maybe something wrong with the network log-on account using for SQL server (SQLExpress) service. Try this: Select SQL Server (SQLExpress) service Properties >> Log On tab >> Set Log on as = Local System account (instead of Network service) then restart the service.
I have EPiServer 5,6 and 7.1 on the same machine installed with windows authentication in deployment center withouot any problem.
I changed the log on user without success.
I can install a 7.0 site with no problems.
Hey Per, I ran into the same problem. I uninstalled and then re-installed the 7.5 with administrative rights <- not sure if it mattered but it seem to have fixed my issue, either the reinstall or doing it with admin rights. Worth a shot.
I still cannot do a site upgrade from 7.1 up to 7.5 though. It errors on me every time, i have tried countless times so i will keep plugging away and see what i manage to come up with.
Joshua: What is the error you are getting when upgrading?
That error can occour if you install on a SQL 2005 instance. EPiServer 7.5 requires SQL 2008 or later.
Thansks for the input Joshua and Johan. Will have another go at it tonight.
Hey linus, I can't recall off the top of my head, i will give it a shot again this afternoon and post the error. Thanks
Hey Linus, I should have clarified, it wasn't so much the upgrade, that worked, but bringing up the site is what bombed out. I found the issue(s) and seems to be add on modules from episerver (episerver google analytics and such) do not get upgraded. I have removed the module from the Modules vpp. I also found structure map was wrong or it could be our config transforms which i have updated to your version which still loaded the old structure map. Not sure what all gets updated during the upgrade but seems both sites i tried had a structure map issue. Just some food for thought.
Did you run "Upgrade/Disable Add-ons after Product Upgrade" from the Deployment Center (step #13 in the upgrading documentation)? This will upgrade all system add-ons and disabled all non-system add-ons on the upgraded site. The disabled non-system add-ons can be upgraded and enabled later from the add-ons administration web interface, when the site will be up and running.
Hey Sergil, Its funny cause I did read this step and went line for line but failed to do it at the end. JOKES ON ME. Thanks Sergil.
Johan: You were right I was running a 2005 version of express. Installed 2012 and now everything worked.
i am also unable to install a clean 7.5 site. I have tried installing a clean site without success. i have Server 2008 r2
Tried new site both with and without alloy templates. I get the below exception.
Incorrect syntax near the keyword 'as'.
this is same error which Per Nergård got. Per ! did you managed with SQL Server 2008 ?
Naeem: I installed a 2012 sql express instance. But Johan said it should work with 2008 so then it should.
Ok. but I tried many time with 2008 but did not worked.
Can you ensure (e.g. by Sql Configruation Manager) that you do not have a SQL 2005 also running. Perhaps there is e.g. a SQL Express 2005 instance running side by side.
If you open up Deployment Center and selects "Install site and SQL Server database", in the step for database which database instance do you see and is that a SQL 2008 instance?