windows authentication mode fails

Question

hi,

i am using windows 7 64bit installed sql server 2008 r2

am getting an error message when am trying to login as  windows authentication mode

Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

Answer 1

Hi,

Has this ever worked? Can you logon with any Windows accounts? Can you look at the SQL error log and post the entries at the time you try to logon with the Windows account?

---

Sean Massey | Consultant, iUNITE

Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

Answer 2

Hi

Check this KB article

http://support.microsoft.com/kb/925744

Answer 3

If the server encounters an error that prevents a login from succeeding, the client will display the following error mesage.

Msg 18456, Level 14, State 1, Server <server name>, Line 1
Login failed for user '<user name>'

Note that the message is kept fairly nondescript to prevent information disclosure to unauthenticated clients. In particular, the 'State' will always be shown to be '1' regardless of the nature of the problem. To determine the true reason for the failure, the administrator can look in the server's error log where a corresponding entry will be written. An example of an entry is:

2006-02-27 00:02:00.34 Logon Error: 18456, Severity: 14, State: 8.

2006-02-27 00:02:00.34 Logon Login failed for user '<user name>'. [CLIENT: <ip address>]

Error state & description

ERROR STATE	ERROR DESCRIPTION
2 and 5	Invalid userid
6	Attempt to use a Windows login name with SQL Authentication
7	Login disabled and password mismatch
8	Password mismatch
9	Invalid password
11 and 12	Valid login but server access failure
13	SQL Server service paused
18	Change password required
16	The incoming user   does not have permissions to log into the target database

Please click the Mark as Answer or Vote As Helpfulif a post solves your problem or is helpful!