cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ryan_kotzen
Engaged Sweeper

I Can't open my Lansweeper web console, here's my errorlog :


3/17/2009 3:43:10 PM: Database connection successful, starting up service

3/17/2009 3:43:10 PM: DIDNG3TESTSRV String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at LansweeperService.sweeperthread.UpdateIP(clsComputer mycomputer, SqlConnection& sqlcon)


I Use Windows 2008 server(x64) with default IIS 7, i try install Database and Service on different Computer,
I Use Sql Server 2005 as database server.



13 REPLIES 13
ryan_kotzen
Engaged Sweeper
Still got the same problem,

The statement has been terminated.
at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at LansweeperService.sweeperthread.UpdateIP(clsComputer mycomputer, SqlConnection& sqlcon)
ryan_kotzen
Engaged Sweeper
no, i still use IPv4.

When i open my web Console, here' the Error message :

HTTP Error 403.14 - Forbidden
The Web server is configured to not list the contents of this directory.

Detailed Error Information
==================
Module: DirectoryListingModule
Notification: ExecuteRequestHandler
Handler: StaticFile
Error Code: 0x00000000
Requested URL: http://didng3testsrv:80/lansweeper/
Physical Path: C:\Program Files (x86)\lansweeper\website\
Logon Method: Anonymous
Logon User: Anonymous
ryan_kotzen wrote:
no, i still use IPv4.

When i open my web Console, here' the Error message :

HTTP Error 403.14 - Forbidden
The Web server is configured to not list the contents of this directory.

Detailed Error Information
==================
Module: DirectoryListingModule
Notification: ExecuteRequestHandler
Handler: StaticFile
Error Code: 0x00000000
Requested URL: http://didng3testsrv:80/lansweeper/
Physical Path: C:\Program Files (x86)\lansweeper\website\
Logon Method: Anonymous
Logon User: Anonymous

This seems to be another problem.

Could you apply the other fix, restart the service and see if the problem in your errorlog.txt is fixed please.
Hemoco
Lansweeper Alumni
Do you use ip version 6 on this server?

Could you try the following fix please. (from the sql console)

ALTER TABLE tblComputers ALTER COLUMN LastknownIP varchar(100)