Results 1 to 8 of 8

Thread: Native Error 18456 !!!! Help!!!!

  1. #1
    Join Date
    Feb 2008
    Posts
    17

    Unhappy Native Error 18456 !!!! Help!!!!

    Hi all,

    Ms SQL Server Native Error 18456 !! Login Failed.

    Pls help me out.

    Thanx in Advance

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you specify correct sql instance name, logon id and password?

  3. #3
    Join Date
    Feb 2008
    Posts
    17
    the authentication mode is 'windows authentication', i still get the error.

    the error state is '1' ? what does this mean?
    Last edited by aruopna; 02-26-2008 at 12:47 AM.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Did you add your windows account as sql login in sql server yet?

  5. #5
    Join Date
    Feb 2008
    Posts
    17
    ya i've already added it before. still the error persists.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Which app did you get this error from? Is sql instance name correct?

  7. #7
    Join Date
    Feb 2008
    Posts
    17
    i had no other go.... so i recreated the login n the credentials are accepted now.

    thanx a ton for your time,rmiao

  8. #8
    Join Date
    Feb 2008
    Posts
    17
    today i went thru this url http://blogs.msdn.com/sql_protocols/...21/536201.aspx

    didn help me though !!

    Cheers

    A

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •