Microsoft SQL Server, Error: 18456

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Microsoft SQL Server, Error: 18456

Microsoft SQL Server, Error: 18456

Rate Topic

Display Mode

Topic Options

Author

Message

aanryn

Posted Thursday, November 22, 2007 7:06 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, October 27, 2009 3:32 AM
Points: 21, Visits: 55

Hai,

I'm using SQL Server 2005 Standard Edition in my windows XP SP2 machine. I have only 1 server to which my 4 client machines are connected. Whenever I'm connecting to my SSMS using my domain account I get an error message indicating ' Login failed for user 'domain name\ account name '. (Microsoft SQL Server, Error: 18456). I have tried with Microsoft's KB Article ID: 889646 and all other kind of stuffs. It's not helping me to sort out this problem. Could anyone help me outta here.

Post #424988

vyas

Posted Thursday, November 22, 2007 7:20 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:02 AM
Points: 3,131, Visits: 1,056

Check server's error log where a corresponding entry will be written.

The key to the message is the 'State' which the server will accurately set to reflect the source of the problem. The common error states and their descriptions are provided in the following table:

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

Post #424992

Clive Chinery

Posted Tuesday, May 25, 2010 7:17 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, September 02, 2011 3:22 AM
Points: 1,227, Visits: 154

vyas (11/22/2007)

Check server's error log where a corresponding entry will be written.

Is this the SQL Server log or the Windows Event Log?
[Edit: The messages appear in both logs, but the entries in the SQL Server Log appear to be the more meaningful]

Post #927434

Clive Chinery

Posted Tuesday, May 25, 2010 7:34 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, September 02, 2011 3:22 AM
Points: 1,227, Visits: 154

From http://www.sqlservercentral.com/Forums/Topic534163-359-1.aspx
state 16 = "default database not accessible"

Post #927453

« Prev Topic | Next Topic »

Permissions