It seems a new feature fo MSSQL 2005 is that any new accounts have to change their password at first logon. This is kind of a pain, since most people don't 'logon' to their accounts, at least for me because I do web programming. How is my website going to change its password?

Luckyliy I found a must change post with some tsql to do the trick:
ALTER LOGIN X WITH PASSWORD = 'Y'

That bit will unlock the account so you can use it.

I'm not a tsql guy, so maybe this is easy for some people, but for a guy just trying to store some information in a DB, this was a pain. It made a routine task of setting up a user into a 30 min hair tear.

Thanks to Peter for the tip.