Password change error

Question

Password change error

SkyBVI

SSCoach

Points: 15128
More actions
July 29, 2010 at 9:39 am

#146482

When I try to login into the GP application and try to change the password, it gives error:-
The password change failed for an unknown reason.Enter a diff pasword or contact system administrator
In the back end on sql server 2005, i have enabled the enforce password policy for that login
but still i get that error.
Any views?
Thanks,
Sushant
Regards
Sushant Kumar
MCTS,MCP

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

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

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 1

Was the login able to log into the system before the change password attempt? Is it still able to login now? (Just verifying the change is the only thing you've got failing).

Did the app ask for a new password? Does the app allow changing of passwords? -- (different animal from SQL Server or Windows changing it)

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.

SkyBVI SSCoach Points: 15128 More actions · Answer 2

@ brandie

Was the login able to log into the system before the change password attempt? --It asks to change password at the first time new login enters...and then it throws error.

Is it still able to login now? (Just verifying the change is the only thing you've got failing).

Did the app ask for a new password? Does the app allow changing of passwords? -- (different animal from SQL Server or Windows changing it)

--the app asks a new password once a new login tries to enter the application but when the new login enters a diff password, it throws the same error. The app allows changing of password as it is enabled in sql 2005 to enforce password policy.

Thanks,

Sushant

Regards
Sushant Kumar
MCTS,MCP

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 3

sushantkumar1984 (7/29/2010)
The app allows changing of password as it is enabled in sql 2005 to enforce password policy.

Just so you know, these are NOT the same thing. If the application client code does not account for changing passwords, this could be part of your problem. What SQL Server wants is beside the point.

And perhaps I misunderstood you, but it sounds like this is a brand new password and the very first time you're logging it, you're getting a request to change it? Uncheck the "User must change password at Next Login" and see if you can log in then. If you don't have that section checked and are still getting the "change password" problem, then something else is wrong.

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.

SkyBVI SSCoach Points: 15128 More actions · Answer 4

@brandie

that section is unchecked.

Thanks,

Sushant

Regards
Sushant Kumar
MCTS,MCP

2005_DBA Mr or Mrs. 500 Points: 524 More actions · Answer 5

Couple of question with possible solution.

Do your application use same password as SQL server ?

Is there any table in which password updated for aplication ? May be user don't have permission to update that table and pasword change fail.

Is there any kind of DDL trigger created by DBA? Is there any log table which log all changes ? User may need permission to this table in order to change password.

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 6

sushantkumar1984 (7/29/2010)
that section is unchecked.

Then it's time to crack open the application code and see what the login module is trying to do. You need to debug it (or have the developers debug it) step by step.

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.