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.