none
The password of the account has expired

    Question

  • Ok I am a newbie.

    I have been building some sites with asp.net

    So I got a MS SQL server from fasthosts and all was going well until today when my websites are returing this message

    http://www.miraquel.com/

    Login failed for user 'MiraUser02'.  Reason: The password of the account has expired.

    http://www.shop.westmidlands-turf-topsoil.co.uk/products/index.aspx

    Login failed for user 'shopwestmiduser453'.  Reason: The password of the account has expired.

    These sites were fine a few days ago.

    How do I fix this problem?

    Which password has expried?

    Any help most appreciated.

    No-one at Fasthosts had ever seen this error message before!

    All the best.

     

    Charles Willcock

     

    and

     

     

    Monday, April 18, 2011 7:52 PM

Answers

All replies

  • The login with which your application account connects to SQL server has expired . You might have to reset the password in SQL server for this login and re-enter the new password in your connection string and alternatively you can also remove or untick the ENFORCE PASSWORD POLICY and EXPIRATION if you dont want to manually change the password and edit your connection string everytime it expires.

    ALTER LOGIN login_name WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF


    Thanks, Leks
    Monday, April 18, 2011 8:46 PM
  • Leks,

    Many thanks for these comments.

    Unforutnately MSSQL and user names and passwords there are so many. Is this this the 

    MS SQL Username: which seems to have the default username sa and then the password?

     

    Or are you referring to each website, has its own settings and the username and password for each site?

    Kind regards

     

    Charles

     

     

     


    Charles Willcock
    Monday, April 18, 2011 9:25 PM
  • I am reffering to the one which is mentioned in the application connection string.
    Read your errorlog in SQL server and that will give you an error message about which login has expired and from there you can work your way through to fix the login issue by resetting its passowrd.

    Connect to management studio , and open new query windows and run SP_READERRORLOG and scroll through


    Thanks, Leks
    Monday, April 18, 2011 9:33 PM
  • OK many thanks I have run the query and the results are all my databases require the password to be changed.

     

    Well to my total astonishment I have changed the password in the two places I am guessing I needed to change it and my website is working again.

     

    I am most grateful for your help.

    How often do I have to change these passwords?

     

    http://www.shop.westmidlands-turf-topsoil.co.uk/products/index.aspx

     

    Kind regards

     

    Charles


    Charles Willcock
    Monday, April 18, 2011 10:08 PM
  • Yeah you are right , you have to change the passwords in connection string(applications) as well. The password policy change depends on your windows password policy defined - More info here http://technet.microsoft.com/en-us/library/ms161959.aspx
    Thanks, Leks
    Monday, April 18, 2011 10:17 PM
  • Not sure if I marked your help successfully I wanted to give you a 10/10 but the system seemed to give you one but for me that was a 10/10.

     

    Time for bed it is going on towards midnight here in the UK.

     

    Cheers

     

    Charles


    Charles Willcock
    Monday, April 18, 2011 10:39 PM
  • thank you, it helped :)
    Thursday, June 27, 2013 5:10 PM