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.
