See CREATE LOGIN command (SQL 2005 and later).

>
>I don't know why, but Windows Authentication fails intermittently. Even after a user is connected, it sometime fails with connection errors. I'm not as SQL savvy as I'd like to be, so I don't exactly understand the problem.
>
>However, I set up a SQL login and it seems to work ok. But I have one question:
>
>If I set up a login with sp_addlogin, using T-SQL how do I force the user to change their PW?
>