Hello,
I try to install Lansweeper 3.2 on a french Windows XP Pro SP3 workstation for testing purpose. I installed IIS and SQL Server Express 2005. Windows updates have been applied.
When I try to install Lansweeper I get this error message :
Build Database Objects
Error: Msg 1033, Level 15, State 1, Server MYTESTPC, 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.
As I first tried with a French version of SQL server, I thought it was some kind of french/english language-based issue so I uninstalled everything except IIS, and then reinstalled SQL Server Express 2005 english version but I still get the same error when installing Lansweeper.
The error message does not block installation, Lansweeper is (nearly) working and I can import workstation's data, but the result is that I can't access to the "Domains" part of the Lansweeper webpage.
Here is what appear instead of the Domains tab :
System.Data.SqlClient.SqlException: Invalid object name 'dbo.web30totaldomain'.
à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
à System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
à System.Data.SqlClient.SqlDataReader.get_MetaData()
à System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
à System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
à System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
à System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
à System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
à System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
à System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
à System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
à DreamweaverCtrls.DataSet.DoInit()
Any idea ?
I try to install Lansweeper 3.2 on a french Windows XP Pro SP3 workstation for testing purpose. I installed IIS and SQL Server Express 2005. Windows updates have been applied.
When I try to install Lansweeper I get this error message :
Build Database Objects
Error: Msg 1033, Level 15, State 1, Server MYTESTPC, 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.
As I first tried with a French version of SQL server, I thought it was some kind of french/english language-based issue so I uninstalled everything except IIS, and then reinstalled SQL Server Express 2005 english version but I still get the same error when installing Lansweeper.
The error message does not block installation, Lansweeper is (nearly) working and I can import workstation's data, but the result is that I can't access to the "Domains" part of the Lansweeper webpage.
Here is what appear instead of the Domains tab :
System.Data.SqlClient.SqlException: Invalid object name 'dbo.web30totaldomain'.
à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
à System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
à System.Data.SqlClient.SqlDataReader.get_MetaData()
à System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
à System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
à System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
à System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
à System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
à System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
à System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
à System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
à DreamweaverCtrls.DataSet.DoInit()
Any idea ?
