Could you please let me know the database you are connecting to, since I've used this functinality many times before and it never asked me to enter database credentials while opening the view but I'm little confused why it is different in your scenario. May be specifying the database your connecting to might through some lime light over the issue.
i am using ingres Vectorwise Database
I have met this issue also, same error message after published the report to server. I was connecting to SQL server, and my account have the select authorization of that view. So I have to use sa account to address that issue, but for other users from non IT department, that way is not available.
Do you have any input regarding this pls?