Build Database Objects error during installation

[Northern]

Hello.

I hope to get some help on my issue in this forum.

I installed Lansweeper 3.2 on a Server 2003 enterprise running as a virtual machine under VMware ESXi. Database system is MS SQL server 2005 Express. I followed the installation documentation.

The installation process hangs for a minute or two on "Running Postinstall tasks... Building Lansweeper Database Objects..." At the end of the installation process, I get this error message:

Installation Error Log
Som errors occurred during install

Build Database Objects
Error: Msg 1033, Level 15, State 1, Server LANSWEEPER, Procedure web30totaldomain, Line 13The ORDER BY clause is invalid in views, inline functions, derivedtables, subqueries, and common table expressions, unless TOP or FORXML is also specified.

When I open the Web Console, the main part of Digital Dashboard shows this:

System.Data.SqlClient.SqlException: Invalid object name 'dbo.web30totaldomain'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
at DreamweaverCtrls.DataSet.DoInit()


What could be wrong with my installation?

[Northern]

Thank you for your help. I did like OMenor, and downloaded a fresh installer. It works fine now.

[Hemoco]

See this thread : http://forum.lansweeper.com/yaf_postst810_Database-error-during-installation.aspx