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.


The user's database login has not been granted the db_datareader role for the database.


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.


Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!