If you have stumbled with the error "Error: Property MustChangePassword is not available for login.." or same as the picture show below: To solve the issue either you have to take out the "enforce password policy" using SA privileges or if you are the database owner then delete and re-create the user, with the “enforce password policy†box unchecked....(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/08/07/error-property-mustchangepassword-is-not-available-for-login.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1303" width="1" height="1">