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