Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Microsoft SQL Server, Error: 18456 Expand / Collapse
Author
Message
Posted Thursday, November 22, 2007 7:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Thursday, November 22, 2007 7:20 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 3:22 AM
Points: 3,906, Visits: 1,098
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
Posted Tuesday, May 25, 2010 7:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 2, 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
Posted Tuesday, May 25, 2010 7:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 2, 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 »

Add to briefcase

Permissions Expand / Collapse