Microsoft KB Archive/40807

= PRB: SQL Server Msg 4002: Login Failed; Login Incorrect =

Article ID: 40807

Article Last Modified on 12/3/2003

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 6.5 Service Pack 1
 * Microsoft SQL Server 6.5 Service Pack 2
 * Microsoft SQL Server 6.5 Service Pack 3
 * Microsoft SQL Server 6.5 Service Pack 4
 * Microsoft SQL Server 6.5 Service Pack 5a

-



This article was previously published under Q40807



SYMPTOMS
When attempting to log in to SQL Server with a valid login and password, the user receives the following error message:

Msg 4002: Login Failed; Login Incorrect

WORKAROUND
Check for the message &quot;Server booted in single user mode&quot; among the initialization messages in the errorlog file. If this message is present, restart the server without the /m parameter (/m represents single-user mode).



CAUSE
If SQL Server was started in single-user mode, this message appears when subsequent users attempt to log in.

On a case-sensitive server, this message appears if the case in the user name does not match the actual case of the user name in the server.



STATUS
Additional query words: case Windows NT

Keywords: kbother kbprb KB40807

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.