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.

14 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. 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
  7. 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
  8. Brainy Provide education franchise opportunity and online education business opportunities along with how to start online education franchise business and investment information and complete course structure for 7-12 years kids.
    Here are some secrets for successful education franchise opportunity in India

    ReplyDelete