Problem with ODBC logs Manager and user/password

[mp1]

Hi,

I just testing HM 5.86 with Log Analyzer 5.11.
In HM I already have configured ODBC logging, and it works fine.

Now I want to use this logs for reporting.

Unfortunatelly I have a problem with the odbc logs manager.
It seems that the user and pw will no be saved or ...?

I always get this error:

Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Domäne\Hostname$'

As login information I have domäne\user. As I sayed, the odbc logging via HM works.

What make I wrong?

Thanks in advance

Martin

[Yoorix]

[quote="mp1"]
Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Domäne\Hostname$'[/quote]

This message means you have provided wrong login/password.
I think you should set login/password to your SQL server, not domain username.

Regards,
Yoorix

[mp1]

Thanks for the quck replay,

unfortunatelly it seems, that the user/pw file will not be used.
I can fill in what I want, I always get the same error.

Best regards,

Martin

[Yoorix]

We cannot reproduce such problem.

[quote]I can fill in what I want, I always get the same error. [/quote]

But you said, in HM it works fine.

What user/pw did you provide in HM "Options > Advanced Logs" Section?
You should provide this values into Log Analyzer.

Regards,
Yoorix

[mp1]

In the HM I have no user and pw, because I have slected windows nt authentication in the odbc source.
I also get the same eorror in the Log Analyzer, when I use no user and pw.

I just tried it with sql authentication. Sorry - the same error.

Martin

[Yoorix]

[quote]As login information I have domäne\user[/quote]
Do you try connecting to database using domain\username? I don't think you should do that.

You should login to database using your SQL Server username/password. E.g for MS SQL Server you can use username "sa",etc.

Regards,
Yoorix

[mp1]

Do you try connecting to database using domain\username? I don't think you should do that.

You should login to database using your SQL Server username/password. E.g for MS SQL Server you can use username "sa",etc.

I cound solve the problem now:

I add a 2nd ODBC datasource with SQL Authentication only, now it works

It seems, that i will not work with NT Authentication as in HM do

Thanks again for your help

Martin