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

Question

i am new to sql server 2005 express. I am trying to set up xp embedded database. I am trying to allow remote access to a central xp embedded database. i have the database on the sql server machine.

i am using the component database manager toll on a remote machine so that i can connect to the remote xp embedded database. when i try to connect to the db through sql server i get the following error in the log file.

 

2006-09-12 17:15:10.18 Logon       Error: 18456, Severity: 14, State: 11.
2006-09-12 17:15:10.18 Logon       Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]

 

where HOSTNAME is the hostname of the pc that sql server 2005 is running.

XX.XX.XX.XX is the ip address of the client which is running component database manager tool.

 

what am i doing wrong here.

Answer 1

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
---

Answer 2

that did it.

i dont have any clue why it works. but that did it.

thanks a million.

we should call you Mr. Geniusmeyer!!!

Answer 3

i have another problem.

 

i can connect to the sql server 2005 express from one laptop.

however, if i try from another laptop i get the above error.

what is wrong with the second pc.

 

thanks,

jeff

 

Answer 4

Do you have stored user credentials on that machine ? is the error message the same as the one mentioned in the first post ?

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Answer 5

no the first post was state 11. This error is state 16.

im not sure what stored user credentials are.

are you talking about on the db client machine?

Answer 6

Stored credentials can be found navigating to the to the Control Panel > User Accounts > Choose the User > manage you network accounts. You might have a fixed stored credential enetered there ?

HTH; Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Answer 7

Simple file sharing is not at all enables on my machine. I still have this problem when I tried to connect from a sql server 2000 machine to any other version of sql server using linked server. Please advice

Thanks in advance,
Venkat

Answer 8

Hi, have you ever received an answer or solution to this one?  I am experiencing the same problem, went through all the same steps. Windows has no info on their website that I could find....

 

Thanks,

Regards

JD