20536: Unable to logon server

[caryraleigh]

I have VB 6.0 Application calling Crystal Report 7.0 based on SQL Server 2000 datbase.

I use the LogonServer method with parameter p2ssql.dll to make the database connection.

I have used the above method for my Crystal Report for last 6 years and worked fine until now but now I get the "20536: Unable to logon server " in few XP OS machines.

This again works in the test XP machine I have used, I have almost tried all things I can try to fix the problem.

Does anyone have similar problems and if so how they dealt with it.

Any help in this regard is highly appreciated.

Thanks

[springsoft]

Higher security levels in XP, at a guess.
Do you have subreports??
If so, you may find that before your OS was allowing subreports to use login info from parent report, but now is breaking because OS demands you supply login info for each subreport.
In which case. iterate thru subreports collection and supply same login info to each subreport.


dave