I have a question/statement on this issue.
I've been setting up database driven web sites and due to the issuses with the SA user name and password, i have create unique logins with passwords.
I suppose i better add that i have been using DSN-less connnection, i haven't had any problems using this method.