Login failed for user ”. Reason: The password of the account must be changed.
When you created the login, did you specify the MUST_CHANGE option of CREATE LOGIN or, if you used Management Studio, did you leave the box checked that says, “User must change password at next login? If you did, that’s what’s wrong. Change the password and you’ll be back in business.
Version: VS 2008, ASP.NET 3.5, C#,SQL Server 2005, SQL Management Studio Express