Well, for starters, you need to decide what login method you want.... Windows security (where Integrated Security = SSPI) or SQL Authentication (where you set password AND User ID). Using both doesn't work very well.

Then once you have decided that, then you need to make sure the correct Windows login (if you use Integrated Security) or the SQL Login (if you use SQL Authentication) has been set up for that user.

-tg