Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
May 09, 2012 08:26 AM|LINK
Since you have created a new user, you must have to attache the user with the database.
go to Security->Logins and open the properties of the new user.
select User Mapping. check the database and write the default schema as dbo.
check the db_owner and public from the lower checkboxlist.
then press ok.
now try to login.