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

    Wednesday, September 13, 2006 12:55 PM

Answers

All replies

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

    Wednesday, September 13, 2006 2:12 PM
    Moderator
  • that did it.

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

    thanks a million.

    we should call you Mr. Geniusmeyer!!!

    Wednesday, September 13, 2006 2:41 PM
  • 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

     

    Wednesday, September 13, 2006 6:19 PM
  • 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
    ---

    Wednesday, September 13, 2006 8:16 PM
    Moderator
  • 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?

    Wednesday, September 13, 2006 8:37 PM
  • 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
    ---
    Saturday, September 16, 2006 2:29 PM
    Moderator
  • 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
    Monday, April 30, 2007 11:47 PM
  • 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

    Thursday, May 31, 2007 5:18 AM