OK, so far so good. I had one problem, worked around it, and now want to nail down a "more proper" solution. The problem is that, if you restore the database to a different server, even if all the security is the same, logins are the same, passwords are teh same, it will not behave as you'd like. The user in the database is not associated with the login! And I see no way to fix this with the front-end tools. I've seent he problem before with SQL Server 2000. Now I'm on SQL Server 2005, so I need to do some studying.
But I thought I'd post this, in case someone else can tell me how to fix this faster. I worked around it by creating a new database user with the same login credentials, and giving it DBOwner powers. That's too much power, so I will stay on the path of the "more proper" solution. If I don't hear from anyone, I'll post what I find!
Oh, a mention of the fix might be useful in the tutorial too.