20536: Unable to logon server

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.

ThanksHigher 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

2006-09-13 15:24:18.07 Logon Error: 18456, Severity: 14, State: 16.

well this is a strange one.

i have a sql 2005 server express running on a pc. it has an xp embedded database on it.

i can connect to it from one pc using component database manager.

however, if i try this from another pc it fails with the following code

2006-09-13 15:24:18.07 Logon Error: 18456, Severity: 14, State: 16.
2006-09-13 15:24:18.07 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]
.

i have simple file sharing turned of on the remote pc that fails to connect.

what is my problem.

YOu will have to disable simple filesharing at the WIndows box, because the user will be otherwise authenticated by the Guest user.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

This has been done on both db client pcs the one that failed and the one that succeded.

explorer->tools->folder options->view->Use simple file sharing checkbox.

i unchecked this checkbox.

i then rebooted the client pc.

thanks,

|||

Logon Error: 18456, Severity: 14, State: 11.

I'm using Sql server 2005 on vista.....

please give me some hints to solve the problem, thanks a lot!

Min

2006-09-13 15:24:18.07 Logon Error: 18456, Severity: 14, State: 16.

well this is a strange one.

i have a sql 2005 server express running on a pc. it has an xp embedded database on it.

i can connect to it from one pc using component database manager.

however, if i try this from another pc it fails with the following code

2006-09-13 15:24:18.07 Logon Error: 18456, Severity: 14, State: 16.
2006-09-13 15:24:18.07 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]
.

i have simple file sharing turned of on the remote pc that fails to connect.

what is my problem.

YOu will have to disable simple filesharing at the WIndows box, because the user will be otherwise authenticated by the Guest user.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

This has been done on both db client pcs the one that failed and the one that succeded.

explorer->tools->folder options->view->Use simple file sharing checkbox.

i unchecked this checkbox.

i then rebooted the client pc.

thanks,

|||

Logon Error: 18456, Severity: 14, State: 11.

I'm using Sql server 2005 on vista.....

please give me some hints to solve the problem, thanks a lot!

Min