Monday, November 26, 2012

How to solve error 15128 in Microsoft Sql Server ?

If you ever meet this nice Sql Error, 15128 in Microsoft Sql Error you must do these next steps. At least they worked for me :)
First I want to explain which is the scenario. You are logged with Windows Authentication and you created a new sql login. Now you want to disable Enforce Password Policy. When you want to do that Sql tells you that you can not save the user, a new password must be set. Strange...so:

  • double click on new login created, leave the check boxes checked(enforce password policy and enforce password expiration) and change user's password temporally to what ever you want, click OK
  • then reopen and uncheck enforce password policy, enforce password expiration; Press OK
  • finally you reopen the user and specify the password you want
  • Test it ;)
Hope this will help you.

11 comments:

  1. Great, it worked - Thank you.

    ReplyDelete
  2. Perfect!!!!!!!!! yiiiijaaaaa

    ReplyDelete
  3. Yesss!!!!!!! thanks!!!!

    ReplyDelete
  4. Excellent help. Many thanks!

    ReplyDelete
  5. Gracias me ayudo mucho ! Thank you ! man

    ReplyDelete
  6. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Microsoft SQL Server, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Microsoft SQL Server. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/



    ReplyDelete
  7. Really it was an awesome article...very interesting to read..You have provided an nice article..We also provide ms sql Corporate training, sql server 2016 training..Thanks for sharing..

    ReplyDelete
  8. Contact to Microsoft SQL Server Support if PHP with MS SQL Server not Working
    At the point when any new client first time makes PHP frame and need to present the shape information to MS SQL Server yet anyway they are not ready to do this due to some specialized issues, and color to absence of specialized abilities they are not ready to tackle this issue. All things considered you need to run with Remote Infrastructure Management Support for Microsoft SQL Server or Online MS SQL Server Support. You can uninhibitedly make any inquiry and get best help through our devoted specialized specialists.
    For More Info: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    ReplyDelete