cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ademirkiran
Engaged Sweeper
Hello,

Lansweeper server didn't add any clients to dashboard. here is all information about my system.

I installed lansweeper free version to sql server. lansweeper service is starting with domain admin account.

Sql Server 2000 installed on the server. i set firewall port for listening to all domain computers (9524). finally i applied startup.vbs to default domain policy.

it looks everyting is ok. when i want to make connection tester for client i got this message.

Remote WMI test
-----------------------------------------------
Found: Microsoft Windows XP Professional Service Pack 3
\root\cimv2 Remote WMI access test OK

Remote Registry test using WMI
-----------------------------------------------
Found: Microsoft Windows XP Service Pack 3
\root\default Remote WMI access test OK

also when i write to internet explorer address bar http://localhost:9524 on the server. i can see that.

Congratulations, your lansweeper service is running

Freeware version - Active scanning disabled

Total computers processed: 255

In queue 0 In process 1 Threads running 1
desk08 desk08

BUT!! there is a log file in c:\Program Files\lansweeper\Service folder. errorlog.txt there is those error messages for all computers.

17.11.2009 10:45:52: DESK08 DISPLAYCONTRCONF General error
konum: System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
konum: System.Management.ManagementPath.GetManagementPath(IWbemClassObjectFreeThreaded wbemObject)
konum: System.Management.ManagementObject.GetManagementObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementBaseObject.GetBaseObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementObjectCollection.ManagementObjectEnumerator.get_Current()
konum: LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

17.11.2009 10:53:06: DESK08 'Lastknownip' sütunu, mytable tablosuna ait değil. (column is not belong to mytable table.)
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)


What's wrong? i need help.

Thanks


10 REPLIES 10
isomaniac
Engaged Sweeper
merhaba,

Aynı problemi ben de yaşamaktayım ve 2 gündür bir türlü çözemedim. collation ayarlarını tam olarak ne yaptınız acaba ve nasıl yaptınız? yardımcı olursanız sevinirim.

teşekkürler.
Hemoco
Lansweeper Alumni
Could you check the collation of our datase (if it's case sensitive) (it shouldn't be)
Lansweeper wrote:
Could you check the collation of our datase (if it's case sensitive) (it shouldn't be)


I changed regional settings to english from Turkish. now lansweeper has seen 64 computers.

thank you very much.
Hemoco
Lansweeper Alumni
Do you have sql management studio installed?
If yes could you post a screenshot of the design of "tblcomputers" please.
Lansweeper wrote:
Do you have sql management studio installed?
If yes could you post a screenshot of the design of "tblcomputers" please.




I Have SQL Server 2000. Thank you very much.
ademirkiran
Engaged Sweeper
18.11.2009 11:22:53: Stopping service

18.11.2009 11:22:55: Database connection successful, starting up service

18.11.2009 11:32:42: AKTAYSRV 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 11:33:51: ELAFB00 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 11:34:07: ELAFB00 DISPLAYCONTRCONF Genel hata
konum: System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
konum: System.Management.ManagementPath.GetManagementPath(IWbemClassObjectFreeThreaded wbemObject)
konum: System.Management.ManagementObject.GetManagementObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementBaseObject.GetBaseObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementObjectCollection.ManagementObjectEnumerator.get_Current()
konum: LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

Hemoco
Lansweeper Alumni
Could you restart the service and post the complete errorlog afterwards please.
Lansweeper wrote:
Could you restart the service and post the complete errorlog afterwards please.


18.11.2009 09:00:28: Database connection successful, starting up service

18.11.2009 09:00:28: ELATM02 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:00:50: ELATM02 DISPLAYCONTRCONF Genel hata
konum: System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
konum: System.Management.ManagementPath.GetManagementPath(IWbemClassObjectFreeThreaded wbemObject)
konum: System.Management.ManagementObject.GetManagementObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementBaseObject.GetBaseObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementObjectCollection.ManagementObjectEnumerator.get_Current()
konum: LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

18.11.2009 09:01:00: ELAOM11 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:01:10: ELAFM20 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:01:30: ELAOM11 DISPLAYCONTRCONF Genel hata
konum: System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
konum: System.Management.ManagementPath.GetManagementPath(IWbemClassObjectFreeThreaded wbemObject)
konum: System.Management.ManagementObject.GetManagementObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementBaseObject.GetBaseObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementObjectCollection.ManagementObjectEnumerator.get_Current()
konum: LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

18.11.2009 09:01:44: ELASL17 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:04:14: ELAOM00 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:08:35: ELAIK00 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:12:05: ELAHK00 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:12:33: ELAFM22 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:12:36: ELASL01 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:13:01: ELASA03 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:15:40: ELAEM04 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:16:13: ELAEM04 DISPLAYCONTRCONF Genel hata
konum: System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
konum: System.Management.ManagementPath.GetManagementPath(IWbemClassObjectFreeThreaded wbemObject)
konum: System.Management.ManagementObject.GetManagementObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementBaseObject.GetBaseObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementObjectCollection.ManagementObjectEnumerator.get_Current()
konum: LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

18.11.2009 09:19:53: ELAEM01 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:20:25: ELAEM01 DISPLAYCONTRCONF Genel hata
konum: System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
konum: System.Management.ManagementPath.GetManagementPath(IWbemClassObjectFreeThreaded wbemObject)
konum: System.Management.ManagementObject.GetManagementObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementBaseObject.GetBaseObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementObjectCollection.ManagementObjectEnumerator.get_Current()
konum: LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

18.11.2009 09:20:36: ELAFM00 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:20:56: ELAMI00 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:21:14: ELAMI00 DISPLAYCONTRCONF Genel hata
konum: System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
konum: System.Management.ManagementPath.GetManagementPath(IWbemClassObjectFreeThreaded wbemObject)
konum: System.Management.ManagementObject.GetManagementObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementBaseObject.GetBaseObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementObjectCollection.ManagementObjectEnumerator.get_Current()
konum: LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

18.11.2009 09:24:29: ELAMI01 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:27:28: ELAKM00 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:28:13: ELASA00 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:38:09: AKTAYSRV 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:58:51: ELAEB08 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 09:59:15: ELAEB08 DISPLAYCONTRCONF Genel hata
konum: System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
konum: System.Management.ManagementPath.GetManagementPath(IWbemClassObjectFreeThreaded wbemObject)
konum: System.Management.ManagementObject.GetManagementObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementBaseObject.GetBaseObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementObjectCollection.ManagementObjectEnumerator.get_Current()
konum: LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

18.11.2009 10:08:30: AKTAYSRV 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 10:11:09: ELASPA02 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 10:33:58: ELASRV01 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 10:42:46: ELAFB05 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 11:07:12: ELATM01 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 11:07:24: ELATM01 DISPLAYCONTRCONF Genel hata
konum: System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
konum: System.Management.ManagementPath.GetManagementPath(IWbemClassObjectFreeThreaded wbemObject)
konum: System.Management.ManagementObject.GetManagementObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementBaseObject.GetBaseObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementObjectCollection.ManagementObjectEnumerator.get_Current()
konum: LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

18.11.2009 11:09:10: ELAFM06 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 11:09:59: ELAFM06 DISPLAYCONTRCONF Genel hata
konum: System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
konum: System.Management.ManagementPath.GetManagementPath(IWbemClassObjectFreeThreaded wbemObject)
konum: System.Management.ManagementObject.GetManagementObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementBaseObject.GetBaseObject(IWbemClassObjectFreeThreaded wbemObject, ManagementScope scope)
konum: System.Management.ManagementObjectCollection.ManagementObjectEnumerator.get_Current()
konum: LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

18.11.2009 11:19:12: AKTAYSRV 'Lastknownip' sütunu, mytable tablosuna ait değil.
konum: System.Data.DataRow.GetDataColumn(String columnName)
konum: System.Data.DataRow.set_Item(String columnName, Object value)
konum: LansweeperService.mdllogon.LSLogon(LS_Computer& mycomputer, SqlConnection& sqlcon)

18.11.2009 11:22:53: Stopping service

18.11.2009 11:22:55: Database connection successful, starting up service

Hemoco
Lansweeper Alumni
Was this an upgrade or a new installation?
It looks like you are missing a part of the database.