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
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
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!