-2147217911 - [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'Table_Name', database 'Database_Name', owner 'dbo'.


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.

References