You create a user in Sql server add the username and password to your web.config, hock up the DALC and run your web app then bam, ERROR.
When creating a user on Sql 2005 make sure that the following checkboxes are not checked otherwise it could lead to confusion for a couple of minutes. Doh!