ID Number: Q40807
1.11 4.20
OS/2
Summary:
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
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.
RESOLUTION
Check for the message "Server booted in single user mode" 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).
Additional reference words: case single user