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

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!

×