Post reply

SQL Error 15128

  • October 20, 2009 at 10:09 am

    #215771

    Receive the error 15128 because MUST_CHANGE is on. How to get around this. This is a sql acocunt and should not have a password that expires.

  • October 20, 2009 at 12:35 pm

    #1068441

    Remove the Enforce password policy. You can use the GUI to do that.

    -Roy

  • October 20, 2009 at 1:01 pm

    #1068457

    Do you mean the SQL GUI?

  • October 20, 2009 at 1:04 pm

    #1068461

    SSMS SQL Server Management studio. Or you can do it using T-SQL. ALTER LOGIN

    -Roy

  • October 20, 2009 at 1:20 pm

    #1068474

    I tried both ways alter login and then ssms. Both ways gave me the error.

    This is what I did to get around the issue.

    I logged in to SSMS using the sql account. When prompted to change the password I did. The sql account had sysadmin role. I opened up the sql account login and unchecked the 2 options for password expiration and the other option and it worked without error.

    with all that said, I am wondering if it has something to do with the security of the user who logged that defined the sql account. That login should have been able to make that change.

  • October 20, 2009 at 4:51 pm

    #1068594

    The interface has to be aware of the password change ability. So if you're using an older client (not SQL Server Native Client), they'll get the error that says they can't login, but they won't be able to do so because that interface won't present the change password prompt.

    K. Brian Kelley
    @kbriankelley

  • April 28, 2010 at 7:02 am

    #1158872

    What you also can do:

    -In MSSMS

    -Activate the user property

    -change to a temporary password then save and close

    -activate again and then disable Enforce Password

    -than save with the original password

    Enjoy!

  • November 28, 2011 at 1:54 pm

    #1413643

    HI Thank you so much this this worked for me ...:-)

  • July 19, 2012 at 6:04 am

    #1514777

    Thanks Patti - you saved what is left of my sanity.

  • January 15, 2015 at 9:49 am

    #1770507

    //** Use this query and you will all set**//txtPost_CommentEmoticon(':-)');

    USE Master

    GO

    ALTER LOGIN SQL_Account WITH PASSWORD = ‘currentpassword(SamePassword)’

    GO

    ALTER LOGIN SQL_Account WITH

    CHECK_POLICY = OFF,

    CHECK_EXPIRATION = OFF;:-)

Viewing 10 posts - 1 through 9 (of 9 total)

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