November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
Installation SQL error - very strange - EPiServer CMS 5.2.375.236
Hi Alex,
By any chance are you running Sql 2000 ? Have you seen forum post below:
http://world.episerver.com/Templates/Forum/Pages/thread.aspx?id=24748
/Shahid
Feb 03, 2010 9:43
Hi Shahid
Thanks for the reply and no (obviously!) I hadn't as that's the same problem :-)
Interestingly the post mentions that the installer may be updated to check the version of SQL, however if so it didn't detect on ours....
We'll update the SQL and see how we get on!
Regards Alex
Feb 03, 2010 11:44
This thread is locked and should be used for reference only.
Hi
We are installing EPiServer CMS for the first time, and have everything configured quite happily as far as we can tell, however when the EPiServer Deployment Center tries to run the SQL to install the demo site, it is giving a syntax error as below.
At C:\Program Files\EPiServer\CMS\5.2.375.236\Install\System Scripts\Install Database (SqlServer).ps1:119 char:18
+ New-EPiSqlSvrDB <<<< `
=
Get-EPiIsBulkInstalling
Error - System.Management.Automation.CmdletInvocationException: Line 23: Incorrect syntax near '('. ---> System.Data.SqlClient.SqlException: Line 23: Incorrect syntax near '('.
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.CreateDatabase(String sqlServerName, Nullable`1 sqlServerPort, String databaseName, String loginName, String loginPassword, String epiServerSqlScriptPath, Boolean isEPiServerScript, Boolean installAspNetSchema, Boolean installWFSchema, Int32 progressPercent)
at EPiServer.Install.SqlServer.Cmdlets.NewDatabaseCmdlet.ProcessRecord()
at System.Management.Automation.Cmdlet.DoProcessRecord()
at System.Management.Automation.CommandProcessor.ProcessRecord()
--- End of inner exception stack trace ---
at System.Management.Automation.Internal.PipelineProcessor.SynchronousExecuteEnumerate(Object input, Hashtable errorResults, Boolean enumerate)
at System.Management.Automation.PipelineNode.Execute(Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)
at System.Management.Automation.StatementListNode.ExecuteStatement(ParseTreeNode statement, Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)
EPiServer CMS 5.2.375.236
We've re-read the installation instructions a number of times however keep getting this error so any suggestions as to how to fix it please?
Many thanks!