Login error is really what?

Question

Post reply

Login error is really what?

Ron McCullough

SSC Guru

Points: 63877
More actions
March 10, 2008 at 8:51 pm

#204222

Comments posted to this topic are about the item Login error is really what?
If everything seems to be going well, you have obviously overlooked something.
Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Vivien Xing SSChampion Points: 12297 More actions · Answer 1

A good question.

What is the difference between 8 and 9?

8 Password mismatch

9 Invalid password

matzer SSCrazy Eights Points: 9727 More actions · Answer 2

A very good question, indeed! My BOL (September 2007) says:

8 The password is incorrect.

9 Password is not valid.

Peter

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 3

bitbucket,

Can you explain the difference between those two terms? I Google'd about, but all I found is the source that you cited.

In the case of "password mismatch" what action should be taken, if any?

This QOD raises more questions than it answers.

GSquared SSC Guru Points: 260824 More actions · Answer 4

Vivien Xing (3/10/2008)
A good question.
What is the difference between 8 and 9?
8 Password mismatch
9 Invalid password

"State 8 means that the password specified for the user is incorrect. State 9 means that the password was rejected by the password policy check as invalid - the policy API has rejected the password...." - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=841565&SiteID=1

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Ron McCullough SSC Guru Points: 63877 More actions · Answer 5

For further discussion see the blog post by

Il-Sung Lee Program Manager, SQL Server Protocols

at http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Benki Chendu SSCrazy Eights Points: 8051 More actions · Answer 6

I have a SQL 2008 named instance installed.

I am able to login through sa login from the server and from other servers as well.

But the customer is not able to connect to the server, even though he is locally connected to the server through RDP and trying to use the sa credentials.

This is the error message:

Message

Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]

Message

Error: 18456, Severity: 14, State: 8.

same credentials are working when I am trying from other servers.