Installation SQL error - very strange - EPiServer CMS 5.2.375.236



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



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!

Feb 02, 2010 16:47

Here's a screen shot of the error too just in case that helps!

Feb 02, 2010 16:55

Hi Alex,

By any chance are you running Sql 2000 ? Have you seen forum post below:


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

Also the link in that post to the system requirements is giving a 404 error, so the latest one seems to be....

Feb 03, 2010 11:45
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.