Symptoms
---------------------------
FRx Reporting Engine
---------------------------
-2147217911 - [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'Table_Name', database 'Database_Name', owner 'dbo'.
---------------------------
OK Cancel
---------------------------
This error occurs when generating a report.
Cause
The user's database login has not been granted the db_datareader role for the database.
Resolution
Grant the user's Microsoft SQL Server login access to the database(s) for which they are generating reports and give them the db_datareader fixed database role.