A view and a report based on the view are created in a test environment. Permissions on the view are set correctly and the report works with no errors when executed in Enterprise. When using the "Preview" function in Report Designer, however, an error message is displayed:
Error/warning messages:
Tbl:DataBind>Invalid object name 'DS_Custom_Catalog'
Reason:
The connection string for « Report Designer Report Server » uses a different SQL user account which does not have access to the view on the SQL server.
Resolution:
Make sure that all connection strings are using the same user account for accessing the same database, and that this user account has access to the custom view.