Are you using a SQL Server account to create the database or using NT Authentication?
The way I did it was to have a blank database created, add the user to the new database, then assign db_datawriter, db_datareader and db_ddladmin roles to the user.
