Even if it is a valid user at the database, do you have the select permission on the objects that you need or are you calling a stored procedure that you need to provide the execute permission on maybe?