I have clients that are using BIDS to develop reports.
When they preview a report in BIDS, it nevers completes within the 10 minutes or so that they allow it to work. The query that they are using brings back the result set in Management Studio within seconds for them and me.
The query displays the result set for me in the preview tab in BIDS in seconds.
I believe that it is a security issue. They have read access.
What other access might they need?