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

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

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

maqk

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
Greenstrike

that did it.

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

thanks a million.

we should call you Mr. Geniusmeyer!!!
Koding
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
Kallex
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
---
saffy_in_aus
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
---
NickNotYet

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
JuKiM
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
---
qrli
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
Error: 18456, Severity: 14, State: 11.

Answer this question