Login failed password did not match for SQL loin

Question

Post reply

Login failed password did not match for SQL loin

solomon.jernas

Hall of Fame

Points: 3680
More actions
May 8, 2016 at 8:07 am

#313840

Hi ,
I am getting error when i login SQL Server 2012 ' Login failed password did not match"
buit i can login via SQLCMS command prompt , it works fine,
Can you anyone help to me, I am getting error SQL login via connecting SQL mangement studio?
Why it is bug or anything missing in mangent stdion, also passwork typing very slow response.
Please anyone help to me.
Regards,
Jerry

Viewing 15 posts - 1 through 15 (of 23 total)

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 1

Can you post the full error message including error numbers?

😎

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 2

Error:

Login Failed for user 'APP' Reason Password did not matche that for the login provided

Error No : 18456 : Serverity 14 State 8

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 3

solomon.jernas (5/9/2016)
Error:
Login Failed for user 'APP' Reason Password did not matche that for the login provided
Error No : 18456 : Serverity 14 State 8

The password is incorrect, suggest de-registering from SSMS and register again with the correct password.

😎

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 4

password is correct, because i can connect through SQLCMD tool.

Only problem in connecting via SSMS.

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 5

solomon.jernas (5/9/2016)
password is correct, because i can connect through SQLCMD tool.
Only problem in connecting via SSMS.

The message is literally saying that the password does not match, could be mis-cased or misspelled. Did you try what I suggested?

😎

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 6

The problem faced after VM ESX host changed , I can login via SQLCMD command prompt the same password. it works.

may be profile corrupted or anything

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

Are you trying to connect to the same server?

Do you have the port number correct?

Are you sure you have the username/password the same? I ask again because, as Eirikur pointed out, the error message is saying otherwise.

You mentioned a change in VM. Is that the VM the SQL Server is on or does ESX refer to your local machine?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 8

Her my problems is , SQL user can connect from other remote sql SSMS without any issue.

Local server i can connect via SQLCMD command promt the same sql user works fine,

But i am unable login only local via SSMS.. i given correct password --

when i typying password box... very slow response....

Phil Parkin SSC Guru Points: 246962 More actions · Answer 9

Maybe something in this link[/url] will be of use.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 10

SQl Port 1433 is listeneing on,

Still i am not get correct way to resolve. i guess ssms got corrupted.

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 11

SQL port 1433 is listening on, but getting password did not match, even i given correct password in SSMS .

i guess problem may be SSMS corrupted.

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 12

solomon.jernas (5/9/2016)
SQL port 1433 is listening on, but getting password did not match, even i given correct password in SSMS .
i guess problem may be SSMS corrupted.

You seem to be stuck on one login / password problem. May I suggest creating a new login / password combo and trying both in SSMS and SQLCMD? Let us know which one works.

Also, how are you running SQLCMD? Via SSMS or via a command prompt window? Are you using a file to run your connection or connecting manually?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Grumpy DBA SSChampion Points: 12515 More actions · Answer 13

Brandie's suggestions are solid, please try those and report back.

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 14

So if SSMS is working from another machine, maybe you should try refreshing the dns cache on the one you are having an issue from.

You mentioned that the ESX host changed.