To add reporting permissions:
- Add the domain account of the user that will run reports to SQL.
- Add the db_datareader role for the user on the database.
- Optional: Add the execute permission for the user on the database.*
* The following reports require the execute permission:
To add the execute permission for the user on the database, open a new query in SQL Management Studio and execute the following:
GRANT EXECUTE TO "DomainUsername"
Reference: Windows Permissions and Enterprise Fax Reporter