Problem with domain admin account

[paprita]

I've already read this problem in another close topic ...


To All

I am new to Lansweeper 3.51 and I have looked thru several topics before posting this question .. I have loaded an XP Professional sp-3 box with SQL Express .. no problem and connected the box to our Microsoft Domain.. when I go to install Lansweeper .. on the forth page the prompt is:

Lansweeper service needs an administrative Windows account in order to run :

Username dhec\bbmadmin
Password ***
confirm password ***

The user 'bbmadmin' has been given Administrator rights on the box .. included in the administrator local machine ..
when I put the dhec\bbmadmin and the password .. I get a setup error

Setup has detected that user "bbmadmin" has no administrative rights on :DHEC" domain. In order to have lansweeper service up and running, it must be configured to run under an administative account!

Setup can continue with this issue but is highly recommended to be fixed!

I am at a loss .. this is a XP professional box with sp-3 freshly re-formatted .. and I can assure you the bbmadmin AD account has administrative privdliges on the local box.

Any ideas or work arounds ??

I've the same problem with service and DB staying on 2 windows 2008R2 servers ... what can I do?
I'm sure that user is a domain admin ...

[Hemoco]

Sorry to say it but the technical analysis makes absolutely no sense.
The sql queries you see are normal behaviour.

The LDAP query happens in another thread (which doesn't use any sql at that moment)

Now application is in error and it ask LDAP to close by Abandon Request option

121506 11:01:48.5108990 206.5418990 Lansweeperservice.exe 10.bbb.ccc.fff CCCCC.DDDDD.EEEEE.FF LDAP LDAP: Abandon Request, MessageID: 375, AbandonMessageID: 352 {LDAP:554, TCP:553, IPv4:552}

The request does time-out that's indeed the problem but it's not caused by anything related to the sql queries.

Could you try this service (backup your old one first), it should give a better error description on which DC the problem occurs.

http://www.lansweeper.com/debug/service353beta.zip

[paprita]

Any news?

[paprita]

Microsoft support have a response that I try to translate to you:

First of all they don't find any problem on LDAP traffic.
They found a different response from SQL query, coming from a different software configuration or from a compatibility problem.
On Windows 2003 server (the one that go properly) we can found follow frame:

Frame: Number = 743, Captured Frame Length = 256, MediaType = ETHERNET
+ Ethernet: Etype = Internet IP (IPv4),DestinationAddress:[00-19-99-73-0E-44],SourceAddress:[00-15-5D-28-D6-00]
+ Ipv4: Src = 10.bbb.ccc.ddd, Dest = 10.bbb.ccc.eee, Next Protocol = TCP, Packet ID = 23927, Total IP Length = 242
+ Tcp: Flags=...AP..., SrcPort=1322, DstPort=1433, PayloadLen=202, Seq=4229982682 - 4229982884, Ack=4200885472, Win=64990 (scale factor 0x0) = 64990
- Tds: SQLBatch, Version = 7.3 (0x730a0003), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=1322, DstPort=1433, PayloadLen=202, Seq=4229982682 - 4229982884, Ack=4200885472, Win=64990
+ PacketHeader: SPID = 0, Size = 202, PacketID = 1, Window = 0
- SqlBatchData:
+ AllHeadersData: Head Type = MARS Header
SQLText: update tblComputers set lastknownip = '10.bbb.ccc.ddd' where computername = 'BBBBB'

while on Windows 2008 server (the other going bad) we found:

Frame: Number = 21424, Captured Frame Length = 238, MediaType = ETHERNET
+ Ethernet: Etype = Internet IP (IPv4),DestinationAddress:[00-19-99-73-0E-44],SourceAddress:[00-19-99-73-0E-20]
+ Ipv4: Src = 10.bbb.ccc.fff, Dest = 10.bbb.ccc.eee, Next Protocol = TCP, Packet ID = 6236, Total IP Length = 224
+ Tcp: [Bad CheckSum]Flags=...AP..., SrcPort=53598, DstPort=1433, PayloadLen=184, Seq=3200425111 - 3200425295, Ack=291988679, Win=511 (scale factor 0x8) = 130816
- Tds: SQLBatch, Version = 7.3 (0x730a0003), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=53598, DstPort=1433, PayloadLen=184, Seq=3200425111 - 3200425295, Ack=291988679, Win=130816
+ PacketHeader: SPID = 0, Size = 184, PacketID = 1, Window = 0
- SqlBatchData:
+ AllHeadersData: Head Type = MARS Header
SQLText: update tblComputers set lastknownip = '::1' where computername = 'AAAAA'

probably because the SQL update function has IPv6 as default but IPv6 is disable and this must remain disable because my network is on IPv4, yet.

Because it doesn't find any IP, it try with a proxy query

Frame: Number = 24345, Captured Frame Length = 148, MediaType = ETHERNET
+ Ethernet: Etype = Internet IP (IPv4),DestinationAddress:[00-19-99-73-0E-44],SourceAddress:[00-19-99-73-0E-20]
+ Ipv4: Src = 10.bbb.ccc.fff, Dest = 10.bbb.ccc.eee, Next Protocol = TCP, Packet ID = 6321, Total IP Length = 134
+ Tcp: [Bad CheckSum]Flags=...AP..., SrcPort=53598, DstPort=1433, PayloadLen=94, Seq=3200429043 - 3200429137, Ack=291992828, Win=513 (scale factor 0x8) = 131328
- Tds: SQLBatch, Version = 7.3 (0x730a0003), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=53598, DstPort=1433, PayloadLen=94, Seq=3200429043 - 3200429137, Ack=291992828, Win=131328
+ PacketHeader: SPID = 0, Size = 94, PacketID = 1, Window = 0
- SqlBatchData:
+ AllHeadersData: Head Type = MARS Header
SQLText: select * from tblProxy where 1=0

Frame: Number = 25594, Captured Frame Length = 238, MediaType = ETHERNET
+ Ethernet: Etype = Internet IP (IPv4),DestinationAddress:[00-19-99-73-0E-44],SourceAddress:[00-19-99-73-0E-20]
+ Ipv4: Src = 10.bbb.ccc.fff, Dest = 10.bbb.ccc.eee, Next Protocol = TCP, Packet ID = 6327, Total IP Length = 224
+ Tcp: [Bad CheckSum]Flags=...AP..., SrcPort=53598, DstPort=1433, PayloadLen=184, Seq=3200429137 - 3200429321, Ack=291993028, Win=512 (scale factor 0x8) = 131072
- Tds: SQLBatch, Version = 7.3 (0x730a0003), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=53598, DstPort=1433, PayloadLen=184, Seq=3200429137 - 3200429321, Ack=291993028, Win=131072
+ PacketHeader: SPID = 0, Size = 184, PacketID = 1, Window = 0
- SqlBatchData:
+ AllHeadersData: Head Type = MARS Header
SQLText: delete from tblerrors where computername = 'AAAAA' and cfgname = 'PROXY'

It find nothing and report follow error

Frame: Number = 25637, Captured Frame Length = 384, MediaType = ETHERNET
+ Ethernet: Etype = Internet IP (IPv4),DestinationAddress:[00-19-99-73-0E-44],SourceAddress:[00-19-99-73-0E-20]
+ Ipv4: Src = 10.bbb.ccc.fff, Dest = 10.bbb.ccc.eee, Next Protocol = TCP, Packet ID = 6328, Total IP Length = 370
+ Tcp: [Bad CheckSum]Flags=...AP..., SrcPort=53598, DstPort=1433, PayloadLen=330, Seq=3200429321 - 3200429651, Ack=291993049, Win=512 (scale factor 0x8) = 131072
- Tds: SQLBatch, Version = 7.3 (0x730a0003), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=53598, DstPort=1433, PayloadLen=330, Seq=3200429321 - 3200429651, Ack=291993049, Win=131072
+ PacketHeader: SPID = 0, Size = 330, PacketID = 1, Window = 0
- SqlBatchData:
+ AllHeadersData: Head Type = MARS Header
SQLText: INSERT INTO tblerrors (Computername, CFGname, Errortext) SELECT 'AAAAA' AS thecomputer, 'PROXY' AS thesection, 'Classe non valida ' as themessage

Now application is in error and it ask LDAP to close by Abandon Request option

121506 11:01:48.5108990 206.5418990 Lansweeperservice.exe 10.bbb.ccc.fff CCCCC.DDDDD.EEEEE.FF LDAP LDAP: Abandon Request, MessageID: 375, AbandonMessageID: 352 {LDAP:554, TCP:553, IPv4:552}

RFC link

6.9. Abandon Operation

The function of the Abandon Operation is to allow a client to request
that the server abandon an outstanding operation. The Abandon
Request is defined as follows:

AbandonRequest ::= [APPLICATION 16] MessageID

There is no response defined in the Abandon Operation. Upon
transmission of an Abandon Operation, a client may expect that the
operation identityfied by the Message ID in the Abandon Request has
been abandoned. In the event that a server receives an Abandon
Request on a Search Operation in the midst of transmitting responses
to that search, that server should cease transmitting responses to
the abandoned search immediately.

Microsoft says that they can't do anything else but, probably, you can.
Just remember that my network is a Windows 2003 network (all DC are Windows 2003).

I hope you can find a solution.

[i_kulgu]

can you try to get in the SQL server from LSserver ?
(start SQL server management from LSserver and connect to SQL server)

[paprita]

i.kulgu wrote:
can you try to get in the SQL server from LSserver ?
(start SQL server management from LSserver and connect to SQL server)

All direct connection are OK. If I try to connect from LS server to any DC, it works too.

[i_kulgu]

paprita wrote:

i.kulgu wrote:
can you try to get in the SQL server from LSserver ?
(start SQL server management from LSserver and connect to SQL server)

All direct connection are OK. If I try to connect from LS server to any DC, it works too.

Did you tried to connect to your SQL from your Lsserver ?
So you opened SQL manager in Lsserver and tried to connect to your SQL on your SQL server?

[paprita]

i.kulgu wrote:

paprita wrote:

i.kulgu wrote:
can you try to get in the SQL server from LSserver ?
(start SQL server management from LSserver and connect to SQL server)

All direct connection are OK. If I try to connect from LS server to any DC, it works too.

Did you tried to connect to your SQL from your Lsserver ?
So you opened SQL manager in Lsserver and tried to connect to your SQL on your SQL server?

I have opened a case with Microsoft. I'm in touch with an engineer, hoping to have a rapid solution.
I'll give you any information I receive.

[i_kulgu]

Paprita,

Have you tried to give the "domain admin", "local admin" rights on both servers ?
Maybe this can help ?..

And did you tried to ping your SQL server from the Lansweeper server ?

[paprita]

i.kulgu wrote:
Paprita,

Have you tried to give the "domain admin", "local admin" rights on both servers ?
Maybe this can help ?..

I'm not sure about your question ... the account that I use to connect to both server is in Domain Admin group and it's in both servers administrators groups.

i.kulgu wrote:
And did you tried to ping your SQL server from the Lansweeper server ?

I did, of course ... ;-)))