Some machines doesn't input data in database.

[mijo]

What could be the reason why some machines doesn't input data in database.
I have also made an exception in firewall on those machines for 9524 port even
turn off the firewall.
I have also start manually LSclient and it says that data is sent but nothing
appears in web console.
Also I have more computers that appears in web console than not.

Have anyone any idea what could be ?

[Hemoco]

The security for your sqlserver is ok (otherwise there won't be data in the tsyserrors table)

You have to look at the security of your user running the service.
Right click on the service/tab Log On/this account (must be an account like "domain\username") with administrative permissions on the clients.
(Don't use local system account)

[Dutchhomer]

How can I check under which user the SQL database is running? I have the same problem..

[mijo]

I know that. I'll investigate it.

[Hemoco]

The user under which the server is running (lsscanner for example) must have administrative permissions on the clients.

[mijo]

OK got it, I am not very familiar with SQL so don't blame me.
I get this error Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)),
which is strange, how could be premisson error if other computer which are on the same domain
doesn't have such problem.

[Hemoco]

No, you need to right click on the table and choose "open table"

[mijo]

I hope I am looking at right place, here's a screen shoot.

http://mihd.net/7r4xvc

[Hemoco]

And you are sure that tsyserrors is empty?

[mijo]

As you can see, I get only info about when user is logged on and that's it.

http://mihd.net/ks7zlh