Ben Sullins (4/14/2008)
Yeah so if you're data set(s) read directly from the database then you need to make sure the account you're using has db_datareader on whatever DB's it is reading from. If you're calling a stored proc (recomended) then the user account must have execute privileges on the stored proc and must also be a db_datareader in the databases from which the stored proc calls.
Not to take away from what Ben is saying, but watch out with this. db_datareader grants select permissions to all tables and views in the database. For most environments this is not appropriate, especially if you are granting users access via their Windows logins. It's just asking for someone to steal your data - a least permissive model with only EXEC on reporting procs and minimal direct SELECT access to tables/views is generally better.
Regards,
Jacob